Posted by mantrid on 08/07/06 16:01

>
> This I did and it is as expected,
> Another thing I tried was to put the queries outside of the loop and
> substitute the values from the arrays (which are also ok as i checked them
> when i ran phpinfo()) with numbers as shown below
>
>
> $q2 ="UPDATE usercomms SET typeid=1 WHERE userid=".$_SESSION['userid']."
AND
> commindex =339";
> $updateusercomm = mysql_query($q2) or die('<br><span
class=RedWarning>Sorry,
> there was a problem updating. Try again.<br><br>Error - 1
> '.count($delarray). mysql_error().'</span>');
>
> $q="UPDATE comments SET typeid=1, comment='ggdsffgdsfg', available=1,
> timestp='$currtime', globalavail=0 WHERE commindex=339"; $updatecomm =
> mysql_query($q) or die('<br><span class=RedWarning>Sorry, there was a
> problem updating some records. Try again.<br><br>Error - 2
> '.count($delarray).mysql_error().'</span>');
>
> And this worked. so it looks like it is the loop or something
>
> by the way miguel I like your photos. i to love travelling but havent put
> mine on the web, something i'd like to do. much of mine are still on paper
> so a lot of work to do.
>
> Ian
>
>


ok getting closer. it is this bit

for ($i = 0; $i < count($commindexarray); $i++){

i tested it with the following and it worked on those 100 records

for ($i = 0; $i <= 100; $i += 1){


ian

[Back to original message]