Re: Missing Data in Columns
| From: | Ken Colburn | Date: | Wed, 10 Dec 2003 22:39:42 +0000 |
| Subject: | Re: Missing Data in Columns | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31975@lists.php.net to get a copy of this message | ||
On Wed, 10 Dec 2003 16:21:39 -0600, Matt Matijevich <matijevich@alliancetechnologies.net> wrote:
<snip> Any ideas? </snip> 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 "<table width='75%' border='1' cellspacing='0' cellpadding='0' align='center' bgcolor='#CCCC99'>\n"; echo "<tr>\n"; echo "<td><div align='center'><font size='3'><b>Representative </b></font></div></td>\n"; echo "<td><div align='center'><font size='3'><b>Party <a href='108thfirst.php?sort_field=Party&sort_order=asc' target='_self'><font size='2'>Sort</a> </b></font></div></td>\n"; echo "<td><div align='center'><font size='3'><b>State <a href='108thfirst.php?sort_field=State, CD&sort_order=asc' target='_self'><font size='2'>Sort</a> </b></font></div></td>\n"; echo "<td><div align='center'><font size='3'><b>District </b></font></div></td>\n"; echo "<td><div align='center'><font size='3'><b>Vote <a href='108thfirst.php?sort_field=hr2passage.passage&sort_order=asc' target='_self'><font size='2'>Sort</a> </b></font></div></td>\n"; echo "<td><div align='center'><font size='3'><b>Vote <a href='108thfirst.php?sort_field=estatetaxrepeal.passage&sort_order=asc' target='_self'><font size='2'>Sort</a> </b></font></div></td>\n"; echo "<td><div align='center'><font size='3'><b>Vote <a href='108thfirst.php?sort_field=headstartvote444.vote&sort_order=asc' target='_self'><font size='2'>Sort</a> </b></font></div></td>\n"; echo "<td><div align='center'><font size='3'><b>Vote <a href='108thfirst.php?sort_field=hudappropsvote453.vote&sort_order=asc' target='_self'><font size='2'>Sort</a> </b></font></div></td>\n"; echo "<td><div align='center'><font size='3'><b>Vote <a href='108thfirst.php?sort_field=energyrollcall630.vote&sort_order=asc' target='_self'><font size='2'>Sort</a> </b></font></div></td>\n"; echo "<td><div align='center'><font size='3'><b>Vote <a href='108thfirst.php?sort_field=medicarerollcall669.vote&sort_order=asc' target='_self'><font size='2'>Sort</a> </b></font></div></td>\n"; echo "</tr>\n"; # write out each row while ($row = mysql_fetch_assoc ($data_set)) { echo "<tr>\n"; foreach (array_keys($row) as $item)