SELECT * from hwu_articles WHERE id = '$id' and price is not null and name
is not null and ratings is not null;
Bhavin.
- Original Message -
From: "Alex Behrens" <[EMAIL PROTECTED]>
To: "MYSQL" <[EMAIL PROTECTED]>
Sent: Friday, August 02, 2002
Hi Guys,
I'm still new to this and I'm trying to get back into and I need help with a
simple query. I have a list of info about a product for an article on my
website and I'm pulling all this info from a mysql db and displaying it
byway of php but don't know how to do the que
Hi Guys,
I'm still new to this and I'm trying to get back into and I need help with a
simple query. I have a list of info about a product for an article on my
website and I'm pulling all this info from a mysql db and displaying it
byway of php but don't know how to do the que
Try this. I couldn't find if MYSQL supports not in's so I followed there
outer joins. You can read up on in in the mysql manual, do a search on
outer joins.
select base.zipcode,properties.zipcode from base right join properties on
base.zipcode=properties.zipcode where base.zipcode is null;
On
> I have 2 tables:
>
> bases, and properties
>
> base has a ZIPCODE field in the table, as does the properties table.
>
> I'm trying to find all bases that do NOT have a property in that zip code.
>
> What I've tried is:
The general answer:
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_10_0
In yo
I have 2 tables:
bases, and properties
base has a ZIPCODE field in the table, as does the properties table.
I'm trying to find all bases that do NOT have a property in that zip code.
What I've tried is:
select distinct cb.*, cp.* from classified_bases as cb left join
classified_properties as
