[PHP-DB] Sort on Two Columns

2003-12-15 Thread Ken Colburn
I'm trying to sort a table on two columns but none of the options I've tried produces the right result (though the obvious works in mysql: order by caucuses.cbc, caucuses.state). I want to sort first by column caucuses.cbc (which distinguishes about 1/10 of the rows) and then by caucuses.state

Re: [PHP-DB] Missing Data in Columns

2003-12-10 Thread Ken Colburn
On Wed, 10 Dec 2003 16:21:39 -0600, Matt Matijevich <[EMAIL PROTECTED]> wrote: Any ideas? could you post the code you use to output each table row? *** Here's the code requested along with column headings and sort code: # write out table heading echo "\n"; echo "\n"; echo "Representative

[PHP-DB] Missing Data in Columns

2003-12-10 Thread Ken Colburn
Only six of ten columns in a php table show up on the web. I've been using a standard format for many months now and the only difference here is that I'm drawing on more (seven) tables. Even more curious, running the "select" and "where" statements in mysql produces the full table. Also, clic