Hi,
I've searched the archives and cannot find a ref to what i need to do.
I'm retriving info from my database table
mysql> DESCRIBE owe_ol;
+----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| customer_name | varchar(30) | YES | | NULL | |
| msc_ingress | varchar(14) | YES | | NULL | |
using
$result = mysql_query("SELECT * FROM owe_ol ORDER BY customer_name",$db);
I then ouput to HTML
printf("<tr><td><b>%s</b></td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n", $myrow[0], $myrow[1], $myrow[2], $myrow[3], $myrow[4], $myrow[5], $myrow[6], $myrow[7], $myrow[8], $myrow[9], $myrow[10], $myrow[11], $myrow[12], $myrow[13], $myrow[14], $myrow[15], $myrow[16], $myrow[17], $myrow[18], $myrow[19]);
How can I get rid of the Filed name in the ouput eg customer_name?
Hope you guys can help.