help me please error

Loacker

where the error in the code?

<?
include("config.php");
if($loacker=="delete")
{
$del=mysql_query("SELECT * from book ");
$del=mysql_query("DELETE FROM book WHERE id=$id");
echo"date delete";
}
if($loacker=="update")
{
$upd=mysql_query("SELECT * from book ");
$upd=mysql_query("update from book set title=$title,name=$name,msg=$msg where id=$id");
echo"date update";
}
$query= mysql_query("SELECT * FROM book");
While ($row=mysql_fetch_array($query))
{
echo "<form>
<input type=hidden name=id size=5 value=$row[id]>
<input type=text name=title size=20 value=$row[title]>
<input type=text name=name size=20 value=$row[name]>
<input type=text name=msg size=20 value=$row[msg]><BR>
<input type=radio value=delete name=loacker>dele<BR>
<input type=radio value=update checked name=loacker>updt<BR>
<input type=submit value=ok>
</form>
";
}


?>

icon update didn't work🙁
why?

planetsim

Probably better for the general or newbies forum this question. I cannot see any errors besides you coding in register_globals = off

use $_POST if from a form and the method is post

use $_GET if the information is coming from the string off the url e.g.

mydomain.com?url=http://phpbuilder.com

$_GET['url'] will echo out http://phpbuilder.com

and more check out the predefined variables in the manual http://www.php.net/manual/en/language.variables.predefined.php

also a little curious about this bits of code

$del=mysql_query("SELECT * from book ");
$del=mysql_query("DELETE FROM book WHERE id=$id");

and

$upd=mysql_query("SELECT * from book ");
$upd=mysql_query("update from book set title=$title,name=$name,msg=$msg where id=$id");

In both situations you select from the database however you never use the variable again. Get rid of both selects and the $upd and $del on the Update query and Delete query they will not work otherwise.

mourisj

Your <form> tag is incomplete. You should have something like

where doit.php is the name of the script you call to execute the action.

Maybe you should also quote your tag attributes (it's more XML-conform).

HTH

JJ Mouris

Loacker

see attachment
this is my project
button update in file admin didn't work?
why?🙁