Error with "Where" Clause
| From: | kc68 at cornell dot edu | Date: | Mon, 14 Mar 2005 23:20:30 +0000 |
| Subject: | Error with "Where" Clause | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-38904@lists.php.net to get a copy of this message | ||
I get only the table headings and text before and after the table, but not the table, when I add the "where" clause as below. Without the "where" clause, the table does come up but (as expected) is repetitive and very long. I'm using a template that I've used many times. I've tried changing the $sort_field at the beginning with no success. Any ideas as to a solution?
Ken
$get_data_query = "select concat(1091vote038.fn, ' ', 1091vote038.ln), 1091vote038.vote, 109caucuses1.party,
1091vote038.state, 1091vote038.cd, 109caucuses1.cbc, 109caucuses1.chc, 109caucuses1.prog, 109caucuses1.bdog,
109caucuses1.rsc
from 1091vote038, 109caucuses1
where
1091vote038.state = 109caucuses1.state
and
1091vote038.cd = 109caucuses1.cd
order by $sort_field $sort_order";