cliftonbazaar Posted April 10, 2009 Share Posted April 10, 2009 The code I have is $check_email = mysql_query("SELECT CustomerID FROM customers WHERE email='[email protected]'"); echo $check_email."<br>"; The echo line is there for debugging purposes and it displays "Resource id #2" when it is run - but I want the line to display 'customerID' which is a number (in this case it should show '1' so I have no idea why it says what it says). Please note that the email address [email protected] is in the database for testing purposes. Link to comment https://forums.phpfreaks.com/topic/153431-outputting-wrong-data-from-a-query/ Share on other sites More sharing options...
Spike121 Posted April 10, 2009 Share Posted April 10, 2009 I got this error once, I can't remember how I fixed it. Is your coloumn name "CustomerID" or "customerID" because it is case sensitive. Link to comment https://forums.phpfreaks.com/topic/153431-outputting-wrong-data-from-a-query/#findComment-806142 Share on other sites More sharing options...
PFMaBiSmAd Posted April 10, 2009 Share Posted April 10, 2009 http://us.php.net/mysql_fetch_assoc Link to comment https://forums.phpfreaks.com/topic/153431-outputting-wrong-data-from-a-query/#findComment-806144 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.