Problems deleting and updating the mysql help!

[netsheik]

Hi,

I'm making my homepage and I have problems with the interaction with the mysql. I can't update and delete a register. I use the next code:

Code: Select all

<?
$id = $HTTP_GET_VARS["noticia"];

$usuario="******";
$password="*****";
$database="******";


mysql_connect('localhost',$usuario,$password);
@mysql_select_db($database) or die( "Unable to select database");

mysql_query("DELETE FROM noticias WHERE id = $id");


mysql_close();

include ("page2.php");

?>


For uptadte I use:

Code: Select all


<?

$e_titulo = $titulo;
$e_cuerpo = $cuerpo;
$id = $HTTP_GET_VARS["noticia"];
$usuario="******";
$password="*****";
$database="****";

mysql_connect(localhost,$usuario,$password);
@mysql_select_db($database) or die( "Unable to select database");

mysql_query("UPDATE noticias SET titulo = '$e_titulo', texto = '$e_cuerpo' WHERE id =$id");

mysql_close();

include ("page4.php");


?>



I think that the problem comes when I use WHERE because the updating runs perfect if I don´t use the WHERE sentence but it updates all the table and I want to update only one register which has $id like id value.

I am in redhat server and I am so desperate! Thx and help please![/code]

[dillona_aix]

Your $id is set incorrectly. The proper code is:

Code: Select all

$id = $HTTP_GET_VARS['noticia'];

Notice the single quotes.

[DenisF]

Why are you defining user, pass and db with variables?

waste of code if your script is THAT short, and you use only one connection...

[zoli]

hi,

I would try my sql statement in phpmysqladmin and all other variables would write out - even the whole update and insert string.

This really helps.