[UPHPU] Query Help
Webot Graphics
graphics at westernbotanicals.com
Thu Apr 5 14:27:37 MDT 2007
Here is the example from MySQL
SELECT id, body, MATCH (title,body) AGAINST
-> ('Security implications of running MySQL as root') AS score
-> FROM articles WHERE MATCH (title,body) AGAINST
-> ('Security implications of running MySQL as root');
here is mine (updated to match) that still doesn't work //
Customer_Product_Name is the column and Customer_Product_Names is the
table
$sql = "SELECT * MATCH (Customer_Product_Name) AGAINST
('$searchstring') AS score FROM Customer_Product_Names WHERE MATCH
(Customer_Product_Name) AGAINST ('$searchstring')";
I should note that my php connects to the database just fine
Justin Giboney
Graphic Design
Western Botanicals
Ph:800.651.4372, Fax:866.366.4372
More information about the UPHPU
mailing list