Probalem with select query

[golfinggod]

Hi

I have a table in mysql called credits, the table consists of username and credits. The credits field will have a value of credits in it. I am trying to select the value from the credits field and return it to the php.

The problem is that when I echo the result to test it, it returns
Resource id #2 instead of the value in the database.

Any ideas heres the code

[PHP

$username = $HTTP_GET_VARS['username'];

$db = mysql_pconnect ('localhost','root','');

	  if (!$db)
	  {

		exit;
	  }

	  mysql_select_db('Users');

// Select credit amount using username

$query = "select credits from credits where username =$username";

$result = mysql_query($query);

echo $result;

[/code]

[rheroux]

Resource id #2 is just the PHP telling you that the query has been executed.

You have to fetch the data into an object or an array afterwards.

Add this after $result = mysql_query($sql);

while($row = mysql_fetch_array($result))
{

echo $row['credits']."<br>";

}

mysql_fetch_array or mysql_fetch_object are probably the best functions for grabbing your data since they use associative indices rather than numeric indices. (That is, they use the field names of your table for their indices rather than simply [0], [1], [2], etc.)

[golfinggod]

tanks🙂