require("connectDB.cnf"); ?> // $show = 1 to show only the most recent data; $show = 2 to show also older data // Check also $show value in genome_list.php $show = 1; $genome_list_db = "genomes"; $user_db = 'user_submitted'; $query1 = "select * from " . $genome_list_db . " where no_show < " . $show . " order by species asc, date asc"; $result1 = mysql_query($query1) or die ("Invalid query: " . mysql_error()); $num = mysql_num_rows($result1); $glist = array(); for ($i=0; $i <$num; $i++){ $row = mysql_fetch_array($result1); $glist[$row["species"]]= $row["db_name"]; //echo "I am here"; //exit; } mysql_close(); ?>
| ||||||||||||||||||||||||||||||||||||||||||||