[RESOLVED] 1000sof MySQL queries

[thepeccavi]

I am trying to execute arounf 1500 MySQL queries using the same script:

<?php  // Line 1

mysql_connect(..., ..., ...);
mysql_select_db(...);
mysql_query("INSERT INTO..........");
mysql_query("INSERT INTO.........."); //Line 6
etc....
?>

However, I am getting this error:
Parse error: syntax error, unexpected T_STRING in /home/isaac/public_html/thepeccavi/bsc/pupils/sql.php on line 6

What is wrong????

--Isaac

[void_function]

You missed to escape a double quote in line 5?

[thepeccavi]

Sorry.... really odd solution to this problem:

mysql connect etc.

$queries[] = "INSERT INTO etc.....";
$queries[] = "INSERT INTO etc.....";

$done = 0;
$failed = 0;

foreach($queries as $query){
echo 'Executing query "' . $query . '".....';
if(mysql_query($query)){
echo '......Done!<br />';
$done++;
}else{
echo '......FAILED.<br />';
$failed++;
}
}

echo 'Number of queries completed sucessfully: ' . $done . '<br />';
echo 'Number of queries failed: ' . $failed . '<br />';
echo 'Total queries: ' . $done + $failed . '<br />';

?>

All works now!

[void_function]

Good. Please mark the thread resolved. 😃

[thepeccavi]

thanks! haven't used PHP Builder for so long I forgot!