illegal string problem

Anon

This one has me going crazy!

I testing this and everthing was working sweet as can be, then I just checked it again today and I'm getting this damn illegal string error. Anyone know how to fix this? I'm passing a form which could have hundreds of keywords each assigned with a number for example:
word[0]=this&number[0]=1&word[1]=sucks&number[1]=2
I've cut down the code alot.

Here's it is:

$digit = 0;

if ($word[$digit] !=(''))

do {

mysql_query ("UPDATE wordnumber SET number='$number[$digit]' WHERE word='$word[$digit]'");

$digit++;

} while ($word[$digit] !=(''));

else {}

Anon

Isn't the problem that you're just iterating off the end of the $word array - there's nothing I can see to stop it looping, and eventually coming up against an undefined element.

What's the maximum number of $word values you're expecting? Will all values always be there, or will there be gaps in the sequence?

It depends on the answer to these, what the best solution is.

On the other hand, is this a PHP error or a mysql error?

Anon

Sorry, english was never really my strong point. I'm not sure what you mean about iterating off the end of the $word array.

The maximum number of values would be 50, but it can vary between 1 and 50 values to be updated.

I was thinking that it could be an error, but i don't know how that could have happened in the last few days? I wonder if anyone else has come across on error like this before?

Anon

You previously gave this example as the command line which will call up the PHP script.

word[0]=this&number[0]=1&word[1]=sucks&number[1]=2

In this case, then, $word[2] is not defined at all, and so when $digit reaches 2, you'll get an error.

Would this do what you want?

$digit = 0;
while (isset($word[$digit])) {
.... do the mysql bit ...
$digit++;
}

This will go through the $word values one at a time until it finds one that's not defined, rather than checking for a blank value like your example does.

Anon

Or, if you're going to get up to 50 word input, but (say) $word[3], then $word[10], then $word[49], you'd have to do:

for ($d = 0; $d < 50; $d++) {
if (isset($word[$d])) {
.... mysql stuff ...
}
}