Re: lug-bg: MySQL query

[drem@xxxxxxx (krasimir)]

öèòèðàì  Teodor Penev <tpenev@xxxxxx>:

> 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

 $result=mysql_query(sprintf("SELECT (MAX(tablename.id)+1) from 
table.name;") , $link);
 if($row = mysql_fetch_array($result))  {
        if ($row[0]=='') $id=1; else
        $id=$row[0];
 } else {
    exit();
 }
    mysql_query("insert into tablename values (".$id." , ...........)");

ako oshte ne si promenil poleto na auto increment moje da polzvash tozi 
kod
krasimir
____________________________________________________
Êàêâî å ðåêëàìà â Èíòåðíåò? - http://reklama.mail.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
============================================================================