thank you for replying, but I don't think there are anything wrong with query,because i used the same command in mysql,it works all right,u know!so i'm not sure what exactly happened! Anyway thank you very much!
while($r = mysql_fetch_array($result)) { $goodsid = r["goods.goodsid"]; $name = r["name"] //.... and so on.. then echo "<p><strong>"; echo stripslashes($r["goodsid"]); echo "</strong><br>name: "; echo stripslashes($r["name"]); //.... and so on }now understand?
hello DFlyingchen, the problem still hasn't been solved i'm afraid. Sorry for tell u that this late.i just waste another weekend! After I changed the if loop to while loop as u showed me as above, the output of result.php is still the same( only the head title can be seen). I doubt is there anything wrong with the software???it's wierd!
??? i've no idea... check your SQL query first. is that running ok?
There is a bug in this code: $result = mysql_query($query);You have miss a parameter -- $db It should be $result = mysql_query($query,$db);Try it.
reinstall your web server with php and config again!
{
$goodsid = r["goods.goodsid"];
$name = r["name"]
//.... and so on.. then
echo "<p><strong>";
echo stripslashes($r["goodsid"]);
echo "</strong><br>name: ";
echo stripslashes($r["name"]);
//.... and so on
}now understand?
i've no idea...
check your SQL query first. is that running ok?
$result = mysql_query($query);You have miss a parameter -- $db It should be
$result = mysql_query($query,$db);Try it.