[SOLVED] testing works but live does not
Posted: Thu Nov 27, 2003 3:52 am
i am working on a webboard in Thai for an NGO - it works when testing with PHP Triad, however when I upload it - i get "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource" for lines 71 and 84.
here is the code: any suggestions please?
mysql_connect($host,$user,$passwd) OR die ('Could not select the database: ' . mysql_error() );
$sql = "select No from webboard_data where Category=$Category";
$result = mysql_db_query($dbname,$sql);
$NRow = mysql_num_rows($result);
$rt = $NRow%$list_page;
if($rt!=0) {
$totalpage = floor($NRow/$list_page)+1;
}
else {
$totalpage = floor($NRow/$list_page);
}
$goto = ($page-1)*$list_page;
// Query Thai
$sql = "select * from webboard_data where Category='$Category' order by No DESC limit $goto,$list_page";
$result = mysql_db_query($dbname,$sql);
$NRow = mysql_num_rows($result);
if($NRow==0) {
echo "<font size=2 face='MS Sans Serif'>?????????????</font><br><br>\n";
here is the code: any suggestions please?
mysql_connect($host,$user,$passwd) OR die ('Could not select the database: ' . mysql_error() );
$sql = "select No from webboard_data where Category=$Category";
$result = mysql_db_query($dbname,$sql);
$NRow = mysql_num_rows($result);
$rt = $NRow%$list_page;
if($rt!=0) {
$totalpage = floor($NRow/$list_page)+1;
}
else {
$totalpage = floor($NRow/$list_page);
}
$goto = ($page-1)*$list_page;
// Query Thai
$sql = "select * from webboard_data where Category='$Category' order by No DESC limit $goto,$list_page";
$result = mysql_db_query($dbname,$sql);
$NRow = mysql_num_rows($result);
if($NRow==0) {
echo "<font size=2 face='MS Sans Serif'>?????????????</font><br><br>\n";