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%'");

if ($result_id) {

$nr_results = mysql_num_rows($result_id);

echo "<H3>Found $nr_results results on query for 'alcohol'</H3><P>";

if ($nr_results > 0) {

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 "<TR>";

echo "<TD>" . $result_set['orf_name'] . "</TD>";

echo "<TD>" . $result_set['gene_name'] . "</TD>";

echo "<TD>" . $result_set['brief_description'] . "</TD>";

echo "</TR>";

}

echo "</TABLE>";

}

} else {

echo "There is an error in your query.";

}

Example2_3.php

Two important functions to retrieve information from a MySQL database: