multiple update on page load doesn't work. By button does

Hi

I have a multiple update form, attached, which works properly when it is assigned to update when the button is clicked - but if I try to change this to anything else (ideally, 'on page load' is wanted, but I've tried 'if recordset not empty', 'if session x exists' etc) the update fails (and the redirect loses its parameter).

Can you spot anything obvious?

Thanks
Chris

How could it update "before page load" when it is updating based on the sort order submitted with the form? If it updated before page load and redirected then the page would never show? I'm a bit confused about what you are trying to do.

Hi Ray

I thought that was the whole point of the extension having 'before page load'.

http://www.webassist.com/forums/posts.php?id=17347

Is there another way of updating the multiple records without the user having to click a button?

Many thanks

Chris

The page loads before it is displayed.... so I think you want "any form submit"? You can do it "before page load" but the page will never be displayed, so I don't think that is what you want.

How do you want it to work?

Hi Ray

I'm hoping that those records without a sortorder value will be updated to the RepImgID value (this is the primary key).

An update query would look something like

update pageimages set sortorder = repimgid where sortorder is null and PgID=$_GET['PgID'] - I can do this direct in the database, but don't know how to do it on the page, if the extension doesn't work as I thought.

Cheers
Chris

It will not work like that. It is designed to update based on user-configurable fields from a form. However what you want is a pretty easy query to just run on the page like:

<?php
mysql_select_db($database_connRoSite, $connRoSite);
mysql_query("UPDATE pageimages SET SortOrder = RepImgID WHERE SortOrder IS NULL", $connRoSite);
?>

Thanks Ray

For future proofing, how would this be with a mysqli update (I have connRoSite_i for other pages - roll on the new extension!)

Thanks
Chris

It is nearly identical using the queryobj.php include:

<?php
$Query = new WA_MySQLi_Query($localhost_i);
$Query ->Statement = "UPDATE pageimages SET SortOrder = RepImgID WHERE SortOrder IS NULL";
$Query ->execute();
?>

Thanks for your help, Ray