[SOLVED] Searching in database

[aashcool198]

hi..

 

i am trying to make a small search engine.

where user fills value in form and it is searched in database.

 

$text = $_POST['search'];
$q = "SELECT name_id, firstname, lastname FROM personal where firstname LIKE '%'$text'%'";

$query = mysql_query($q);
while($row = mysql_fetch_array($query)){
echo $row['firstname'];

 

I think there is some problem with LIKE '%'$text'%'.

 

please tell me the right syntax.

[Dathremar]

$q = "SELECT name_id, firstname, lastname FROM personal where firstname LIKE '%".$text."%'";

 

 

But I recommend to check $_POST['search'] if it contains the desired information, before You use it in the query.