作者nanasy (冷冷)
看板PHP
标题请好心人帮忙抓错
时间Tue May 13 23:28:30 2008
我找了好久,一直不知道哪里有错,大家帮忙找
语法如下
<?php
if($_POST['name'])
{
include_once("link.php");
$query="USE 962db95322020;";
$result=mysql_query($query);
$result=mysql_query("SELECT * FROM birthday"."WHERE name='".$_POST['name']);
if($result)
{
echo '';
echo "<TABLE BORDER=5>";
echo "<TR>";
for($i=0;$i< mysql_num_fields($result);$i++)
{echo "<TH>",mysql_field_name($result,$i),"</TH>";}
for($k=0;$k< mysql_num_rows($result);$k++)
{
echo"<TR>";
$rowArray= mysql_fetch_row($result);
for($j=0;$j< mysql_num_fields($result);$j++)
{echo "<TD>",$rowArray[$j],"</TD>";}
}
echo "</TABLE>";
}
else
{echo '无此人';}
}
else
{echo '未输入名字';}
?>
谢谢!!
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 125.231.7.207
1F:→ neverfly:SELECT * FROM birthday"."WHERE name= 05/13 23:43
2F:→ neverfly:birthday跟WHERE之间不用空格吗? 05/13 23:43
3F:→ aqzb:name='".$_POST['name']."';"); 前面有'後面的不见了 05/14 00:13
4F:→ nanasy:原来就是$_POST最後面错阿,谢谢 05/14 01:08
5F:→ nanasy:但若换成多个资料表"SELECT * FROM birthday,highth,blood 05/14 01:09
6F:→ nanasy:怎麽又错了呢? 05/14 01:09
7F:→ starjou:把 query string echo 出来丢 phpMyAdmin 查吧 05/14 01:19