(1065) Query was empty

Anon

Please help me out !

I'm trying to run the following piece of code:

$querystr = "DELETE FROM ordertemp;".
$result = @( $querystr, $link );
if( !$result ){
mail( "root@pc02.local", "MySQL error",
"There was an error in page \"$PHP_SELF\": (".mysql_errno().") ".mysql_error()."\nquery: $querystr", "" );
die( "Internal Error." );
}

Basically it should delete the records in a MySQL table "ordertemp", but I $result is FALSE and I get the error 1065 Query was empty ...

I just don't understand it. In the same page I do insert some records and it works, but I can't delete them.

Any advice would be much appreciated.

Thanx

Anon

Your problem lies here
this:
$querystr = "DELETE FROM ordertemp;".

should be this:
$querystr = "DELETE FROM ordertemp";

$result = @( $querystr, $link );
if( !$result ){
mail( "root@pc02.local", "MySQL error",
"There was an error in page \"$PHP_SELF\": (".mysql_errno().") ".mysql_error()."\nquery: $querystr", "" );
die( "Internal Error." );
}

Anon

Hi Josep!

If you have correctly typed this:

$querystr = "DELETE FROM ordertemp;".

The ; should be placed at the end of the line and you should remove the period.

The line below works perfectly for my site:

$sql = "delete from cart";
$result = mysql_query($sql);

Cheers!

Chris =)

Anon

Do you always respond before looking at others' responses!

Anon

There's no replies for this thread when I started typing my help. When I submitted my response, your reply appeared too.

And hey, there's a lot of PHP programmers in the whole wide world that could see the obvious. Also, Josep's problem is not a thing that only one man can "invent".

Didn't it occur to you that we might be typing our help at the same time and you're just "lucky" to submit you help first?

It should occur to you. You're a programmer!

Anon

you are right sorry for my harshness, it has just happened one too many times to me I guess

Anon

It's okay. No problem with me. =)

Cheers!

dreadrocksean

Anon;6549 wrote:
There's no replies for this thread when I started typing my help.

And hey, there's a lot of PHP programmers.

Do you always ignore simple English Grammar? Would you say 'there IS no replies" or 'there IS a lot of PHP programmers'? Grade school English man. Damn.

Illiteracy abounds.

bradgrafelman

Thread locked.