如何使用PHP搜索MYSQL数据库中的数据？

Question

$searchkey=$_REQUEST['searchkey'];
$searchkey2=$_REQUEST['searchkey'];
$mylink=mysql_connect($dbhost,$dbuser,$dbpasswd);
mysql_select_db($dbname,$mylink);
$sql="select * from Table where $selectkey='$searchkey' order by Id desc";
$result=mysql_query($sql);

Answer 1

有点问题，重发$selectkey=$_REQUEST['selectkey'];
$searchkey=$_REQUEST['searchkey'];
$mylink=mysql_connect($dbhost,$dbuser,$dbpasswd);
mysql_select_db($dbname,$mylink);
$sql="select  * from Table where ".$selectkey." like '%".$searchkey."%' order by Id desc";
$result=mysql_query($sql);