Hi, can someone please tell me why when i echo out the AuctionID from the database it doesn’t show. where i got “Your Auction ID is $AuctionID” the AuctionID is a field in the table i need it to show the value.
[code=php]
<?PHP
//conn
$conn = mysql_connect(“localhost”, “k0m0d0”, “ragnarok”) or die(mysql_error());
//select table
mysql_select_db(“ebay”,$conn) or die(mysql_error());
//statement
$sql = “select AuctionID from itemswon where WinnerUserID =
‘$_POST[eBayUserID]’ AND eBayItemNumber = ‘$_POST[eBayItemNumber]'”;
//if script
$result = mysql_query($sql, $conn) or die(mysql_error());
if (mysql_num_rows($result) ==1) {
echo “Your Auction ID is $AuctionID”;
} else {
echo “Your ID does not exist”;
}
?>
Thanks
Adam