Updating a record

kappaluppa

I want to update a record (hope this isn't too much!)

The record id is passed through the url, like this:

http://www.mywebsite.com/eventsin2.php?cal_id=8

This is what I've got, and it doesn't work:

                                <?php

if(isset($submit)):
$db = mysql_connect("localhost", "root");
mysql_select_db("content", $db);

 $sql = "select * from calendar";
 $result = mysql_query($sql) or die("db query failed_1");

$sql = "update calendar set event = $event', descrip = '$descrip', location_add3 = '$location_add3' where cal_id = $cal_id";

?>

The variables are called to the form like this:

<form action="eventsin-start.php" method="post">
<p class="mainText"><b>Name of Event:</b>
<br>
<input type="text" name="event" size="60" maxlength="100" value="<?php echo $event?>">
</p>
<input type="submit" name="submit" value="Submit Event">
</form>

Thanks for your help. I've poured over the forum and this is the best I could come up with.

Thanks!
Kathy

Weedpacket

First of all, I don't see what that select is doing; $result is going to contain all the data in the calendar table, but none of it is being used.

Second, variables from a posted form should be referred to as $POST['fieldname'], not $fieldname - chances are these days $fieldname is empty. Variables in the query string (or from a GET-method form) are similarly referred to as $GET['fieldname'].

I don't see where $event, $descrip or their ilk are coming from (The select? You don't appear to be setting them anywhere. The form? see the previous paragraph).

kappaluppa

Originally posted by Weedpacket
First of all, I don't see what that select is doing; $result is going to contain all the data in the calendar table, but none of it is being used.

Second, variables from a posted form should be referred to as $POST['fieldname'], not $fieldname - chances are these days $fieldname is empty. Variables in the query string (or from a GET-method form) are similarly referred to as $GET['fieldname'].

I don't see where $event, $descrip or their ilk are coming from (The select? You don't appear to be setting them anywhere. The form? see the previous paragraph).

*the data is being used to fill in the form, as it was when it was originally submitted.

i have used <?php echo $fieldname ?> and it worked. I'm not sure how to use $POST['fieldname']. I tried it with out the PHP info, but it just shows $POST['fieldname'] and not the actual data.

*$event, $descrip and their ilk are supposed to be coming from table=calendar. I am using:
mysql_query("UPDATE calendar set event = '$event', descrip = '$descrip', and so on;")