PHP - How can mysql_fetch_array give me selected returns?

Question

So basically, i'm trying to make some sort of timeline with the post of my users, that gives me the posts of all users ordered by time. But instead, gives me the following:

*User1  'post1',
 User1  'post2',
 User1  'post3'..

*User2  'post1',
 User2  'post2',
 User2  'post3'..

I want all the post ordered instead of all the posts from user1 then all the posts from user2, etc. Well i hope it made sense thank you guys.

The query

  <?php
$varq1 = mysql_query('SELECT id2 FROM followers WHERE id ="'.$_SESSION['id'].'"');
    while($req5 = mysql_fetch_array($varq1)){

$req9=$req5['id2'];
$nsql = mysql_query('SELECT content, id, profile_id FROM contenido WHERE profile_id in("'.$req9.'") order by content_time desc');**strong text**
while($nrow = mysql_fetch_array($nsql)){    
?>

The HTML/ php call

<div class="divider">
<center><?php echo  "".$nrow['content'].""; ?><center/>
</div>

I really hope you've escaped everything you've put into that query with mysql_real_escape_string. There's a reason mysql_query is deprecated and should not be used in new applications, and it's that the interface is dangerous by default, prone to SQL injection bugs of the worst kind. — tadman
– tadman, Commented Nov 30, 2012 at 5:29
Please don't use mysql_* functions in new code. They were removed from PHP 7.0.0 in 2015. Instead, use prepared statements via PDO or MySQLi. See Why shouldn't I use mysql_* functions in PHP? for more information. — Daedalus
– Daedalus, Commented Nov 30, 2012 at 5:31

Karim Magdy Mansour · Accepted Answer · 2012-11-30 05:29:11Z

1

you can do both queries in a single one ... giving you the ability to sort by time

select content,id, profile_id from contenido where profile_id in (SELECT id2 FROM followers WHERE id ="'.$_SESSION['id'].'") order by content_time desc

fetch that and you will have exactly what you want :) all the posts from different users sorted by time.

answered Nov 30, 2012 at 5:29

Karim Magdy Mansour

3162 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Aaron Over a year ago

omg it worked, thank you!! sorry i can't give you a vote up, it says i need 15 rep, and this is my first question.

Daedalus Over a year ago

@Aaron , That's why you can accept the answer instead(do this by clicking the outlined checkmark under the down arrow). It gives more rep anyway.

Aaron Over a year ago

Alright, but quick follow up question, what if i want to include the 'pictures' from another table into that query that you provided, lets say: mysql_query("SELECT reference,description FROM user_photos WHEREprofile_id='".$row['id']."' order by id desc");

Aaron Over a year ago

In the above code i meant "order by time_pic". Any help is appreciated.

Karim Magdy Mansour Over a year ago

sorry for the late replay "i was sleeping :)" anyway its easy all you have to do is join 2 tables together.. in this way select contenido.content,contenido.id, contenido.profile_id from contenido join user_photos on contenido.profile_id = user_photos.profile_id where contenido.profile_id in (SELECT id2 FROM followers WHERE id ="'.$_SESSION['id'].'") order by contenido.content_time desc

|

Barmar · Accepted Answer · 2012-11-30 05:30:43Z

0

'SELECT id2, content, c.id, profile_id
FROM followers f JOIN contenido c ON profile_id = id2
WHERE f.id = "'.$_SESSION['id']"'
ORDER BY content_time DESC, id2

answered Nov 30, 2012 at 5:30

Barmar

789k57 gold badges554 silver badges669 bronze badges

Comments

Ketan Patel · Accepted Answer · 2012-11-30 05:34:31Z

0

Plz Use This Code Then Check

<?php
$varq1 = mysql_query('SELECT id2 FROM followers WHERE id ="'.$_SESSION['id'].'"');
while($req5 = mysql_fetch_array($varq1)){

$req9=$req5['id2'];
$nsql = mysql_query('SELECT content, id, profile_id FROM contenido WHERE profile_id='".$req9."' order by content_time desc');/*strong text*/
while($nrow = mysql_fetch_array($nsql)){    
?>
<div class="divider">
   <center><?php  '". echo $nrow['content']."'; ?><center/>
</div>

answered Nov 30, 2012 at 5:34

Ketan Patel

113 bronze badges

1 Comment

Aaron Over a year ago

It didn't work as i wanted, but i guess i forgot to include important details, anyways thanks.

Collectives™ on Stack Overflow

PHP - How can mysql_fetch_array give me selected returns?

3 Answers 3

9 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

9 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related