Update tables?

[Anon]

Hi.

Hope that someone can help me with this problem 🙂

I'm trying to update a database from a form.
First of all i get the old data out of the database and into the forms. This is how i do it:

if (!$sideid)
{
$sideid = "startside";
}
?>
<?php
mysql_connect("localhost", "webuser");
mysql_select_db("example");

$sql = mysql_query("SELECT * FROM websider WHERE sideid = '$sideid'");
while($row=mysql_fetch_array($sql))
{
print ("<form action=lagre.phtml method=get>");
print ("<input type=text name='sideid' value=$sideid>");
print ("<textarea cols=45 rows=25 name='innhold'>");
print ("$row[innhold]");
print ("</textarea><br>");
print ("<input type=submit value=Forandre Side>");
print ("</form>");
}

Then i can edit the information in the form and are trying to send it over to a page called lagre.php :

if (isset($sideid) && isset($innhold))
{
mysql_connect("localhost", "webuser");
$query = ("UPDATE websider SET innhold = '$innhold' WHERE sideid = '$sideid");
$result = mysql_db_query("example", $query);
if ($result) {
	echo "<p>Siden er endret.";
	}
else
	echo "Dete gikk galt...";
}

wich has the function to update the database.That it does not do at all.

The database have to fields in the database called "sideid" and "innhold"
I do only wish to update innhold. Both of them are text fields. Can this be wrong?

No i do not know what i'm doing anymore so now i hope that someone can help me to do it right and can continue to develop in php.

Sincerly
Fedde

[Anon]

This Should Help:

<?php

// connect to database

if ($submit) {

// Check to see if id exist

if ($id) {

$sql = "UPDATE conti SET
  colname='$colname' WHERE id=$id";
}

// run SQL against the DB

$result = mysql_query($sql);

// Check for errors
print mysql_error();

echo "<center>Update successful!";
}

} else {

$statement="select * from table where id=$id";

$myresult = mysql_query($statement);

$result = mysql_fetch_array($myresult);

$id = $result["id"];
$lnum = $result["lnum"];
$colname = $result["colname"];

?>

<!-- Set Update Actions -->

<input type="hidden" name="id" value="<?php echo $id ?>">

<CENTER>
<FONT SIZE=3 FACE="Arial">
Form
</FONT>
</CENTER>
<p align="right"><font color="#000000">
Name: </font><input type="text" name="colname" value="<?php echo $colname ?>" size="20"><br>
<input type="submit" value="submit" name="submit"><?php } ?>

Hope this helps you might want to shape it up a little

Richie

[Anon]

Hmm.. Don't think i got this one right. Is this saved in only one php file? Or is it sendt over to another php file like i did do it.

The problem i had was that is written over the whole table leaving sideid=test and innhold=hehe in every table in the database.

I can not get this code working. If someone could give me a clean code with access to the example database (localhost, webuser), table websider and colums "sideid" and "innhold"
wich i can update using a single page or two pages.

Sincerly
Fedde