Ok I have a email list and in the list there might end up being duplicates and what im wondering is where to start here is a basic outline of the project
I have 3 columns in my sql table id player name and email what I am looking for is if someone adds in another record for player x that the table looks and pulls for the most recent record that isn’t blank and puts it in the table I have no clue on where to even start
[code]
<?php $con = mysql_connect("localhost","dbs_dbs","password"); if (!$con){ die("Can not connect: " . mysql_error()); } mysql_select_db("dbs_forms",$con); $sql = "SELECT * FROM playersemails ORDER BY playername ASC "; $mydata = mysql_query($sql,$con); echo "Player Name | Emails |
---|---|
" . $record['playername'] . " | "; echo "" . $record['email'] . " | "; echo "
any help would be much appreciated