Insert Multiple Data into a table

I am having difficulties.

Is it possible to Insert multiple data into a database table at one time?

an example

two columns

Beckham Man UTD
Owen Liverpool
Henry Arsenal

Thats what my page looks like.

I want to insert all three of them lines into the database in one table.

But all it does at the moment is inserts

Henry Arsenal

it does the last line all the time.

Pweese Help

No, U have to query three times in your case ...

But you can write a loop

You could also write it as a single insert:

INSERT INTO <table> VALUES ("Beckham","Man UTD"),("Owen","Liverpool"),("Henry","Arsenal");

This type of insert will be faster if you have alot of data to insert.

Cheers,
Keith.

Hi,

Because i am getting the details from the database, this makes my problem a little bit difficult.

On the page where it displays, Beckham Man UTD, Owen Liverpool, Henry Arsenal. It doesnt actually say there names,

the code is
echo "
<tr>
<td>Player</td>
<td>Club</td>
</tr>";

while ( $row = mysql_fetch_array( $sql_result ) )

{

$player = $row["player"];
$club = $row["club"];

echo "

<tr>
<td>$player</td>
<td>$club</td>
</tr>";

So this get all the players and clubs in the database. So i dont actually say player club three times, just once.

im looking for something like

if $num_rows = number of rows in DB

then insert * into table

How would i go about this please.

Cheers

This should work :

You just need to modify it a little though, to connect and all that stuff.