Greeting everyone, my name is Jason and I am sorry for bugging you since you
probably get a ton of these emails, but I was hoping you all might be able
to help me.  I am attempting to design a script that presents the user with
a form with 26 letters to choose from.  When they pick a letter I want it to
take them to a list of all the entries in my database that begin with the
letter they selected in link form.  When they click on the term, I want it
to pull up the info for that entry.

I am only wanting to get some tips or a sample somewhere you may know of to
get me going in the right direction.


Here is my current code so far:




$con = mysql_connect($host, $user, $pass);


mysql_select_db($db, $con);


// display individual record


if ($id) {


   $result = mysql_query("SELECT * FROM nuke_race WHERE id=$id",$con);


   $myrow = mysql_fetch_array($result);


   printf("<b>Race:</b> %s\n<br>", $myrow["race"]);

      echo "<br>";           

   printf("<b>Description:</b> %s\n<br>", $myrow["racetxt"]);

      echo "<br>";

      echo "<br><h3><a href=\"javascript:history.go(-1)\">Back</a></h3>";


} else {

      echo "<form name=letter method=\"post\"

  <p>Pick a letter to begin your search</p>


    <select name=\"select\">

      <option value=\"a\">A</option>

      <option value=\"b\">B</option>

      <option value=\"c\">C</option>

      <option value=\"d\">D</option>

      <option value=\"e\">E</option>

      <option value=\"f\">F</option>

      <option value=\"g\">G</option>

      <option value=\"h\">H</option>

      <option value=\"i\">I</option>

      <option value=\"j\">J</option>

      <option value=\"k\">K</option>

      <option value=\"L\">L</option>

      <option value=\"m\">M</option>

      <option value=\"n\">N</option>

      <option value=\"o\">O</option>

      <option value=\"p\">P</option>

      <option value=\"q\">Q</option>

      <option value=\"r\">R</option>

      <option value=\"s\">S</option>

      <option value=\"t\">T</option>

      <option value=\"u\">U</option>

      <option value=\"v\">V</option>

      <option value=\"w\">W</option>

      <option value=\"x\">X</option>

      <option value=\"y\">Y</option>

      <option value=\"z\">Z</option>




    <input type=\"Submit\" name=\"letter\" value=\"Enter information\">




} else {


$result = mysql_query("SELECT * FROM nuke_race WHERE race LIKE

    if ($myrow = mysql_fetch_array($result)) {


      // display list if there are records to display


      do {


        printf("<a href=\"%s?id=%s\">%s</a><br>\n", $PHP_SELF, $myrow["id"],


      } while ($myrow = mysql_fetch_array($result));


    } else {


      // no records to display


      echo "Sorry, no records were found!";        






Thanks for your help in advance.


Yours in Service,

Jason Britton

Scar's <>  Legion <>  



Vincit imitationem veritas.


Reply via email to