Jump to content

help with table


fwbbetsy

Recommended Posts

I have created a table that gets the user and there referrals but I need it to get the members who have the most referrals here is what I have so far:

 

<?php

// Make a MySQL Connection

mysql_connect("localhost", "cr4tpuu9_man", "abc123") or die(mysql_error());

mysql_select_db("cr4tpuu9_man") or die(mysql_error());

 

 

//Get all the data from the "user" table

$result = mysql_query("SELECT * FROM user")

or die(mysql_error()); 

 

echo "<table border='1'>";

echo "<tr> <th>Name</th> <th>Referral</th> </tr>";

// keeps getting the next row until there are no more to get

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

// Print out the contents of each row into a table

echo "<tr><td>";

echo $row['name'];

echo "</td><td>";

echo $row['ref'];

echo "</td></tr>";

}

 

echo "</table>";

?>

 

 

Here is the link of what it looks like: http://www.emeraldcoasttraffic.com/contest.php

 

 

can someone help me out?

 

Thanks

 

Betsy

Link to comment
https://forums.phpfreaks.com/topic/42712-help-with-table/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.