mysql INSERT multiple row data?

[nbennett]

hi - i'm still relatively new at mysql coding - is there any way to make mulitple row insert queries?

something like:

$query = "INSERT INTO $table (name, number, , date) VALUES ($name1, $number1, '$date1'), VALUES ($name2, $number2, '$date2'),VALUES ($name3, $number3, '$date3')";

$result = mysql_query($query, $db)

thanks

ha ok figured it out

[Lars_Berg]

 $query = "INSERT INTO $table (name, number, , date) VALUES ($name1, $number1, '$date1'), ($name2, $number2, '$date2'), ($name3, $number3, '$date3')";