[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