the hell?

[brcolow]

Hey, I have a varible called $gold, it is defined in an if statement and it is defined as a mysql row. When I try to access the varible $gold somewhre else in the if statement it displays this, Recource id #6.... why?

[bastien]

🙂

[brcolow]

if( $action == 'buy_item' )
{
print"You have "; 
$gold = @ $db = mysql_pconnect("localhost", "mike", "");
 if (!$db)
 {

 echo "<b>Could not connect to database, try again later.</b>";

 exit;

 }

mysql_select_db("forums");; 
$result = mysql_query("select * from phpbb_users WHERE user_id='$user_id'");
$numrows = mysql_num_rows($result);
if ($numrows > 0)  

{
    $row = mysql_fetch_object($result);;
print"$row->user_points ";
};
print"gold.<br>";
$id = $_GET['id']; 
print"Buy page! ";
print"$cost";
print"$gold";
print"<br>You do not have enough gold to buy this item. This item costs $cost gold.";
}
if ($gold > $cost)
{
print"<br>You now own $name";
exit;
}

[bastien]

$gold = @ $db = mysql_pconnect/b;

shows db connection info

change one or the other to another variable

[brcolow]

if( $action == 'buy_item' )
{
print"You have "; 
$gold = @ $db = mysql_pconnect("localhost", "", "");
 if (!$db)
 {

 echo "<b>Could not connect to database, try again later.</b>";

 exit;

 }

mysql_select_db("forums");; 
$result = mysql_query("select * from phpbb_users WHERE user_id='$user_id'");
$numrows = mysql_num_rows($result);
if ($numrows > 0)  

{
    $row = mysql_fetch_object($result);;
print"$row->user_points ";
};
print"gold<br>";
$id = $_GET['id']; 
print"Buy page! ";
print"$cost";
print"$gold";
print"$row->user_points ";
if ($row->user_points < $cost)
{
print"<br>You do not have enough gold to buy this item. This item costs $cost gold.";
}
if ($row->user_points > $cost)
{
print"<br>You now own $name";
exit;
}

Where do I have a * up if statement? (not properly closed i mean, i cant find it, its giveing the the error like i have one)

*[mod-edit] Dont use bad words [/mod-edit]

[brcolow]

this is part of the script and in this part i have a bad if statment... but where? it fine until i add the first if statement to check if they dont have enough gold.

[mod-edit] dont use bad words[/mod-edit]

[Jedi_Legend]

if ($numrows > 0)  

{
    $row = mysql_fetch_object($result);;
print"$row->user_points ";
};

See it now?

There is three problems in this piece of code. First: two semicolons on the third line. Second: The -> is interpreted as a string within quotes, thus the Resource ID #6. Third: Semi-colon after the }.

[brcolow]

no. and thats not the part thats screwing up, its when I have this..

print"<br>You do not have enough gold to buy this item. This item costs $cost gold.";
}
if ($row->user_points > $cost)
{
print"<br>You now own this item";
exit;
}

And i make it...

if ($row->user_points < $cost)
}
print"<br>You do not have enough gold to buy this item. This item costs $cost gold.";
}
if ($row->user_points > $cost)
{
print"<br>You now own this item";
exit;
}