DYWBH Posted June 19, 2011 Share Posted June 19, 2011 I am trying to pull one piece of data from my database. The users balance. The $userid is within the session which I haven't included. For some reason when I run this it says "Resource id #9" <?php include 'connect.php'; $query = "SELECT Balance FROM Users WHERE ID = '$userid'"; $result = mysql_query($query); echo "$result"; ?> Thanks Quote Link to comment https://forums.phpfreaks.com/topic/239827-getting-data-from-mysql/ Share on other sites More sharing options...
QuickOldCar Posted June 19, 2011 Share Posted June 19, 2011 <?php include 'connect.php'; $query = "SELECT Balance FROM Users WHERE ID = '$userid'"; $result = mysql_query($query); while($row = mysql_fetch_array($result)){ //use your values echo $row['ID'] . "<br />"; echo $row['Balance'] . "<br />"; } ?> Quote Link to comment https://forums.phpfreaks.com/topic/239827-getting-data-from-mysql/#findComment-1231953 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.