Hello everyone,
    I am brand new to php, so any replies I get are very much appreciated.
My goal is to retrieve one entire table from my database and post the
information on the web.  My query seems successful, but I am having trouble
getting the information out from the variable $result.  My table has 4
fields, the primary key, "location," "organization," and "charge."   Any
suggestions?   A million thanks.  Here is the code:

   /* Connectiong*/
@ $db = mysql_connect("localhost", "NAME","PASS");

   if (!$db)
      echo "Error, please try again.";
/* Selecting database*/
$db2 = mysql_select_db ("DATABASE");
if (!$db2)
  echo "error again";
     /*sending query */
        $query = "select * from `$mytable` where $i";
        $result = mysql_query($query);

        /*testing to see if result has the data */
        if (!$result){echo "result is empty";}

for ($a=0;$a<4;$a++)
          $row = mysql_fetch_array($result);
        echo $row[i]["organization"]."<br>";
        echo $row[i["location"]."<br>";
         echo $row[i]["charge"];


-- Jonathan

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to