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" <[EMAIL PROTECTED]>
To: "'PHP-DB'" <[EMAIL PROTECTED]>
Sent: Thursday, 05 June, 2003 00:25
Subject: Re: [PHP-DB] 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
[EMAIL PROTECTED]
Vincit imitationem veritas.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
