[SOLVED] Possible Malformed Query String...

[advancedfuture]

I am getting the following error on line 33.

"Parse error: parse error, unexpected T_STRING in videoUpload.php on line 33"

 

Is my query string malformed?

 

line 31 $query = "INSERT INTO users (video_url) VALUES($path) 
line 32	WHERE username = test;
line 33 mysql_query($query) or trigger_error("FATAL ERROR: " . mysql_error(), E_USER_ERROR);

[trq]

Your missing a spaces afetr (VALUES) and also the closing " on line 32.

 

Note if it is a string your attempting to insert $path will need to be surrounded by single quotes also.

[advancedfuture]

hmm nope still getting a parse error on line 33

[GingerRobot]

Note if it is a string your attempting to insert $path will need to be surrounded by single quotes also.

 

As will 'test'

 

hmm nope still getting a parse error on line 33

 

Can you show us the new code please?

[advancedfuture]

New code as follows

 

$path= "upload/".$new_file_name;

//Connect to Database and write the URL into the profile
mysql_connect("x.x.x.x"," xxxxxxx ","xxxxxxxxx");

$query = "INSERT INTO users (video_url) VALUES ('$path') WHERE username = 'test';"
mysql_query($query) or trigger_error("FATAL ERROR: " . mysql_error(), E_USER_ERROR);
mysql_close();

[GingerRobot]

You need to close the string before the semi colon:

 

$query = "INSERT INTO users (video_url) VALUES ('$path') WHERE username = 'test'";

 

[advancedfuture]

lol I feel dumb now

 

Thanks for the help though gentlemen!