PHP, MYSQL insert multiple variables

[bell]

Hi, I am currently building a project that requires tweets to be stored in a database. I am using CURL to read the last 10 tweets (from the .xml file) and echo them on a page, I am also trying to store them in a database if they haven't already been added.

 

I can get the oldest tweet (from that set of 10) to store in the database, the rest won't.

 

Here is the code

 

$query01 = "SELECT * FROM tweets4";

 

$result01 = mysql_query($query01)or die(mysql_error());

 

while($row = mysql_fetch_array($result01)){

$latest_id = $row['tweet_id'];

echo '<p>'.$latest_id.'</p>';

}

 

If ($tweet_id <= $latest_id){

echo "Same number";

}

else {

mysql_query("INSERT INTO tweets4(tweet,tweet_id,user_name,user_id,user_img,time_info) VALUES

('".mysql_real_escape_string($tweet)."',

'$tweet_id',

'$user_name',

'$user_id',

'$user_img',

'$time_info') ")

or die(mysql_error());

}

 

Just wondering if you could advise me how to store multiple records in a database with one query?

 

Thanks in advance

[fenway]

Try a multi-valued INSERT statement.