Getting useful information.
Two important functions to retrieve information from a MySQL database:
- result_id = mysql_query(query_string [, link_id])
- result_set = mysql_fetch_array(result_id [, result _type])
if (!mysql_select_db("yeast_genome_v1_0"))
die ("Could not open yeast_genome db, reason: " . mysql_error());
$result_id = mysql_query("SELECT orf_name, gene_name, brief_description
FROM mips WHERE brief_description LIKE '%alcohol%'");
$nr_results = mysql_num_rows($result_id);
echo "<H3>Found $nr_results results on query for 'alcohol'</H3><P>";
echo "<TABLE WIDTH=100%><TR><TD><B>ORF NAME</B></TD>";
echo "<TD><B>GENE NAME</B></TD><TD><B>BRIEF DESCRIPTION</B></TD></TR>";
while ($result_set = mysql_fetch_array($result_id)) {
echo "<TD>" . $result_set['orf_name'] . "</TD>";
echo "<TD>" . $result_set['gene_name'] . "</TD>";
echo "<TD>" . $result_set['brief_description'] . "</TD>";
echo "There is an error in your query.";