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 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 />"; } ?> Link to comment https://forums.phpfreaks.com/topic/239827-getting-data-from-mysql/#findComment-1231953 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.