我只是无法弄清楚为什么我会收到错误消息,我试图删除''和()
我在phpmyadmin中运行脚本,它说我的语法问题在$ result =(“SELECT * FROM'test_prefixCatagory'ORDER by'Cat'”);
$result = ("SELECT * FROM 'test_prefixCatagory' ORDER by 'Cat'");
while($row = mysql_fetch_array($result))
$sCat = ($row['Cat']);
$sCatID = ($row['CatID']);
{
echo "
echo "
".$sCat."";
// column 1 categories
$result2 = ("SELECT * FROM `test_prefixSubCat` WHERE `CatID`=$sCatID");
// sub-cats
while($row2 = mysql_fetch_array($result2))
{
$sSub = ($row2['CatID']);
$sSubID = ($row2['SubID']);
echo "
".$sSub."";
}
echo "
";echo "
";}有人有想法吗?