poraďte pls už fakt nevím....
(je to jen ukazkova tabulka)..
id .. index autoincerement
text ... textove pole...
do phpMyAdmina napíšu dotaz
Kód:
INSERT INTO one VALUES(null, "fasfS");
SELECT LAST_INSERT_ID() as id;
vše v pohodě zobrazí to i v pohodě to IDčko.....
jdu dělat vlastní sript ....
Kód:
<?
$spojeni = mysql_connect("localhost", "root", "***");
$query = "INSERT INTO one VALUES(null, \"Jurmanek\");\n";
$query .= "SELECT LAST_INSERT_ID() as id;";
$result = mysql_db_query("tst", $query, $spojeni);
while ($zaznam = mysql_fetch_array($result))
{
echo $zaznam[id];
}
echo mysql_error();
mysql_close($spojeni);
?>
Hlásí chybu
Kód:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in d:\web_service\web\www\tst\t2.php on line 6
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '; SELECT LAST_INSERT_ID() as id' at line 1