July 12th, 2000, 09:21 AM
I think you pretty much have to step through the result set one row at a time, and assign that row to an array. you can make a loop to put the whole result into an array, then use that array later on to print your page. or you can make a loop to get a row, print out the data for that row, then loop to the next row. here's how i usually output data from mysql.
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>
$query=mysql_db_query($database,"select id,fname,lname from contactinfo",$link_id);
while (list ($id,$firstname,$lastname) = mysql_fetch_row($query))
echo "ID: $id, First Name: $firstname, Last Name: $lastname<br>n";
that might not help, but it's my $0.02...