Hi , i am doing a bulk upload for photos wich appears 3 browsers to select pictures , then i submit wich will be added to the database on category as "None".
After that redirects to a page wich will select where category=None and display a form with the pictures to put keywords and description when i press submit it prints all the values for each photo such as the keywords and description but i want to update for each photo the description and keywords where category=None.
Here's my code:
for($i=1; $i<=3; $i++){
echo $title[$i];
echo $desc[$i];
echo $keywords[$i];
$photo[$i]=mysql_query("update photos set title='$title[$i]',
description='$desc[$i]', keywords='$keywords[$i]' where category='None' ",$link);
}
the previous page all the textfields with title, category has [] like title[] , the only thing that doesn't work is the query it's like is not in cicle, it should update where category="None" the values for each photo but only records the first result, but if i clear the query and leave the echo it shows all the data typed on each photo.
Can anyone help me ?
