how to store table of data in to mysql?

[vijay bharath]

How to store table of data into mysql at single query ? please reply me

[AutumnsDecay]

If you have a form, for example, that has:

First Name:
Last Name:
Email Address:

and you wanted to put those values into a table called 'users', you'd do:

$fname = $_POST['firstname'];
$lname = $_POST['lastname'];
$email = $_POST['emailaddress'];
 
$query = "INSERT INTO `users` (Firstname, Lastname, Email) VALUES ('$fname', '$lname', '$email')";
 
mysql_query($query);
 

The table 'users' would need a field thats used as the primary key that auto increments with each new submission to the table.