Parse error: syntax error, unexpected T_STRING Help!

[neex1233]

I'm getting the error that's in the subject. Here is my code:

 

<?php
require 'config.php';
$id = $_SESSION['id'];
$sql = "UPDATE users SET tokens=(tokens+$t) WHERE id=$id"
srand ((double) microtime( )*1000000);
$t = rand(2,75);
mysql_query($sql);
echo "You won $t tokens!";
?> 

 

 

The error is not in config.php

 

Thanks!

 

EDITED BY akitchin: please use code tags in future posts here.

[Maq]

Missing ';' after $id"

[ldougherty]

change

 

$sql = "UPDATE users SET tokens=(tokens+$t) WHERE id=$id"

 

to

 

mysql_query("UPDATE users SET tokens=(tokens+$t) WHERE id=$id");

[Maq]

change

 

$sql = "UPDATE users SET tokens=(tokens+$t) WHERE id=$id"

 

to

 

mysql_query("UPDATE users SET tokens=(tokens+$t) WHERE id=$id");

 

I like putting the query in a string first, that way you can echo it out and see what it actually contains, and it's easier to manipulate.

[neex1233]

This is my new code:

 

<?php
ini_set ("display_errors", "1");
error_reporting(E_ALL);
require 'config.php';
$username = $_SESSION['username'];
$t = rand(2,75);
$sql = "UPDATE users SET tokens=(tokens+$t) WHERE username=$username";
srand ((double) microtime( )*1000000);
mysql_query($sql);
echo "You won $t tokens!";
?> 

 

It doesn't work, but I don't get an error.

[Maq]

Put single quotes around $username:

 

WHERE username='$username'";

[neex1233]

Thanks, it works now!!

[Maq]

Thanks, it works now!!

 

Good.  The only type you don't have to put single quotes around are integers.