Update A Row in SQl

A

Anonymous

Guest
Hey does this look right because it says it worked but it doesnt update?

Code: 
<?php 

include "config.php"; 

$db = mysql_connect($db_host,$db_user,$db_pass); 
mysql_select_db ($db_name) or die ("Cannot connect to database"); 
/* We have now connected, unless you got an error message */ 
/* Lets save some news ! */ 
$query = "UPDATE news SET title='$_POST[title]', news='$_POST[news]' WHERE id = $_GET[id]"; 
$result = mysql_query($query); 
echo "News item saved."; 
mysql_close($db); 
?>
 
Maybe this does the tric :D

I've changed the WHERE id = $_GET to $_POST
PHP: 
<?php
include ("config.php"); 

$db = mysql_connect($db_host,$db_user,$db_pass); 
mysql_select_db ($db_name) or die ("Cannot connect to database"); 
/* We have now connected, unless you got an error message */ 
/* Lets save some news ! */ 
mysql_query("UPDATE news ".
" SET title = '$_POST[title]', ".
"      news = '$_POST[news]' ".
" WHERE id = '$_POST[id]' ") or die (mysql_error());

echo "News item saved."; 
mysql_close($db); 
?>
Greetz,
Enq
 
Echo your query and see if it looks like you expect it to. Post it here.
 
$query = "UPDATE news SET title='".$_REQUEST['title']."', news='".$_REQUEST['news']."' WHERE id = ".$_REQUEST['id'];

wow... look at all these new emoticons! :-D
 
If you´re using a form to post the data, use $_GET or $_POST depending on its method. Otherwise use $_GET.
PHP: 
<?php 
$title = $_POST['title'];
$news = $_POST['news'];
$id = $_POST['id'];

mysql_query("UPDATE news SET title = '$title', news = '$news' WHERE id = '$id' ") or die (mysql_error());
?>
 
You must log in or register to reply here.
Back
Top