RE: first time to use MySQL on MS Platform with PHP.

Hi, This is a PHP issue not MySQL. If anything got inserted at all it will be blanks for no where in your code were your variables ('$productid', '$itemname', '$description', '$price', '$information') defined. Try this in the productsave.php code right at the TOP after your include : //(si

Re: MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR

I have MySQL version 3.23 on Linux 8.0 . I am trying to do a full text search IN BOOLEAN MODE and I get an error. If I remove the IN BOOLEAN MODE option my query runs fine . Does it mean I have to upgrade to 4.0 to use this Search mode? Can somebody please confirm ? -- MySQL General Mailin

MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR

I have run this command without Stating IN BOOLEAN MODE and my search goes fine. However this query returns a Syntax error WHEN IN BOOLEAN MODE OPTION IS ADDED , can anyone help ? Table is MyISAM type running on Linux 8.0 SELECT isbn, title, suggestedretail FROM bookscatalogue WHERE MATCH (isb