RE: [PHP] What could I be doing wrong here

You need to use: mysql_fetch_array($result) to use the "column names". And also, you must use quotes when referencing the column names. eg. printf("%s\n", $myrow["id"]); > -----Original Message----- > From: YoBro [mailto:nospam@brochures.co.nz] > Sent: Tuesday, 27 March 2001 08:53 > To: php-general@lists.php.net > Subject: [PHP] What could I be doing wrong here > > > I can't figure out why this doesn't work. Rather than echo $myrow[0] which > works, I want to use the feild name. Like $myrow[make] to make reading the > code easier. IS this possible? > > Here is some code: > > $db = mysql_connect("localhost", $user, $pass)OR DIE("Unable to connect to > database"); > > mysql_select_db("database",$db) OR DIE("Unable to connect to database"); > > $result = mysql_query("SELECT * FROM stock",$db); > > while ($myrow = mysql_fetch_row($result)) > { > echo "$myrow[id]<br>"; //Usually $myrow[0] etc > echo "$myrow[make]<br>"; > echo "$myrow[model]<br>"; > echo "$myrow[sub_model]<br>"; > } > > Thanks Heaps > > > -- > Regards, > > > YoBro > ------------------------------------------------------------- > DO NOT REPLY TO THIS VIA EMAIL > PLEASE USE THE NEWSGROUP > All emails sent to this address are automatically deleted. > This is to avoid SPAM! > ------------------------------------------------------------- > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >