Error with "Where" Clause

From: 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";

« previous php.db (#38904) next »