Rows from a database...

[mo0ness]

Say I have a database table with say..14 seperate rows..I want to get ALL row names, but instead of doing it this way... (which takes longer)...

$query = "SELECT * FROM $table";

$result = mysql_db_query($dbname, $query);

while ($row = mysql_fetch_array($result))
{
$field1 = "$row[Field1]";
}

etc

I want to get ALL row names without all this hassel but i cant remember how 2 do it..i did to it a while ago but have forgot?

Thanx for the help..

[dv6cougar]

here's how i do it

$query = "SELECT * FROM $db WHERE id=$id";



$result = mysql_query($query, $mysql_access);

//line 21, 22 is below....



$row = mysql_fetch_row($result);
	echo "<table width=\"675\" height=\"600\" border=\"1\" bordercolor=\"black\" borderstyle=\"solid\" align=center>";
	echo "<tr><td class=show>Year</td><td class=howto> ".$row["2"];
	echo "</td></tr><tr><td class=show>Model</td><td class=howto height=25>  ".$row["3"];
	echo "</td></tr><tr><td class=show>Type of How To</td><td class=howto height=25> ".$row["4"];
	echo "</td></tr><tr><td class=show>Mod Name</td><td class=howto height=25> ".$row["5"];
   echo "</td></tr><tr><td class=show>Estimated Time to complete mod</td><td class=howto height=25> ".$row["6"];
   echo "</td></tr><tr><td class=show>Description</td><td class=howto height=25> ".$row["7"];

   echo "</td></tr><tr><td class=show>Steps and Procedure<td class=steps> ".$row["8"];
   echo "</td></tr><tr><td class=show>Created by<td class=howto height=25> ".$row["9"];
   echo "</td></tr></table>";

that even puts it in a nice table for you.... sorry for all the classes, they run of a stylesheet.

it's a owrking script that I am using as a test 🙂

good luck, i hope i was able to help you