Re: [PHP] Problem with simple update

2003-01-24 Thread Marek Kilimajer
on Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 -Original Message- From: Marek Kilimajer [mailto:[EMAIL PROTECTED]] Sent: 24. tammikuuta 2003 13:55 To: Steve Jackson Cc: PHP General Subject: Re: [PHP] Problem with simple update

Re: [PHP] Problem with simple update

2003-01-24 Thread Marek Kilimajer
remove the hidden field and use in action script you do foreach($_POST['catorder'] as $catid => $catorder) { update categories set catorder=$catorder where catid=$catid } Steve Jackson wrote: I am trying to set the order of a set of categories. Previously the catid field sorted the order

[PHP] Problem with simple update

2003-01-24 Thread Steve Jackson
I am trying to set the order of a set of categories. Previously the catid field sorted the order of the categories. However I changed this to Order By catorder and then set about writing a simple update query to allow people to set the order. I can't see anything wrong with this: Basically I pull