[SOLVED] Simple script playing up...

[mattal999]

Hi,

 

i made this script and it comes up with an error:

 

<?php

session_start();
include 'connect.php';

$name = $_GET['car'];
$price = $_GET['price'];
$engine = $_GET['engine'];
$username = $_SESSION['username'];

$usercreds1="SELECT * from dragusers WHERE username='$username'";
$usercreds2=mysql_query($usercreds1) or die("Could not select user.");
$usercreds3=mysql_fetch_array($usercreds2)

$gold = $usercreds3[credits];
if($gold>=$price)
         {
           $updateplayerstats="Update dragusers set credits=credits-'$gold', engine='$engine', car='$name' where username='$username'";
           mysql_query($updateplayerstats) or die("Could not update players car");
   print "You brought the $name for $price";
         }
         else
         {
           print "You have insufficient credits";
         }

?>

 

and it comes up with the error:

 

Parse error: syntax error, unexpected T_VARIABLE in /home/users/uks51756/html/games4uonline.com/drag/buycar.php on line 17

[Orio]

You are missing a semicolon in line 13:

$usercreds3=mysql_fetch_array($usercreds2);

 

Orio.

[envexlabs]

Also,

 

just a little tip:

 

$updateplayerstats="Update dragusers set credits=credits-'$gold', engine='$engine', car='$name' where username='$username'";

mysql_query($updateplayerstats) or die("Could not update players car");

 

is the same as:

 

$updateplayerstats=mysql_query("Update dragusers set credits=credits-'$gold', engine='$engine', car='$name' where username='$username'") or die("Could not update players car");;

 

just saves a line of code

[mattal999]

Hey orio, long time no see, remember RpgNOW? Cheers mate, worked a charm. It's my new project, Drag Racer. Will post beta testing when complete! Cheers again mate.

 

EDIT: and thanks envexlabs! that will be handy  I always use databases everywhere lol.

[mattal999]

One more problem: when i buy a car worth 55000 credits and i have 55000+ i have 0 credits afterwards....

 

Fixed