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... Link to comment https://forums.phpfreaks.com/topic/9525-mysql_fetch_array-problem/ 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']; Link to comment https://forums.phpfreaks.com/topic/9525-mysql_fetch_array-problem/#findComment-35165 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.