[SOLVED] SQL Query errors

[jjacquay712]

i have a php scrip generate this code to search my db but it says it has syntax errors... any ideas?

 

Error

SQL query: Documentation

SELECT title, description, link
FROM search
WHERE title LIKE % search %
OR description LIKE % search %
OR link LIKE % search %
LIMIT 0 , 30

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%search% or description like %search% or link like %search%
LIMIT 0, 30' at line 1

[JasonLewis]

Wrap %search% in single quotes, that would be my suggestion.

[F1Fan]

Don't forget your single quotes, and is "search" a PHP variable?

<?php
$query = "SELECT title, description, link
FROM search
WHERE title LIKE '%$search%'
OR description LIKE '%$search%'
OR link LIKE '%$search%'
LIMIT 0 , 30";
?>