Re: Stumped!
| From: | 1LT John W. Holmes | Date: | Mon, 16 Dec 2002 18:49:14 +0000 |
| Subject: | Re: Stumped! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-128449@lists.php.net to get a copy of this message | ||
> I am trying to display a column from my database as a list. Each listing
> needs to be a URL that links to another script that brings up all of the
data
> in the row to edit. I keep getting a parser error and I can't figure it
out.
> Here is the code and any help is greatly appreciated.
>
> <?php
> $db = mysql_connect("localhost", "Uname", "PW");
>
> $select_db = mysql_select_db("machmedi_meetingRequest",$db);
> $sql = "SELECT * FROM requests";
You're never executing your query, for one thing...
$res = mysql_query($sql) or die(mysql_error());
> while ($result = mysql_fetch_array($query)) {
> $id= $result["id"];
> $meetingName= $result["meetingName"];
>
> echo ("<a
> href=\"edit.php?id='$id'\">$meetingName</a><P>");
> ?>
---John Holmes...