How to cehck unique numbers in database in R7 using mysql_function_query?

How to cehck unique numbers in database in R7 using mysql_function_query? - 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: How to cehck unique numbers in database in R7 using mysql_function_query? (/showthread.php?tid=366733)

How to cehck unique numbers in database in R7 using mysql_function_query? - Ranama - 07.08.2012

Hello, I'm working on my platenumber and phonenumber system, as you may notice I'll need unique numbers for every palyers, I've made a random function that works well, but the problem is that my mysql function to read if there is any current numbers like that doesn't work.
How to check if there is any rows with mysql_function_query? as i do it now is:

pawn Код:

//i generate a random number here, then i use this function

format(query, sizeof(query), "SELECT carid FROM publiccars WHERE carplatenocolor = '%s'", string);
if(mysql_function_query(dbHandle, query, true, "CheckRows", "") == 0) return 0;//this returns that the number is availiable and else i return 1;

forward CheckRows();
public CheckRows(){
    new rows, fields;
    cache_get_data(rows, fields);
    if(rows) return 1;
    else return 0;
}

but mysql_funcion_query dosen't seems to return anything, do anyone else know why or get better ideas on how to do this?

I'm thnkfull for every answer

Re: How to cehck unique numbers in database in R7 using mysql_function_query? - Misiur - 07.08.2012

Put printf("Received %d rows and %d fields", rows, fields); under cache_get_data. What do you get in console?

Re: How to cehck unique numbers in database in R7 using mysql_function_query? - Sinner - 07.08.2012

Make carid a unique value when you create the table structure:

PHP код:



CREATE TABLE `your_table_name`(

    carid INT NOT NULL,                        // Create carid field

    CONSTRAINT carid_key PRIMARY KEY(carid) // Make carid the primary key

);

Now any carid value will be unique, and it will auto increment, so you don't have to insert the value when creating new rows. Whenver you then check if the row exists you only need to check if it occurs once, as multiple rows with the same ID is impossible.

Like so:

PHP код:



SELECT COUNT(*) FROM `your_table_name` WHERE carid = `the_carid_to_check`

Although this query would be useless when using unique keys.

Re: How to cehck unique numbers in database in R7 using mysql_function_query? - Ranama - 07.08.2012

Quote:

Originally Posted by Sinner

Make carid a unique value when you create the table structure:

PHP код:



CREATE TABLE `your_table_name`(

    carid INT NOT NULL,                        // Create carid field

    CONSTRAINT carid_key PRIMARY KEY(carid) // Make carid the primary key

);

PHP код:



SELECT COUNT(*) FROM `your_table_name` WHERE carid = `the_carid_to_check`

Although this query would be useless when using unique keys.

Thanks for the fast answer, (sorry that i was so slow to answer xD)
I'm using PhPMyadmin to create the tables, how do i do this then, I don't see any function like that in phpMyAdmin?

Re: How to cehck unique numbers in database in R7 using mysql_function_query? - Vince - 07.08.2012

Go into your table, click 'Structure' tab at the top. To the right of the column you want to alter there is a button called 'Unique Value'. Click it.

Re: How to cehck unique numbers in database in R7 using mysql_function_query? - Ranama - 08.08.2012

Quote:

Originally Posted by Vince

Go into your table, click 'Structure' tab at the top. To the right of the column you want to alter there is a button called 'Unique Value'. Click it.

Thanks