maddie2120

Okay I think I prefer the simpler statement. Many thanks again, I'm still working on this application and I'm sure I'll run into all sorts of problems so I'll certainly be using this forum a lot.

Thank you very much, that's done the trick - not sure why it includes the additional bit, is it just testing for a boolean value?

Yes, if the form has not been submitted then display the form, if it has then go to: // Let's go to the List page Header("Refresh: 1;url=list.php"); echo <<< _HTML_END_ Reminder Added, redirecting ... _HTML_END_; } else { // Error occurred let's notify it echo( $error ); } }

Yes I accidentally commented out the following code at the top of the page: <?php include('../dbconnect.php'); // database connectivity file if($_POST['step'] != '1') { ?> Unfortunately now I keep getting the 'undefined index' error message, the 'if' statement refers to the hidden field in the form. Any ideas as to how I can fix this? I have an understanding of php but I'm really a novice at this.

Thank you for your quick response, I must have had a senior moment - I'd commented out the 'if' statement at the top of the page. Hopefully problem is sorted now. Many thanks

It sounds as though you may not have permission to access php at this level, you might have to contact your server administrator and ask them to do it for you. Hope this helps

Hi I found this php code which I'm adapting for a project, and I've run into the curly braces problem - could someone look at it for me as I've been looking for hours and still can't sort it out!. It's a form that adds dates and information to a database, the problem is at the error handling stage towards the end of the script - if anyone has any ideas I would be very grateful <form name="reminder" action="remind.php" method="post"> <table border='0' align='center' cellpadding="5" cellspacing="5"> <tr> <td>First Name:</td> <td colspan="3"> <input name="fname" type="text" maxlength="30" /> </td> </tr> <tr> <td>Last Name:</td> <td colspan="3"> <input name="lname" type="text" maxlength="30" /> </td> </tr> <tr> <td>Email Address:</td> <td colspan="3"> <input name="email" type="text" maxlength="50" /> </td> </tr> <tr> <td>Comapny:</td> <td colspan="3"> <input name="company" type="text" maxlength="50" /> </td> </tr> <tr> <td>Date Certificate taken:</td> <td> Day:<br /> <select name="day"> <?php for($counter=1;$counter<=31;$counter++) { if($counter < 10) $prefix = "0"; else $prefix = ""; echo("\n<option>$prefix$counter</option>"); } ?> </select></td> <td>Month:<br /> <select name="month"> <?php for($counter=1;$counter<=12;$counter++) { if($counter < 10) $prefix = 0; else $prefix = ""; echo("\n<option>$prefix$counter</option>"); } ?> </select></td> <td>Year:<br /> <select name="year"> <?php $current_year = date("Y"); for($counter=$current_year;$counter>=$current_year-5;$counter--) { echo("\n<option>$counter</option>"); } ?> </select></td> </tr> <tr> <td id="alert">*Please complete all fields</td> <td colspan="3"> <input name="step" type="hidden" value="1" /> <input name="submit" type="submit" value="add" /> </td> </tr> </table> </form> </div> </body> </html> <?php // Check for errors in the submitted form... } else { $error = ""; $date = date( "dmY" ); $renew_date = $_POST['day'].$_POST['month'].$_POST['year']; if( empty($_POST['fname']) ) $error .= "Please enter a first name<br />"; if( empty($_POST['lname']) ) $error .= "Please enter a last name<br />"; if( empty($_POST['email']) ) $error .= "Please enter a valid email address<br />"; if(!isEmail($email) ) $error .= "You have entered an invalid e-mail address, please try again.<br />"; if( !checkdate( $_POST['day'], $_POST['month'], $_POST['year'] )) $error .= "The date entered is invalid, please check<br />"; if( empty( $error ) ) { // No error let's add the entry mysql_query( "INSERT INTO clients('first_name', 'last_name', 'email', 'enrolled', 'company') VALUES('".addslashes($_POST['fname'])."', '".addslashes($_POST['lname'])."', '".addslashes($_POST['email'])."', '".addslashes($renew_date)."', '".addslashes($_POST['company'])."')" ); // Let's go to the Reminder List page Header("Refresh: 1;url=list.php"); echo <<< _HTML_END_ Reminder Added, redirecting ... _HTML_END_; } else { // Error occurred let's notify it echo( $error ); } } ?>

Thanks - I was more interested in any php date scripts combined with cgi that could do the job, sorry I didn't make that clear

Hi thanks for the help, yes I think the cron job idea is the way to go. Does anyone know of any scripts already out there that can be tweaked for individual use?

Hi could someone point me in the right direction, I'm trying to write an application that sends out reminder emails to clients who need to renew their qualifications online. Does anyone know of an automated script or one that could be adapted and used. Any help would be greatly appreciated. Maddie