On Thursday 05 December 2002 13:24, Ben C. wrote:
> I am struggling with the code below. I keep getting the error "Couldn't
> execute query". Please help me out, let me know where I am going wrong.
>
> <?
>
> $db_name = "db1";
> $table_name = "user";
>
> $connection = @mysql_connect("localhost", "user", "password") or
> die("Couldn't connect.");
>
> $db = @mysql_select_db($db_name, $connection) or die("Couldn't select
> database.");
>
> $sql = "UPDATE $table_name
> SET
> name = \"$name\",
> lname = \"$lname\",
> mobil = \"$mobil\",
> email = \"$email\",
> url = \"$url\",
> WHERE id= \"$id\"
> ";
>
> $result = @mysql_query($sql,$connection) or die("Couldn't execute query.");
>
> ?>
How about NOT masking the error message by using mysql_query(), instead of
@mysql_query(). And instead of using die(), use echo mysql_error().
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
A rolling stone gathers no moss.
-- Publilius Syrus
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
