mysql query syntax error ..help! :)

[Anon]

Can someone tell me what is wrong with this
query:

$query = "insert into ".$this->catagory."
values ('".NULL." , '".$this->filesRead[$k]."')";

where $k is for loop variable,
$this->catagory is table name.
filesRead array contains text file for each slot.

thanks.......

[lawnmowerman]

What is the error you're getting? I see nothing wrong with this statement as it sits.

Try adding:

print mysql_error();

after your call mysql_query( $query ) and let me know what it says.

-Rich

[jcornett]

Assuming you didn't type it wrong on accident, it appears there is a single quote missing:

Current Code:
$query = "insert into ".$this->catagory."
values ('".NULL." , '".$this->filesRead[$k]."')";

New Code:
$query = "insert into ".$this->catagory."
values ('".NULL."' , '".$this->filesRead[$k]."')";

Notice the single quote after the NULL? 🙂 If you could also include the error you are getting in case this isn't the problem (or simply a typo).

John Cornett

[Anon]

here is the exact cut/paste code:

$query = "insert into ".$this->catagory." values
('".NULL."','".$this->filesRead[$k]."')";

here is the error i get:
1064
You have an error in your SQL syntax near 's recommended that you run isamchk -rq on all old tables! Starting with 3.23' at line 2

question: should the '".NULL."'
be written as '.NULL.' ?? damn..i am so stuck lol........

[lawnmowerman]

Hmmm...sounds like there are two error messages there.

First off, fix the apostrophe error, if you haven't already, then run isamck to make sure your database isn't corrupted.

-Rich