mysql

[sedric1]

i saw some examples that look like this:

$query = "SELECT * FROM $dbtable";
$result = mysql_query($query, $link);
while ($row = mysql_fetch_array($result)){?>
<? echo $row[name]; ?>:<? echo \$row[email]; ?> <br/>
<? }mysql_close(\$link); ?>

this works for me when i implement it- however,
what if i wanted to bring back everything- i.e. name, email, address, phone, and maybe 10 other fields - does every field have to be included as " echo $row[fieldname]; " or is there another way to output the entire db? (hope this question was clear 😉 )

[yelvington]

If you want to pull everything out of the db and print out each column without worrying about the column names (or order), see
http://us3.php.net/foreach
which will allow you to iterate across the returned array.

[sedric1]

cool- thanks for hte info.