Okay, I feel dumb. After seeing my message appear on the list, in a
different font, I can see that here: $result =
mysql_query($sq12,$connection) or die (mysql_error()); I typed "$sq12"
instead of "$sql2" -- sorry! Works now.
Sam
Sam Folk-Williams wrote:
Hi,
This script
Hi,
This script keeps returning the error "Query was empty" via php's
mysql_error() function. I think this is just a run-of-the-mill query, of
which I have hundreds on this site. I just can't figure this out... any
ideas? I'm probably missing something small. I have tested the variables
and th
Thanks everyone, I suspected it was something quite simple.
Sam
Matt W wrote:
- Original Message -
From: "Paul DuBois"
Sent: Thursday, September 18, 2003 8:17 PM
Subject: Re: using OR in select statement with distinct results
At 7:47 PM -0500 9/18/03, Sam Folk-Williams wrot
Hi,
I keep having this fundamental problem. It seems like this should be
easy enough, but whenever I have a query where I'm using OR in the WHERE
clause and the query is performed on multiple tables, I get strange
results. For example:
SELECT t1.title, t2.auth_name FROM t1, t2, WHERE cat_id =
