[RESOLVED] SQL error, but not really :S

Quadodo

So I'm testing this thing I'm making. And the configuration settings are kept in the database, like so:

id name value
1 language en

etc. Well, the only problem is, the query I'm using:

SELECT * FROM {$prefix}config

Only returns the rows that have an even number for an id. I tried:

SELECT * FROM {$prefix}config WHERE id='1'

But that didn't return anything and:

SELECT * FROM {$prefix}config WHERE id='19'

Didn't return anything either. Does anyone know a fix?

NogDog

It doesn't explain the query with no where clause, but if id is a numeric type field, then the number in the where clause should not be quoted.

bradgrafelman

Quadodo wrote:
Only returns the rows that have an even number for an id.

Erm.. well that's peculiar.

If that's the case, then I'd be apt to say that you have no rows with odd number id's. MySQL doesn't have a sense of humor... it doesn't randomly decide to hide all odd-numbered rows (without math, I don't think it even knows what an "odd-numbered" row is)!

Try manually inserting a test row with a set ID # and then doing a SELECT * ?

INSERT INTO `{$prefix}confg` (`id`, `name`, `value`) VALUES (1, 'test', 'test row!');

Quadodo

I know they don't have to be quoted, I just like to, think it looks better. I checked in my phpMyAdmin and it listed all the rows correctly, when I var_dump()ed the $config variable (where all the information is stored) and compared it to the ones from phpMyAdmin it seems only the ones that were even.. so thats where I got that one lol I tried removing the quotes - nothing, I tried manually inserting the thing, it inserted, but still won't select from the database through the * or selecting the specific row. I'm confused this has never happened before 0.o

bradgrafelman

Quadodo wrote:
I know they don't have to be quoted, I just like to, think it looks better

NogDog just likes proper code syntax, but to each his own I guess.

So all of the rows show up fine in phpMyAdmin? Show us the PHP code you're using to retrieve rows.

Quadodo

Bah I figured it out, the way I was managing transactions skipped every other one ha 🙂 Thanks for your time though 🙂