Jump to content


This topic is now archived and is closed to further replies.


mysql_fetch_array problem

Recommended Posts

i try to use mysql_fetch_array on my project

this my query string

$sql = "select * from a, b where a.id = b.id"
$rs = mysql_query($sql);
echo mysql_error();

when i try :

$i = 0;
while($row = mysql_fetch_array($))
echo $row[$i];

but it only print one row, and i try to use
$num = mysql_num_rows, it return 936 row

why the summary is different between i use mysql_fetch_array and mysql_num_rows


Share this post

Link to post
Share on other sites
$sql = "select * from a,b where a.id = b.id";
$rs = mysql_query($sql) or die(mysql_error());

while($row = mysql_fetch_array($rs)) {
   foreach($row as $val) {
      echo $val . " ";

or you can refer to each column explicitly with $row['columnname'] example:

echo $row['username'];

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.