Jump to content

undertaker16

New Members
  • Posts

    5
  • Joined

  • Last visited

    Never

Everything posted by undertaker16

  1. I need someway to update a record to set the status to "archived" after it checks to see if it is older than a certian amount of days by checking say a column "creation_date". thanks
  2. I need help... I am trying to create a php script that will check the date that a record was created and if a config var. is set to say 30, it will set the record's status to archived or something. Please help if you can.. Josh
  3. code for aheader.php: CODE <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 TRANSITIONAL//EN"> <html> <head> <title>GuestBook Administration</title> <script language="Javascript"> function delEntry(id,name) { if(confirm("Are you sure you want to delete " + name + "\'s entry?")) { window.location.href='delete.php?id=' + id; } } </script> </head> <body> Code for admin.php: CODE <?php include("config.php"); include("$header"); $result=mysql_query ("SELECT id,name,message FROM `gbook` WHERE id>=1 ORDER BY id "); if ($row=mysql_fetch_array($result)) { print("<h2><center><p align=\"center\">All entries are shown below. Click the appropriate links according to which action you'd like to perform.</p></center></h2>"); $id = $row[id]; $name = $row[name]; $msg = $row[message]; echo "<table><tr bgcolor=\"696969\" text=\"#ffffff\"><th>Action</th><th>Name</th><th>Message</th></tr>"; do { ?> <tr><td><a href="java script:delEntry('<?php echo $id; ?>','<?php echo $name; ?>');">Delete</a></td> <td><?php echo $name; ?></td> <td><?php echo $msg; ?></td> </tr> <? } while($row = mysql_fetch_array($result)); } else { print("<h2><center><p align=\"center\">There are no entries in this Guestbook.</p></center></h2>"); } echo "</table><br /><br />"; //include("$footer"); ?> Code for add.php: CODE <?php require("config.php"); $name = $_POST["name"]; $message = $_POST["message"]; $query = "INSERT INTO `gbook` VALUES ('', '$name', '$message')"; mysql_query($query); print("<meta http-equiv=\"refresh\" content=\"5;url=index.php\""); print("<center><h1><p align=\"center\">Thank you, $name, for your message.</p>"); print("<p align=\"center\">You will be redirected back within five (5) seconds ...</p></h1></center>"); [code] [/code]
  4. HELP!!! I have a very simple php and mysql app and it will work, but when i Sign my own guest book and the i go to admin.php it will pull the first entry out and if there are more than one, it will keep the same one it pulled out in the first place. Also, when i delete the first entry it will redirect me back to admin.php and it will repeat. WHY???????? If you need the code please reply.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.