RE: lug-bg: MySQL query

[bivol@xxxxxxxxx (Peter An. Zyumbilev)]

I vse pak ste otblezha che ste ti tribvat 2 zaivavki za da nparavish tova s
mysql....
skoro ne sam go pravil tova s mysql i ne moga da se setia dai mojeshe s edna
v zaivka...
v normalnite DB deto imat subselct niama problem..ako se setai ste ti kaja

Peter Angelov Zyumbilev
Web Developer & Administrator
web: http://www.bivol.net <http://www.bivol.net>
email: bivol@xxxxxxxxx <mailto:bivol@xxxxxxxxx>
tel. : + 359 88 966940

-----Original Message-----
From: owner-lug-bg@xxxxxxxxxxxxxxxxxx
[mailto:owner-lug-bg@xxxxxxxxxxxxxxxxxx]On Behalf Of Teodor Penev
Sent: Sunday, November 17, 2002 7:29 PM
To: lug-bg@xxxxxxxxxxxxxxxxxx
Subject: lug-bg: MySQL query

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