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
============================================================================

Reply via email to