Jump to content

Getting data from MySQL


DYWBH

Recommended Posts

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"  :confused:

 

<?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

<?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 />";
}
?>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.