[Ballu Miaa]

Hello Everyone,

I've been trying to learn MYSQL on my own as i learned SQLite a bit myself. I have a Business system done in SQLite. Now i want upgrade this system to MYSQL.

I am posting this SQLite code below. Is there anyone who can write the same code for me using MYSQL R7 or earlier (BlueG) doing the same task.

How do we collect the DBResult in MYSQL?

pawn Код:

public BusinessExists(sqlid)
{
    new DBResult:qresult;
    format(query, sizeof(query), "SELECT * FROM `Business` WHERE ( `id` = '%d' )", sqlid);
    qresult = db_query(database, query);
    if(db_num_rows(qresult) >= 1)
    {
        db_free_result(qresult);
        return true;
    }
    return false;
}

In case anyone can help me please post here, help will be appreciated a lot.

Thank you
Ballu Miaa