Member Avatar for hwoarang69 
$queryget = mysql_query("SELECT * FROM image WHERE user_id = '$user_id_s'");

while($row = mysql_fetch_assoc($queryget))
{   
    $count_c = $row['image_comment'];
    $count_image++;
    $count_comment = $count_comment + $count_c;

}

for some reason it is not going inside the while loop and ideas?

  • 2 Contributors
  • 3 Replies
  • 120 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by hwoarang69
Member Avatar for ryantroop

I know it sounds silly.. but it's happened to me before that I didn't put a semi-colon at the end of my sql query, and it failed since SQL was waiting for a new command...

Try:

$queryget = mysql_query("SELECT * FROM image WHERE user_id = '$user_id_s';");

If that doesnt work, change it to

  $queryget = mysql_query("SELECT * FROM image WHERE user_id = '$user_id_s';") or die (mysql_error());

and see where it is failing.

Member Avatar for hwoarang69

i tried it but i didnt got any error and didnt worked

Member Avatar for hwoarang69

ah wait i got it to working. thanks alot

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.