Jump to content

Archived

This topic is now archived and is closed to further replies.

tryant4d

mysql not inserting all data

Recommended Posts

Hi folks.
I'm using php to dynamically create a query from an array. When the query is run, it doesn't always insert all of the data. Some of the last columns are ignored. It happens on very long inserts... with over 50 columns in the table. But each column, with the exception of the first and optionally the last, are single digits

Is it timing out? Too big for a buffer?

How does one get around this?

[code]$connection = mysql_connect($db, $db_user, $db_pass) or die('1 '.mysql_error());
mysql_select_db($db_2, $connection) or die('2 '.mysql_error());
/*** constructing query that inserts data into table ***/
$query = "INSERT INTO ".$sectionName." (coID,";
for($i=1;$i<=count($_SESSION['currentSection'])-1;$i++){
$query = $query.$sectionNumber."_".$i.", ";
}
$query = $query.$sectionNumber."_".$i.")";
$query = $query." VALUES (\"".md5($_SESSION['setup']['coname'])."\",\"";
for($i=1;$i<=count($_SESSION['currentSection'])-1;$i++){
$query = $query.$_SESSION['currentSection'][$i]."\",\"";
}
$query = $query.$_SESSION['currentSection'][$i]."\")";
/*** cleaning query text ***/
$query = validateQuery($query);
if($result = mysql_query($query, $connection)){
mysql_close($connection);
...  [/code]



Thanks

Tom

Share this post


Link to post
Share on other sites
Show us an echo of the query after it's finished, just before you give it to mysql_query()

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.