Missing Data in Columns
| From: | Ken Colburn | Date: | Wed, 10 Dec 2003 22:10:46 +0000 |
| Subject: | Missing Data in Columns | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-31972@lists.php.net to get a copy of this message | ||
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, clicking on "Sort" in a blank "Vote" column rearranges the visible vote columns which suggests sorting based on the invisible column. Worse (which I won't try to solve here), when I delete some "select" statements the table disappears.
The link and "select" statement are shown below (I won't copy the extensive "where" statement, but the table didn't appear when that was wrong).
Any ideas?
Ken
http://congress.techpolitics.org/108thfirst.php
# query mysql to get data
$get_data_query = "select fullhouse2.Representative, fullhouse2.Party,
medicarerollcall669.State, medicarerollcall669.CD, hr2passage.passage, estatetaxrepeal.passage,
headstartvote444.vote, hudappropsvote453.vote, energyrollcall630.vote, medicarerollcall669.vote
from fullhouse2, medicarerollcall669, hr2passage, estatetaxrepeal, headstartvote444,
hudappropsvote453, energyrollcall630
where