need php & mysql help quick :) - GoFuckYourself.com

Dawgy · 02-17-2002, 12:45 AM

ok lane is aparently off in the corner wacking off, so is there anyone else here who can help me with a php & mysql question?

basically:

i want to read from a table and display the results in 3 columns. the thing is the table will not always have same number of rows, so i dunno how many to put in each column...

i know there is some way to do this i just cant find it...

help?!

Theo · 02-17-2002, 12:49 AM

lane got an overdose of food.....

Jade · 02-17-2002, 12:53 AM

Here is an example of generating a table based on a query to a mysql database using php:

PHP Code:


			
    echo "<TABLE>";

    echo "<TR><TH>Username</TH><TH>Expiration Date</th><TH>Subid</TH><TH>Sub</th></tr>";

    

while ($row = mysql_fetch_array($result)) {

    $username = $row['username'];

    $active = $row['active'];

    $expirationtime = $row['expirationtime'];

    $email = $row['email'];

    $subid = $row['subid'];

    $sub = $row['sub'];



echo "<TR><TD>$username</TD><TD>$expirationtime</TD><TD>$subid</TD><TD>$sub</TD></tr>";



}

echo "</table>";

Hope that helps!

[Labret] · 02-17-2002, 12:57 AM

Look at that. 2nd post and someone actually gave you help and not 36 replies of dribble about crabs, sodomy, or whos dialer hold the longest. Has to be a GFY record.

Dawgy · 02-17-2002, 01:12 AM

Quote:

Originally posted by [Labret]
Look at that. 2nd post and someone actually gave you help and not 36 replies of dribble about crabs, sodomy, or whos dialer hold the longest. Has to be a GFY record.

no shit. i almost feel cheated.

02-17-2002, 12:45 AM	#1
Dawgy Confirmed User Join Date: Jul 2001 Posts: 5,856	need php & mysql help quick :) ok lane is aparently off in the corner wacking off, so is there anyone else here who can help me with a php & mysql question? basically: i want to read from a table and display the results in 3 columns. the thing is the table will not always have same number of rows, so i dunno how many to put in each column... i know there is some way to do this i just cant find it... help?! __________________ the revolution is coming.

02-17-2002, 12:53 AM	#3
Jade Confirmed User Join Date: Jun 2001 Location: Houston, Texas Posts: 329	Here is an example of generating a table based on a query to a mysql database using php: PHP Code: echo "<TABLE>"; echo "<TR><TH>Username</TH><TH>Expiration Date</th><TH>Subid</TH><TH>Sub</th></tr>"; while ($row = mysql_fetch_array($result)) { $username = $row['username']; $active = $row['active']; $expirationtime = $row['expirationtime']; $email = $row['email']; $subid = $row['subid']; $sub = $row['sub']; echo "<TR><TD>$username</TD><TD>$expirationtime</TD><TD>$subid</TD><TD>$sub</TD></tr>"; } echo "</table>"; Hope that helps! __________________ Cum see me at http://BlowjobJade.com Last edited by Jade; 02-17-2002 at 12:54 AM..

02-17-2002, 12:49 AM	#2
Theo HAL 9000 Industry Role: Join Date: May 2001 Posts: 34,515	lane got an overdose of food.....

02-17-2002, 12:57 AM	#4
[Labret] Registered User Industry Role: Join Date: May 2001 Location: Са́нкт-Петербу́рг Posts: 10,945	Look at that. 2nd post and someone actually gave you help and not 36 replies of dribble about crabs, sodomy, or whos dialer hold the longest. Has to be a GFY record.