Data won't Update via PHP/MySQL UPDATE

[cleftobrainiac]

Hi,

I've been wrestling with this for a while and finally decided to ask for outside assistance.

I'm getting no errors with my code. If I print all the of the variables they have values but when I run my script to update the table it doesn't input them. The loop is iterating all the way through but the data just isn't making it's way into the table. I've never encountered this before and I'm hoping someone may have an answer for me.

PHP 4.3.2 / MySQL 3.23.58


[PHP]for ($i = 0; $i < $length; $i++)
{
$query = "UPDATE microcpus SET netBios = '".$a_result[$i][2]."', memory = '".$a_result[$i][4]."', os = '".$a_result[$i][6]."', csd = '".$a_result[$i][7]."', user = '".$a_result[$i][8]."', lastscan = '".$a_result[$i][9]."', vidio = '".$a_result[$i][10]."', processor = '".$a_result[$i][11]."', disk = '".$a_result[$i][12]."', netcard = '".$a_result[$i][13]."', network = '".$a_result[$i][14]."' WHERE serial = '".$a_result[$i][3]."'";
$result = mysql_query($query);
}
[/PHP]

Thanks,
Steve

[ronverdonk]

Get the result of the query by expanding the mysql_query statement as follows:

$result = mysql_query($query) or die ("UPDATE error: ".mysql_errror());
 

then investigate any error message returned.

Ronald

[Atli]

Hi Steve. Welcome to TSDN!

Do you have the debug messages turned on?

Try adding die() to your mysql_query() function:

$result = mysql_query($sql) or die("Query failed : ". mysql_error());
 

[cleftobrainiac]

Thanks!

I had already tried that with no luck...

It produced no errors.

[Atli]

Have you tried echoing the query, just to see if it looks like you expect it to?

[cleftobrainiac]

You know, I hadn't done that. And what do you know, the html page I was stripping data from was formatted poorly and because of that it was inserting a blank space as the first character in some of the fields of my array.

I added some code to strip the character out of my array elements, reran the script and all the data imported.

Thanks, I knew I just needed another perspective.