Xeon-YK Posted May 11, 2006 Share Posted May 11, 2006 i try to use mysql_fetch_array on my projectthis 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 rowwhy the summary is different between i use mysql_fetch_array and mysql_num_rowsthank... Quote Link to comment Share on other sites More sharing options...
.josh Posted May 11, 2006 Share Posted May 11, 2006 [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']; Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.