retrieving sql id

[kitaeshi]

Hi all, i have learned some basic command of php and mysql. i have seem some shopping cart site putting a link like... www.apple.com?id=4512

I set the mysql with the field with auto_increment n set it with primary key and set those misc field for the other data.

The finally step is how to retrieve it. i plan to setup a shopping cart website power by php & mysql and retrive the id n inturn the id will display all the information to the website.

example like the table in mysql have
id=1, name="cloth", material="cotton"

n the website have those variables inplace, $name, $material.

so now is how to merge the whole stuff n make it work for me.

Any assistance or guideline is welcome.

Great thxs for spending time reading my broken English..

Cheers.

[mrhappiness]

[man]mysql_insert_id[/man] hth

[kitaeshi]

thxs for the kind reply, i went to that website that you have placed a link for me and read through the code.

Example 1. mysql_insert_id() example

<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db('mydb');

mysql_query("INSERT INTO mytable (product) values ('kossu')");
printf("Last inserted record has id %d\n", mysql_insert_id());
?>

There are some parameter that i am quite puzzled with.
What id printf, the site say it output formatted string, but what is a formatted string. i have a very low understanding about what it mean here.

secondly, %id .hmmmm what is that command.. i have never encounter a %id before..

I try those code on my computer but the error say "Too few arguments"

Thxs