create a table

[Anon]

how do i create table in MySQL with an autonumber fields?

i'm a begginer, so please write my a the code.

[Anon]

hello, in php, as transfer a value (parameters) of a pagina to another pagina? you can help me?

[Anon]

www.mysql.org 's documentation is a good place to look for this type of information.

But this is how you would create a table with a field called "indexnum" which increments. This field must also be primary. I've also added two other fields, "realname" and "phonenum" for the example. "temp" is the name of the table.

CREATE TABLE temp (indexnum INT not null AUTO_INCREMENT, realname VARCHAR (60) not null , phonenum VARCHAR (60) not null , PRIMARY KEY (indexnum));

Cheers,

[Anon]

To execute the command in PHP, first establish your connection and select your database, then use mysql_query()

$result = mysql_query(...what james said...);

---JH

[Anon]

john,
what do i do with the value "$result"?

$result = mysql_query(...what james said...);

how do i execute the query?
or it's does it automaticly?

[Anon]

$result should be true if the CREATE succeeded, or false if it failed for some reason.

If it fails, use

echo mysql_error();

to see why.

---JH