On Saturday 22 June 2002 06:27, Jonathan wrote:
> 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.
Saying exactly what the trouble is would help!
> My table has 4
> fields, the primary key, "location," "organization," and "charge." Any
> suggestions? A million thanks. Here is the code:
>
> <html>
> <body>
> <?
> /* Connectiong*/
> @ $db = mysql_connect("localhost", "NAME","PASS");
>
> if (!$db)
> {
> echo "Error, please try again.";
> exit;
> }
> /* Selecting database*/
> $db2 = mysql_select_db ("DATABASE");
> if (!$db2)
> {
> echo "error again";
> exit;
> }
> /*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++)
> {
> for($i=0;$i<4;$i++)
> {
> $row = mysql_fetch_array($result);
> echo $row[i]["organization"]."<br>";
> echo $row[i["location"]."<br>";
> echo $row[i]["charge"];
> }
> }
The standard way to retrieve results from a query would be:
while ($row = mysql_fetch_array($result)) {
echo $row['organization'];
...
...
}
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
"What did you do when the ship sank?"
"I grabbed a cake of soap and washed myself ashore."
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
