SQL select
#1

Sorry its me again, I have been spamming forums tonight for help (sorry for that its Just I suck)

Well this gives me no results. Almost none....

PHP код:
new query[256];
    
mysql_format(mysqlquerysizeof(query),"SELECT `Reason`, `Date` FROM `crimes` WHERE `Name`='%e'",somename);
    
mysql_tquery(mysqlquery"OnCrimeLoad"); 
PHP код:
forward OnCrimeLoad();
public 
OnCrimeLoad()
{
    new 
reason[128],SomeDate,rows cache_num_rows(),string[128],crimecount;
    for(new 
i=0rowsi++)
    {
        
cache_get_field_content(i"Reason"reason);
        
format(reasonsizeof(string), string);
        
SomeDate cache_get_field_content_int(i"Date");
        
printf("%s|%d"stringSomeDate);
        
crimecount++;
    }
    
printf("Test hi %i",crimecount);
    return 
1;

Reply
#2

Okay so I resolved all issues besides 1. The string im getting is entirely empty....

PHP код:
cache_get_field_content(i"Reason"reason64);
        
format(reasonsizeof(string), string);
        
        
Msg(playerid,COLOR_GREEN,string); 
Reply
#3

FIXED
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)