Jump to content

Archived

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

Xeon-YK

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];
$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

thank...

Share this post


Link to post
Share on other sites
[code]
$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 . " ";
  }
}
[/code]

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.