MySQL only returns { first row } from the result of query !

Question

I've used my server for testing PHP & MySQL Applications long time ago.

Suddenly, When i try to execute any query on the any table in any database, i get only the first row in the result of the query !

I checked the configuration file, and didn't see anything strange there.

OS: Linux / Ubuntu 10.04 64bit Server Edition, Web Server: Apache/2.2.14, MySQL Client: 5.1.41, MySQL Server: 5.1.41-3ubuntu12.3 (Ubuntu)

And, I'm sure that there's no error in my PHP Code, While when i use phpMyAdmin, i get all rows normally !.

Where should be the problem ?

Answer 1

It would help if you posted your code, but I'm guessing that your code doesn't have a loop that fetches each row.

<?php

$Result = mysql_query( $Query );

while( $Row = mysql_fetch_assoc( $Result ) ) //keep going while there are more rows
{
    print_r( $Row );
}

mysql_fetch_accoc and mysql_fetch_array functions only return one row at a time (consecutively) so you need to run them for each row.

Answer 2

The problem is with your code. You have just told us that PHPMYADMIN returns from mySql fine, so clearly the sql server is not the problem, nor is phpmyadmin.

Your code is wrong, you probably have (inside your super confidential and perfect code) a limit 1 in your staement, or are grabbing the rows incorrectly because you are unaware of how mysql_fetch functions work.

Downvote me because I'm a snarky jerk, but whatever.

Answer 3

I'm so sorry, i Really forgot about Looping.

Thanks.