Thanks for all you wonderful help. With a little tweaking, and a new debugging program, I have been able to get the results I want. Now I'm going to begin adding some security features. Again, thanks for you help. Yours in Service, Jason Britton Scar's Legion http://st.fulco.net scar@st.fulco.net Vincit imitationem veritas. > -----Original Message----- > From: Becoming Digital [mailto:subs@becomingdigital.com] > Sent: Thursday, June 05, 2003 4:59 AM > To: 'PHP-DB' > Subject: Re: PHP/Mysql Script help. > > I debugged the code and there were a slew of errors. I've fixed all but one, > which I can't correct bcs I don't know the intention. Most of the errors came > from improper syntax, a problem which could have been avoided by using > consistent code formatting. I chose to do that for you as well and have > included the code below. > > As for the error I could not correct, it involves the final elseif() statement. > The way your code was written, you had two 'else' statements, which is an > obvious violation. I corrected that by changing the first (before the select > statement) to an elseif(), but I do not know the condition. Once you enter it, > the code should work smoothly. > > > <?php > > require("racesetup.php"); > > $con = mysql_connect($host, $user, $pass) or die(mysql_error()); > > mysql_select_db($db, $con) or die(mysql_error()); > > // display individual record > if ($id) > { > error_reporting(E_ALL); > > $result = mysql_query("SELECT * FROM nuke_race WHERE id=$id",$con) or > die(mysql_error()); > > $myrow = mysql_fetch_array($result) or die(mysql_error()); > > 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>"; > } > > elseif ($_Post['letter']) > { > if ($_Post['letter']) > { > $result = mysql_query("SELECT * FROM nuke_race WHERE race LIKE > $_Post['letter']%",$con) or die(mysql_error()); > 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)); > } > } > } > > //NO CONDITION LISTED!! > elseif () > { > echo "<form name=\"letter\" method=\"post\" action=\"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=\"submit\" value=\"Enter > information\">" > . " </p>" > . "</form>" > .""; > } > > else > // no records to display > echo "Sorry, no records were found!"; > > ?> > > > Edward Dudlik > Becoming Digital > www.becomingdigital.com > > > ----- Original Message ----- > From: "Fulco of Scarborough" <fulco@fulco.net> > To: "'PHP-DB'" <php-db@lists.php.net> > Sent: Thursday, 05 June, 2003 00:25 > Subject: Re: PHP/Mysql Script help. > > > I have still been getting errors, so here goes again. > > > > 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 have made some changes and added some error checking: > > > > <?php > > > > require("racesetup.php"); > > $con = mysql_connect($host, $user, $pass) or die(mysql_error()); > > > > mysql_select_db($db, $con) or die(mysql_error()); > > > > // display individual record > > > > if ($id) { > > error_reporting(E_ALL); > > $result = mysql_query("SELECT * FROM nuke_race WHERE id=$id",$con) or > die(mysql_error()); > > > > $myrow = mysql_fetch_array($result) or die(mysql_error()); > > > > 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>"; > > > > > } elseif ($_Post['letter']) { > > if ($_Post['letter']) { > > $result = mysql_query("SELECT * FROM nuke_race WHERE race LIKE > $_Post['letter']%",$con) or die(mysql_error()); > > 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 { > > echo"<form name=\"letter\" method=\"post\" action=\"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=\"submit\" value=\"Enter > information\">" > > . " </p>" > > . "</form>" > > . " > > .""; > > > > } > > else { > > // no records to display > > > > echo "Sorry, no records were found!"; > > } > > > > ?> > > > > I am still getting "Parse error: parse error, unexpected T_STRING in > /home/wwwfulc/public_html/st/races.php on line 38" > > > > This is line 38 > > > > echo"<form name=\"letter\" method=\"post\" action=\"races.php\">" > > > > > > Thanks for your help! > > > > Yours in Service, > > Jason Britton > > Scar's <http://st.fulco.net/> Legion > > scar@st.fulco.net > > > > Vincit imitationem veritas. > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
