Trying to save found results to same record..

[typeslow]

Hey, I'm really new to PHP so I think this is a simple problem but I can't figure it out.. I'm trying to save each of the values in the same record, with a different field. It saves to the correct field but with a different record each time. Any help appreciated.

 

$regex6= '/gave it a.*/';
preg_match_all($regex6,$curl,$done['comment']);

$i= 1;
foreach ($done['comment'][0] as $c )
{ 
$d =  substr($c, 50);
$j =$i++;

mysql_connect("localhost", "root");
mysql_select_db("metacritic");
$table = "comment$j";
$e = mysql_real_escape_string($d);
mysql_query("INSERT INTO games ($table) VALUES ('$e')") ;
}

 

 

[attachment deleted by admin]

[Psycho]

You want to create ONE query with all the values for the record. Not run a query for each value

 

mysql_connect("localhost", "root");
mysql_select_db("metacritic");

$regex6 = '/gave it a.*/';
preg_match_all($regex6, $curl, $done['comment']);

$i = 1;
$fields = array();
$values = array();

//Create arrays of the fields and values
foreach ($done['comment'][0] as $comment)
{ 
    $fields[] = "`comment{$i}`";
    $values[] = "'" . mysql_real_escape_string(substr($comment, 50)) . "'";
    $i++;
}

//Build the query
$fieldList = implode(', ', $fields);
$valueList = implode(', ', $values);
$query = "INSERT INTO games ({$fieldList}) VALUES ({$valueList})";

//Run the query
mysql_query($query);

 

[typeslow]

Works great, makes sense. I was bashing my head over this, thanks a lot.