php - query not resolving right, how to? -


i have query should return 40 results:

$test = mysql_query(" select fname online_all verify_status = 'v' limit 40 "); if (!$test ) {print " - mysql error - ";echo fns_et_mysql_error(mysql_error());} 

if echo mysql_num_rows($test); 40. means results when print_r $roww = mysql_fetch_array($test); 1 result.

there no php errors.

you have loop through results with:

while($row = mysql_fetch_array($test)) {     // awesomeness $row } 

Comments

Popular posts from this blog

linux - Using a Cron Job to check if my mod_wsgi / apache server is running and restart -

actionscript 3 - TweenLite does not work with object -

jQuery Ajax Render Fragments OR Whole Page -