Can you post the "explain levelone" here? One thought is that 1contentID
is a char or varchar instead of an int. Then again, if it were, that exact
code shouldn't have worked.
Are you sure you are doing the query using $sql_element_low and not
something else? You may be echoing it but are you a
This is so frustrating.
> -Original Message-
> From: Marco Tabini [mailto:marcot@;inicode.com]
> Sent: Friday, November 15, 2002 4:14 PM
> To: Hutchins, Richard
> Cc: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] Query Executes in MySQL Command Line, Not From
> PHP.
>
chard
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Query Executes in MySQL Command Line, Not From
> PHP.
>
>
> I don't think you can have column names that start with a number. Are
> you sure you didn't mean to write:
>
>
> $sql_element_low = "UPDATE $
d here. Everything SEEMS to be right.
> -Original Message-
> From: Marco Tabini [mailto:marcot@;inicode.com]
> Sent: Friday, November 15, 2002 3:52 PM
> To: Hutchins, Richard
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Query Executes in MySQL Command Line, Not From
> P
I don't think you can have column names that start with a number. Are
you sure you didn't mean to write:
$sql_element_low = "UPDATE $table SET medialow=NULL WHERE
".$table."contentID=".$_POST["id"]."";
Otherwise, try adding a simple
die (mysql_error());
after the offending line and see what PH
I'm having problems with a query. The query as it reads in my code is:
$sql_element_low = "UPDATE $table SET medialow=NULL WHERE
".$_POST["tbl"]."contentID=".$_POST["id"]."";
All of the varibles get passed as expected. I know this because if I echo
the SQL out to the page, I get:
UPDATE levelone
