Re: PHP/Mysql Script help.

[Becoming Digital <subs@becomingdigital.com>]

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