15.07.2014, 09:53
I'm making a Business MYSQL, but i have problem with the ID of every Business.
The problem is when i delete one Business and create new one, but the ID did'nt replace the old ID, it make a new ID for that business. I use this script but it's not really effective. Help me
P/s: I use MYSQL R33
The problem is when i delete one Business and create new one, but the ID did'nt replace the old ID, it make a new ID for that business. I use this script but it's not really effective. Help me
PHP код:
for(new i=0; i<MAXBIZ; i++)
{
format(query,sizeof(query), "SELECT * FROM business WHERE IDBiz=%d",i);
new rows, fields;
cache_get_data(rows, fields);
if(!rows)
{
id = i;
break;
}
}