SQL query not working

[rik72]

Hi, on the upload of an image, im trying to add the image into 2 databases, one needs adding, one needs updating;

 

Im using this;

 

$sql1 = "UPDATE ".TBL_USERS." SET photo = '$pass' WHERE username = '$username'";
$sql2 = "INSERT INTO user_images (photo, username) VALUES ('$pass', '$username'";
mysql_query($sql1);
mysql_query($sql2);

 

sql1 works fine, but sql2 is doing nothing, any ideas?

[Barand]

missing ) at the end

[dropfaith]

$sql1 = "UPDATE ".TBL_USERS." SET photo = '$pass' WHERE username = '$username'";

$sql2 = "INSERT INTO user_images (photo, username) VALUES ('$pass', '$username')";

mysql_query($sql1);

mysql_query($sql2);

[Barand]

@dropfaith,

 

Congratulations on being able to reproduce his code with the ")" added. So glad you wanted us all to know you can do that.

[Vitamin]

@dropfaith,

 

Congratulations on being able to reproduce his code with the ")" added. So glad you wanted us all to know you can do that.

lol