Errors within code.

[dean7]

Hi all, i've coded a script for my website but ive got a few error's in the code which i'm not sure how to sort:

 

 

Notice: Undefined variable: carid in /home/www/**********/hts2.php on line 11

 

Notice: Undefined variable: fuel in /home/www/*******/hts2.php on line 13

 

Notice: Trying to get property of non-object in /home/www/*****/hts2.php on line 23

 

$timenow = time();
$username = $_SESSION['username'];
$query=mysql_query("SELECT * FROM garage WHERE id='$carid' LIMIT 1"); // Line 11
$info = mysql_fetch_object($query);
$query1=mysql_query("SELECT * FROM garage WHERE fuel='$fuel' LIMIT 2"); // Line 13
$info2 = mysql_fetch_object($query1);

// -------------------

if($info->fuel < 15){ // Line 23

 

There the bit's of the code i'm having problems with. I've tried de-bugging it but carn't seem to sort it.

 

Anyone know why I'm getting these error's?

 

Thanks.

 

 

[Adam]

The undefined variable notices are simply alerting you that you're trying to use a variable that doesn't exist. As they don't exist though that then means your queries are returning 0 results, and so when you try to use $info->fuel you're being notified that the property "fuel" doesn't exist (as there's no results).

[dean7]

So what would the easiest way to fix it be?

[Adam]

$carid and $fuel don't exist.. Where are they defined?

[dean7]

For the fuel I did try defining it but as i done that it still gave me the same error:

 

 

Notice: Trying to get property of non-object in /home/www/*****/hts2.php on line 23

[Adam]

Because your queries aren't returning any results. You can check the number of results returned with mysql_num_rows - perform a check before you try creating/using the MySQL object.

[dean7]

Ok, I tried it with the fuel and carid varibals , and the both ended 0, but how could I define the $carid varibal?

[Adam]

I don't know this is your code. Where are their values supposed to come from?

[dean7]

Well when the user selects there car from there garage it put them in that car so they can do the races, but im just not sure how to sure how to retive that id.

[Adam]

Perhaps using $_GET? Be sure to sanitize input data before using it in your query though.