Little help needed - mysql - Printable Version

Little help needed - mysql - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Little help needed - mysql (/showthread.php?tid=312923)

Little help needed - mysql [+rep] - NewbBeginner - 23.01.2012

hello guys.

I was creating one system and I have the following things at mysql

Код:

id 
name
text

Now, im selecting these like this:

Код:

format(Query, sizeof(g_Query), "SELECT * FROM police");
		mysql_query(Query);

Now I want such kind thing that if I do /search NAME - if the NAME is in the police database > name then it will show the text. If that NAME is not in the databse then it will not show.

Simply:

/search NAME -> If in database is this name then it will show TEXT that it is in database.

Helpp

Re: Little help needed - mysql - NewbBeginner - 24.01.2012

Help neeeded! +1 REP !!

Simpy that it checks DB and this name I searched.

Re: Little help needed - mysql - MP2 - 24.01.2012

Use mysql_num_rows() to check if a row exists using a query like so:

"SELECT * FROM `tablename` WHERE Name = '%s (player's name)'"

Re: Little help needed - mysql - NewbBeginner - 24.01.2012

Код:

new
			dName = strval(inputtext),
			g_Query[ 1000 ]
		;
			
        format(g_Query, sizeof(g_Query), "SELECT * FROM police WHERE kname = '%s'", dName);
		mysql_query(g_Query);
		if(mysql_num_rows() > 0)
  		{
			SendClientMessage(playerid, -1, "Name is.");
			return 1;
		}

Doesnt work.. I did something wrong.

Re: Little help needed - mysql - T0pAz - 24.01.2012

pawn Код:

format(g_Query, sizeof(g_Query), "SELECT * FROM police WHERE name = '%s'", inputtext);
        mysql_query(g_Query);
        new result = mysql_num_rows();
        if(result)
        {
            SendClientMessage(playerid, -1, "Name is.");
            return 1;
        }

Re: Little help needed - mysql - NewbBeginner - 24.01.2012

Whatever name I write, it says Name is.
What's wrong.. ?

Re: Little help needed - mysql - Ricop522 - 24.01.2012

pawn Код:

format(g_Query, sizeof(g_Query), "SELECT * FROM police WHERE name = '%s'", inputtext);
    mysql_query(g_Query);
    mysql_store_result();
        new result = mysql_num_rows();
    if(result)
    {
        new Storage[128];
        if(mysql_retrieve_row()) {
            mysql_fetch_field_row(Storage, "text");
        }
        format(g_Query, sizeof(g_Query), "Text is: %s", Storage);
        SendClientMessage(playerid, -1, g_Query);
    } else {
        SendClientMessage(playerid, -1, "Name isn't");
    }
    mysql_free_result();
    return 1;

Re: Little help needed - mysql - Vince - 24.01.2012

After executing a select query, you must ALWAYS first use mysql_store_result, even before calling mysql_num_rows, otherwise you'll get problems.
Edit: 2000th post.