MySQL Insert

[Jezza]

When I Insert in MySQL i want to grab the ID it auto assigns, take this for example

<?
$qry = mysql_query("INSERT INTO `Cars` (
`ID`,`Make`,`Model`
)
VALUES (
NULL,'$_POST[Make]','$_POST[Model]'
);
");
echo "Car ID is _____";
?>

How do i find out the car ID the MySQL database assigned?

[oni-kun]

  Quote

When I Insert in MySQL i want to grab the ID it auto assigns, take this for example

<?
$qry = mysql_query("INSERT INTO `Cars` (
`ID`,`Make`,`Model`
)
VALUES (
NULL,'$_POST[Make]','$_POST[Model]'
);
");
echo "Car ID is _____";
?>

How do i find out the car ID the MySQL database assigned?

This should return the last entered ID:

<?php
$qry = mysql_query("INSERT INTO `Cars` (`ID`,`Make`,`Model`) VALUES (NULL,'$_POST[Make]','$_POST[Model]');");
echo "Car ID is " . mysql_insert_id();
?>

 

Note you should never use short tags (<?) in PHP. It is widely disallowed and not compatable.

 

EDIT: You should use mysql_real_escape_string on your query to disallow SQL injection..

[Jezza]

  Quote

  Quote

When I Insert in MySQL i want to grab the ID it auto assigns, take this for example

<?
$qry = mysql_query("INSERT INTO `Cars` (
`ID`,`Make`,`Model`
)
VALUES (
NULL,'$_POST[Make]','$_POST[Model]'
);
");
echo "Car ID is _____";
?>

How do i find out the car ID the MySQL database assigned?

This should return the last entered ID:

<?php
$qry = mysql_query("INSERT INTO `Cars` (`ID`,`Make`,`Model`) VALUES (NULL,'$_POST[Make]','$_POST[Model]');");
echo "Car ID is " . mysql_insert_id();
?>

 

Note you should never use short tags (<?) in PHP. It is widely disallowed and not compatable.

 

EDIT: You should use mysql_real_escape_string on your query to disallow SQL injection..

 

Oh I didn't know it was that simple haha, thanks. Why are <? disallowed and not compatible? I have always used it on my websites and had no problems.

[Mchl]

http://www.php.net/manual/en/language.basic-syntax.phpmode.php

 

  Quote

Note: Using short tags should be avoided when developing applications or libraries that are meant for redistribution, or deployment on PHP servers which are not under your control, because short tags may not be supported on the target server. For portable, redistributable code, be sure not to use short tags.

[Jezza]

  Quote

http://www.php.net/manual/en/language.basic-syntax.phpmode.php

 

  Quote

Note: Using short tags should be avoided when developing applications or libraries that are meant for redistribution, or deployment on PHP servers which are not under your control, because short tags may not be supported on the target server. For portable, redistributable code, be sure not to use short tags.

 

Oh i'm fine then, thanks heaps