highest id into variable ?

[Anon]

Hello!

How do I get the highest \\"id\\" out of a table and store in the variable $kvittensnummer please?

This is wrong ;(
$sql = \\"select max ( {id} } FROM (deltagare) as $kvittensnummer\\";

(mySQL and PHP)

Klas

[Anon]

I tried this now:

$sql111 = "SELECT MAX(id) AS variable1 FROM deltagare";

$result=mysql_query($sql11)or die(mysql_error());

But it says, "query was emnty", but there is for sure som "id's" in the table "deltagare"

Klas

[Anon]

The variablename in the mysql_query call is not the same as the one on the previous line.