mysql error
#1

hi I want know where is the error in the delete zone :

PHP код:
if(time == 0)
            {
                
format(querysizeof(query), "DELETE FROM time WHERE id = %d ",);
                
mysql_query(query);
                continue;
            }
            
format(querysizeof(query), "UPDATE banlist SET time = %d WHERE id = %d",time-1i);
            
mysql_query(query); 
PHP код:
public CountTimeBan()
{
    new 
query[129], time;
    for (new 
1100 i++)
    {
        
format(querysizeof(query), "SELECT time FROM banlist WHERE id = %d",i);
        
mysql_query(query);
        
mysql_store_result();
        
time mysql_fetch_int();
        if (
mysql_num_rows() !=0)
        {
            if(
time == 0)
            {
                
format(querysizeof(query), "DELETE FROM time WHERE id = %d ",);
                
mysql_query(query);
                continue;
            }
            
format(querysizeof(query), "UPDATE banlist SET time = %d WHERE id = %d",time-1i);
            
mysql_query(query);
        }
        else
        {
            
mysql_free_result();
            continue;
        }
    }
    return 
1;

Reply


Messages In This Thread
mysql error - by jaskiller - 06.01.2012, 11:18
Re: mysql error - by FuTuяe - 06.01.2012, 11:44
Re : mysql error - by jaskiller - 06.01.2012, 11:52
Re: mysql error - by FuTuяe - 06.01.2012, 13:43
Re : mysql error - by jaskiller - 06.01.2012, 17:18
Re : mysql error - by jaskiller - 06.01.2012, 21:50

Forum Jump:


Users browsing this thread: 1 Guest(s)