I have a table
CREATE TABLE IF NOT EXISTS
id smallint unsigned NOT NULL auto_increment,
from varchar(50) NOT NULL,
length varchar(20) NOT NULL default '',
date date NOT NULL,
providerid smallint unsigned NOT NULL,
PRIMARY KEY (
I'm trying to make a query on it that would select a row depending on the providerid
select * from reviews where providerid = '39';
but nothing is returned, why is this?
The field is defined as being numeric but you are telling it to look for a string. Try removing the quotes around the number.
my first guess is because there actually aren`t any rows in your table with that providerid
This topic is now closed. New replies are no longer allowed.