do you even have register_globals enabled?
otherwise $submit, $id and so on will not be set.
Thomas
On Tue, 10 Jun 2003 19:11:21 +1000 [EMAIL PROTECTED] (Ben Houlton) wrote:
> <HTML>
> <BODY>
>
> <?php
>
> $db = mysql_connect("localhost","root");
>
> mysql_select_db("main",$db);
>
> if ($submit) {
>
> if ($id) {
>
> $sql = "UPDATE edit SET
> sub='$sub',msg='$msg',name='$name',email='$email',newday='$newday' WHERE id=$id";
> } else {
>
> $sql = "INSERT INTO edit (sub,msg,name,email,date,time,newday) VALUES
> ('$sub','$msg','$name','$email','$date','$time','$newday')";
> }
>
> $result = mysql_query($sql);
>
> echo "Record updated/edited!<p>Return to <A
> href=\"index2.php?page=edit\">$sub</a>.";
>
> } elseif ($delete==areyousure) {
>
> $sql = "SELECT * FROM edit WHERE id=$id";
>
> $result = mysql_query($sql);
>
> echo "Are you sure you want to delete $sub?<p><a
> href=$PHP_SELF?page=edit&id=$id&delete=true>Yes</a> | <a
> href=$PHP_SELF?page=edit>No</a>";
>
> } elseif ($delete==true) {
>
> $sql = "DELETE FROM edit WHERE id=$id";
>
> $result = mysql_query($sql);
>
> echo "$sub Record deleted!<p><a href=index2.php?page=edit>Return</a>";
>
> } else {
>
>
> if (!$id && !$edit) {
>
> $result = mysql_query("SELECT * FROM edit ORDER BY time ASC",$db);
>
> while ($myrow = mysql_fetch_array($result)) {
>
> $newday = false ;
>
> $newday = $myrow['newday'] ;
>
> if ($newday) {
>
> printf("<TABLE border=0 cellpadding=0 cellspacing=2 width=%s><TR><TD
> align=right class=newsdate width=%s><P style=text-align:
> right><b>%s</b></TD></TD></TABLE>", $myrow["width"], $myrow["width"],
> $myrow["date"]);
>
> }
>
> printf("<font class=newstitle><b><a
> href=\"%s?page=edit&edit=yes&id=%s\">%s</a></b></font><font class=newsnfo> - <a
> href=mailto:%s>%s</A> @ %s AEST</font><br>", $PHP_SELF, $myrow["id"], $myrow["sub"],
> $myrow["email"], $myrow["name"], $myrow["time"]);
>
> printf("%s<br><br>", $myrow["msg"]);
>
> printf("<a
> href=\"index2.php?page=edit&id=%s&delete=areyousure\">(DELETE)</a><br>",
> $myrow["id"]);
>
> }
>
> echo "<P><a href=index2.php?page=edit&edit=yes>ADD A RECORD</a><P>";
>
> }
>
> }
>
> ?>
>
> <?php
>
> if ($edit) {
>
>
> ?>
>
> <form method="post" action="index2.php?page=edit">
>
> <?php
>
>
>
> if ($page && $id) {
>
> $sql = "SELECT * FROM edit WHERE id=$id";
>
> $result = mysql_query($sql);
>
> $myrow = mysql_fetch_array($result);
>
> $id = $myrow["id"];
>
> $name = $myrow["name"];
>
> $email = $myrow["email"];
>
> $sub = $myrow["sub"];
>
> $msg = $myrow["msg"];
>
> $newday = $myrow["newday"];
>
> $width = $myrow["width"];
>
>
> ?>
>
> <input type=hidden name="id" value="<?php echo $id ?>">
> <?php
>
> }
>
> ?>
> <input type=hidden name="date" value="<?php echo date("l, F, jS Y"); ?>">
> <input type=hidden name="time" value="<?php echo date("H:i:s"); ?>">
> <input type=hidden name="width" value="100%">
>
> Name:<input type="Text" name="name" value="<?php echo $name ?>"><br>
>
> E-Mail:<input type="Text" name="email" value="<?php echo $email ?>"><br>
>
> Subject:<input type="Text" name="sub" width=50 value="<?php echo $sub ?>">New
> Day?<input type="radio" name="newday" value="1">Yes<input type="radio" name="newday"
> value="0">No<br>
>
> Message:<textarea name="msg" rows="7" cols="80" wrap="virtual"><?php echo $msg
> ?></TEXTAREA><br>
>
> <input type="Submit" name="submit" value="Enter information">
>
> </form>
>
>
>
> <?php
>
> }
>
> ?>
>
> </BODY>
> </HTML>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
