mysql querry
Posted: Fri Sep 05, 2003 3:27 pm
any tips on using php to querry a mysql database row base on a keyword? say theres 5 out of 19 rows with keyword "apple" i would like to retrieve those 5 rows with apples.
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
<?php
$search_word = addslashes($_REQUEST[search_word]);
$query = mysql_query("select `field1`, `field2`, `field3` from `table` where `field` = '%$search_word%'");
?>Wouldn't that be;qads wrote:is this what your looking for?Code: Select all
<?php $search_word = addslashes($_REQUEST[search_word]); $query = mysql_query("select `field1`, `field2`, `field3` from `table` where `field` = '%$search_word%'"); ?>
Code: Select all
<?php
$search_word = addslashes($_REQUEST[search_word]);
$query = mysql_query("select `field1`, `field2`, `field3` from `table` where `field` LIKE '%$search_word%'");
?>