Can I force it to display the data sorted by the primary key? Here's the code: // store table names in an array $arr_tablenames[] = ''; // store number of fields per table(index 0,1,2..) in an array $arr_num_fields[] = ''; for ($i=0; $i < $num_tables; $i++) { $arr_tablenames[$i] = mysql_tablename($tables, $i); $arr_num_fields[$i] = mysql_num_fields(mysql_db_query($dbname, "select * from $arr_tablenames[$i]", $id_link)); } // store field names in a multidimensional array: // [i] == table number, [ii] == field number for that table for ($i=0; $i < $num_tables; $i++) { for ($ii=0; $ii < $arr_num_fields[$i]; $ii++) { $result = mysql_db_query($dbname, "select * from $arr_tablenames[$i]", $id_link); $hash_field_names[$i][$ii] = mysql_field_name($result, $ii);
} } for ($i=0; $i < $num_tables; $i++) { echo("<center><h3> $arr_tablenames[$i] </h3></center>"); echo('<table align="center" border="1"><tr>'); $result = mysql_db_query($dbname, "select * from $arr_tablenames[$i]", $id_link); for ($ii=0; $ii < $arr_num_fields[$i]; $ii++) { echo("<th>"); echo $hash_field_names[$i][$ii]; echo("</th>"); } echo("</tr><tr>"); $number_of_rows = @mysql_num_rows($result); for ($iii = 0; $iii < $number_of_rows; $iii++) { $record = @mysql_fetch_row($result); for ($ii=0; $ii < $arr_num_fields[$i]; $ii++) { echo("<td>"); echo $record[$ii]; echo("</td>"); } echo("</tr>"); } echo("</table>"); } Is that too much to sort through??? -----Original Message----- From: Tony S. Wu [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 7:31 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Changing colors in table? If the table's background color will be set when the page is first loaded, you can just use the bgcolor attribute of <td> tag. If you want to dynamically change the background color, you'll need to combine your page with javascript. Tony S. Wu [EMAIL PROTECTED] "Nope, this world ain't perfect. But at least I know it's not because of me." Blue Tiger at [EMAIL PROTECTED] wrote: > Okay..... > Disclaimer: I am very much the newbie, so please bear with me. > > I have a piece of code that displays an array from a MySQL table. One > field in the table is blank (and is displayed as an empty column of > cells) at the moment. I want to have the blank cells display an image, > value, or change its background color based on whether the numerical > values in the previous 4 fields meet certain criteria or not. Make > sense? Maybe? > > An example of what I want to show: > If table 2 has a value that is less than 5, then the last cell displayed > changes color to reflect that. > If table 2 has a value that is between 5 and 10, then the last cell > displayed changes color to reflect that as well. > > Please help if you can....many thanks in advance. (I can show my code > thus far as well if that helps..) > > Thanks, > Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php