mysql_fetch_assos result one

[brianjamesward]

I'm having some difficulty with my mysql_fetch_assoc. Basically what I have is a user's post and i'm trying to print out a set of results that would show the user who's currently 'liking' their post (like facebook). However, there seems to be a problem that i'm not 100% sure how to fix just now and maybe you can help.

Let's say my post id is "157", in my database the post "157" has 5 'likes' and the users id that like this post are "111, 2, 1, 114 and 42".

With this code...

PHP Code:

$thispost = $_REQUEST['id'];
         
         $grablikes = mysql_query("SELECT `user_id`, `post_id` FROM `likes` WHERE `likes`.`post_id` = '$thispost'");
         $wholikes = mysql_fetch_assoc($grablikes);
         
         echo "$wholikes[user_id]"; 


I get the result "111". Which is obviously not what i'm looking for. It's as if the fetch_assoc is not grabbing the other 4 results.

I'm sure there is an easy way to solve this problem, hope you have time to help!

Thanks!

[Fumigator]

mysql_fetch_assoc() fetches one row at a time. Call it multiple times (a loop is best) to get multiple results.

PHP Code:

for ($i = 0; $i < mysql_num_rows($grablikes); $i++)
{
    $wholikes = mysql_fetch_assoc($grablikes); 
    echo $wholikes['user_id'];
} 


[brianjamesward]

thats fantastic, worked a treat. I'm going to study into this method now!

[brianjamesward]

Is it possible to use the results of this inside a <a href='' title='$wholikes[user_id]'>link</a> ?

only shows 1 when i try it like this a the moment

[abduraooft]

only shows 1 when i try it like this a the moment

What you've tried?

[brianjamesward]

Originally Posted by abduraooft

What you've tried?

PHP Code:

$thispost = $_REQUEST['id'];
         
         $grablikes = mysql_query("SELECT `user_id`, `post_id` FROM `likes` WHERE `likes`.`post_id` = '$thispost'");
         
         for ($i = 0; $i < mysql_num_rows($grablikes); $i++)
            {
                 $wholikes = mysql_fetch_assoc($grablikes); 
   
                 $users_name = mysql_query("SELECT `username`, `id` FROM `users` WHERE `users`.`id` = '$wholikes[user_id]'");
                 $theirnames = mysql_fetch_assoc($users_name);
 
           
             } 


<a href='like.php?postid=$row[id]' class='someClass' title='$theirnames[username]'></a>

just used that inside the link?

[abduraooft]

Don't you need to put your anchor inside the loop to get it repeated?

[brianjamesward]

Originally Posted by abduraooft

Don't you need to put your anchor inside the loop to get it repeated?

anchor?

[brianjamesward]

Originally Posted by brianjamesward

anchor?

It's okay, ive just printed them out in a different way now. Thanks for all the help!

[abduraooft]

Originally Posted by brianjamesward

anchor?

http://www.w3.org/TR/html401/struct/links.html#h-12.1