fwbbetsy Posted March 14, 2007 Share Posted March 14, 2007 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 More sharing options...
artacus Posted March 14, 2007 Share Posted March 14, 2007 Wouldn't you have a separate 'referrals' table with a 1 to many relationship to users? Link to comment https://forums.phpfreaks.com/topic/42712-help-with-table/#findComment-207277 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.