цитирам Teodor Penev <[EMAIL PROTECTED]>:
> 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
============================================================================
