//where "candi_s_by_mail" is my field id, "cand_mail" is my db column and $cand_mail is varibale where i have stored field user input data.
if(isset($_POST['candi_s_by_mail']))
{
$sql="SELECT * FROM candidate WHERE cand_mail=$candmail";
echo "Selected candidate mail details";
}
$result = mysql_query($sql) or die(mysql_error());;
echo "in result";
while($row=mysql_fetch_array($result))
{
$FirstName =$row['cand_fname'];
$LastName=$row['cand_lname'];
$Mail=$row['cand_mail'];
}
我想查询我的搜索,因为当用户输入字符或文本时,它应该仅显示
根据我们的讨论,$ _ POST ['candi_s_by_mail']是文本,因此我们需要编写这样的查询
SELECT * FROM candidate WHERE cand_mail='$candmail';
字符串或文本应用引号引起来。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句