[Jose_grana]

My question is the following:

Suppose I have 200 cars in my database (obviously the gm is mysql). Now suppose I just want to load the ID 50. How can I do it?

Do I have to load 200 cars or is there any way to load only the one I want?

I use the MYSQL R39 plugin.

Sorry for my bad english.

+ Rep to help.

[ISmokezU]

Код:

 mysql_format(mysql, query, sizeof(query), "SELECT * FROM cars WHERE ID = %d LIMIT 1"

[AjaxM]

It could simply be done with the following query:

PHP код:

SELECT * FROM `vehicles` WHERE `id` = '%d' LIMIT 1 


EDIT ;

Smoke was faster than me!