[PHP-DB] PHP/Mysql Script help.

[Fulco of Scarborough]

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:

 

<?php

require("racesetup.php");

$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\"
action=\"http://st.fulco.net/races.php\";>

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

  <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>

    </select>

  </p>

  <p>

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

  </p>

</form>

";          

} else {

 

$result = mysql_query("SELECT * FROM nuke_race WHERE race LIKE
'$letter%'",$con);

    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"],
$myrow["race"]);

 

      } 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 <http://st.fulco.net/>  Legion

http://st.fulco.net <http://st.fulco.net/>  

[EMAIL PROTECTED]

 

Vincit imitationem veritas.