John,
> > > I can see no explanation in the data stored in the table.
> > The important thing is what MySQL 'sees'!
> >
> > You've already started testing your premise << > are
> > either "input" or "published">>> One suggestion would be to use the
> > MySQL client for investigations, then if you
I ran the following command to change the status field from a varchar
text to ENUM("Input","Published") NOT NULL
$sql = "ALTER TABLE $table_name
CHANGE status
status ENUM(\"Input\",\"Published\") NOT NULL
";
The changes took effect according to the comm
Have you tried running these from the command line mysql client, to see what
may be up? Maybe you have a variable in your code that's not getting
re-initialized properly.
If you get the same results from the mysql client, it might be time to run
myisamchk on your table. (or just dump the data, dr
--- DL Neil <[EMAIL PROTECTED]> wrote:
> John,
>
> > I tried using LIKE \"%published%\" and even LIKE \"%ub%\" The
> > results are the same as when I attempt = \"published\"
> >
> > Something in the query processing works differently when = is
> used in
> > the WHERE.
> >
> > I can see no expla
John,
> I tried using LIKE \"%published%\" and even LIKE \"%ub%\" The
> results are the same as when I attempt = \"published\"
>
> Something in the query processing works differently when = is used in
> the WHERE.
>
> I can see no explanation in the data stored in the table.
The important thing
re any other funky characters
> causing
> problems. If the modified where conditions return the correct
> results,
> there's something wrong with the data.
>
> --jeff
>
> - Original Message -
> From: "John Hughes" <[EMAIL PROTECTED]>
> To:
--- Georg Richter <[EMAIL PROTECTED]> wrote:
> On Saturday, 2. March 2002 09:32, John Hughes wrote:
> > I have a table with approximately 600 rows. Two of the fields are
> > "record_date" and "status" Every record has an entry in the
> > "record_date" in -00-00 format. The "status" is eithe
On Saturday, 2. March 2002 09:32, John Hughes wrote:
> I have a table with approximately 600 rows. Two of the fields are
> "record_date" and "status" Every record has an entry in the
> "record_date" in -00-00 format. The "status" is either "input"
> or "published" (I DID NOT create this colu
something wrong with the data.
--jeff
- Original Message -
From: "John Hughes" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, March 02, 2002 12:32 AM
Subject: Query structure puzzle
> I have a table with approxima
I have a table with approximately 600 rows. Two of the fields are
"record_date" and "status" Every record has an entry in the
"record_date" in -00-00 format. The "status" is either "input"
or "published" (I DID NOT create this colum as ENUM; those are simply
the only values my PHP interface
10 matches
Mail list logo
