Customise Add Record Form

Now that I have a working form that allows me to add a record I'd really like to customise it more. Two things I'd really like are:

1. An option to save for later - add details but not publish it.
   
2. A preview option - a normal Publish button + 1 for previewing the records before going live

So 3 buttons - Save, Preview and Publish

saving and publishing are really the same thing, for both, you need to save the form information to the database.

in order to distinguish between a saved record and a published record, you would need another column added to the table, lets say for example sake we call this column "status"

you would need to have 2 insert record behaviors on the page, one to trigger off the save button being pressed, in this one, set the status column to 0. the other to trigger off the publish button being pressed in, this one set the status column 1.

for the preview option, you would need to hand code a javascripnt function to use the window.open property to preview the form and trigger this on the onClick event of the preview button.

Ok, not quite got it working. I've added a MySQL field PublishedStatus as Int (11) and added a second submit button. I'm just not quite sure what I need to set in the Insert Record behaviour to give it a value of 1 (or 0). Please see attached file.

in the insert behavior to publish, you set that column value to 1, rather than bind it to a form element to get a dynamic value, just type the number 1 for the value.

in the insert behavior to save the record, type the value 0.

I've done that but hitting Publish gives an error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2011-06-10 07:06:25',1)' at line 1.

Hitting Save just publishes it to the page, ie. live.

find the folllowing copde on the page;

$MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());

and change it to:

$MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error()."<br />".$WA_Sql."");

this will write the full SQL causing the error after the error to help troubleshoot.

Originally Said By: Jason Byrnes

  find the folllowing copde on the page;

php:

$MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());

and change it to:

php:

$MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error()."<br />".$WA_Sql."");

this will write the full SQL causing the error after the error to help troubleshoot.  

I did this but it does not give any errors. It just adds the record to the db as before.

I'm a little confused, in your last post you reported that it was giving you an error:

  I've done that but hitting Publish gives an error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2011-06-10 07:06:25',1)' at line 1.  

I'm confused too. It was giving that error but not now. It's just not saving the contents of the form for later editing, simply inserting the record into the DB no matter whether you hit save or publish.

well, yes, both buttons, publish and save will insert the record to the table.

the difference will be the value of the PublishedStatus column, if this column has a value of 1, the article has been published, if it has a value of 0, the articles is only saved.