Къде е грешката в този код?

[JeRrY]

Здравейте!

Някой може ли да ми каже защо ми излиза така ===>

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jerry/proben/p/lgsl/rating.php on line 17

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/jerry/proben/p/lgsl/rating.php on line 19

А кодът е това:

<?php
/** ./rating.php (c) Lavrik 2009 */

require "lgsl_files/lgsl_class.php";
lgsl_database();
$id = intval( @$_GET['id']);
if( $_GET['add'] == '+1' ) {
$rating_status = ' + 1 ';
}
elseif( $_GET['add'] == '-1' ) {
$rating_status = ' - 1 ';
}
else {
$rating_status = '';
}
$result = mysql_query("SELECT * FROM voting WHERE server_id = '{$id}' AND vote_ip = '{$_SERVER['REMOTE_ADDR']}' AND time > '" . ( time() - ( 60 * 60 * 24 ) ) . "'");
if( !mysql_num_rows($result) ) {
$result = mysql_query("SELECT * FROM {$lgsl_config['db']['table']} WHERE id = '{$id}'");
if( mysql_fetch_array($result) ) {
mysql_query( "INSERT INTO voting VALUES ( NULL, '{$id}', '{$_SERVER['REMOTE_ADDR']}', " . time() . ")" );
mysql_query( "UPDATE {$lgsl_config['db']['table']} SET rating = rating {$rating_status} WHERE id = '{$id}'" );
}
}
else {
@header( "Location: index.php?vote=err" );
exit;
}
@header( "Location: index.php" );
?>

 

[UmriWe]

Пробваи така, би трябвало да стане :}

<?php
/** ./rating.php (c) Lavrik 2009 */

require "lgsl_files/lgsl_class.php";
lgsl_database();
$id = intval( @$_GET['id']);
if($_GET['add'] == '+1') 
{
    $rating_status = ' + 1 ';
}
elseif($_GET['add'] == '-1') 
{
    $rating_status = ' - 1 ';
}
else 
{
    $rating_status = '';
}
$result = mysql_query("SELECT * FROM voting WHERE server_id = '{$id}' AND vote_ip = '{$_SERVER['REMOTE_ADDR']}' AND time > '" . ( time() - ( 60 * 60 * 24 ) ) . "'");
$numrowsR = mysql_num_rows($result);
if(!$numrowsR) 
{
$result = mysql_query("SELECT * FROM {$lgsl_config['db']['table']} WHERE id = '{$id}'");
$row = mysql_fetch_array($result);
if($row) 
{
mysql_query("INSERT INTO voting VALUES ( NULL, '{$id}', '{$_SERVER['REMOTE_ADDR']}', " . time() . ")" );
mysql_query("UPDATE {$lgsl_config['db']['table']} SET rating = rating {$rating_status} WHERE id = '{$id}'" );
}
}
else 
{
    @header( "Location: index.php?vote=err" );
    exit;
}
    @header( "Location: index.php" );
?>

Ако не стане пиши :]

 

[JeRrY]

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jerry/proben/p/lgsl/rating.php on line 20

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/jerry/proben/p/lgsl/rating.php on line 24

Това става отново

 

[JeRrY]

Някакви други идеи ?

 

[Dizasterr]

Сложи след заявките

or die(mysql_error());

и кажи дава ли други грешки.

 

[JeRrY]

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jerry/proben/p/lgsl/rating.php on line 20

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/jerry/proben/p/lgsl/rating.php on line 24

Пак това пише

 

[JeRrY]

Никой ли не знае, как да го оправя?

 

[PHP_Masters]

<?php
/** ./rating.php (c) Lavrik 2009 */

require "lgsl_files/lgsl_class.php";
lgsl_database();
$id = intval( @$_GET['id']);
if($_GET['add'] == '+1')
{
$rating_status = ' + 1 ';
}
elseif($_GET['add'] == '-1')
{
$rating_status = ' - 1 ';
}
else
{
$rating_status = '';
}
$result = mysql_query('SELECT * FROM voting WHERE server_id='.$id.' AND vote_ip="'.$_SERVER['REMOTE_ADDR'].'" AND time >'.time() - ( 60 * 60 * 24 ));
$numrowsR = mysql_num_rows($result);
if(!$numrowsR)
{
$result = mysql_query('SELECT * FROM "'.$lgsl_config['db']['table'].'" WHERE id='.$id)
$row = mysql_fetch_array($result);
if($row)
{
mysql_query("INSERT INTO voting VALUES ( NULL, '{$id}', '{$_SERVER['REMOTE_ADDR']}', " . time() . ")" );
mysql_query("UPDATE {$lgsl_config['db']['table']} SET rating = rating {$rating_status} WHERE id = '{$id}'" );
}
}
else
{
@header( "Location: index.php?vote=err" );
exit;
}
@header( "Location: index.php" );
?>

 

[JeRrY]

Добре, а има ли начин да се направи кода без да фигурира mysql_num_rows и mysql_fetch_array ?