Re: lug-bg: MySQL query

[emilio@xxxxxxxxxxx (Emil Slavov)]

SELECT MAX(id) AS id FROM tablicata
Da pravish takava selekcia na PHP e podigravka s MySQL-a :)
Slogi si auto_increment opcia za colonata id ako iskash da se uvelichava 
avtomatichno pri vseki nov zapis. Inache na raka s INSERT.

>zdrasti lug-bg,
>
>imam slednoto pitane:
>MySQL tablica s razlichni poleta -
>
>+--------+----------+
>| id      | name    |
>+---------+---------+
>| 1       | joe     |
>+---------+---------+
>| 2       | jane    |
>+---------+---------+
>| n       | bill    |
>+---------+---------+
>
>
>celta e da vzema stoinostta na nai-goliamato 'id' (n)
>(ili poslednoto) i da go vkaram v php code.
>neshto kato SELECT id FROM table ORDER BY id WHERE id = '...'
>...
>posle da uvelicha biggest id + 1 za nov zapis i t.n.
>predpolagam che moje da se vikat stoinosttie na id (vsichkite)
>v php i posle da se vzema nai-goliamato, no ne moga da go izmislia
>v momenta...
>
>any ideas? 10x
>
>
>-----------------------------------------------------------------
>http://imot.GBG.bg - Èìîòúò, êîéòî òúðñèòå.
>============================================================================
>A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
>http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
>To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
>============================================================================

============================================================================
A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
============================================================================