Try to insert all your received data from the database server data into an array then to execute your query after the unique id(if you have one!!!). $sql=select * from table where id='$id'; then all the data you put into an array and select the index from the array. Check the list html tag for more options/* that you need and put on to your page... */ --- http://cristophus.cjb.net --- Why static, when you can go dynamic?
On Mon, 16 Dec 2002, Omar wrote: > Check out your while > { > } <--- i don´t see a closing one > > echo ("<A HREF="/"edit.php?id='$id'\"">$meetingName</A> "); > try: > echo '<A href="edit.php?id='.$id.'">'.$meetingName.'</A>'; > > > <[EMAIL PROTECTED]> escribió en el mensaje > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hmm, I am still getting a parse error on the last line of code... > > > In a message dated 12/16/2002 1:49:26 PM Eastern Standard Time, > [EMAIL PROTECTED] writes: > > > $sql = "SELECT ....."; > > $sql_e = mysql_query($sql); > > > > while ($result = mysql_fetch_array($query_e)) { > > ..... > > } > > > > You were missing the mysql_query > > > > > > <[EMAIL PROTECTED]> escribió en el mensaje > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > >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"; > > > > > >while ($result = mysql_fetch_array($query)) { > > >$id= $result["id"]; > > >$meetingName= $result["meetingName"]; > > > > > >echo ("<A HREF="/"edit.php?id='$id'\"">$meetingName</A> "); > > >?> > > > > > > > > > > Christopher Parker > Senior Corporate Technical Specialist, Corporate Events > America Online Inc. > Phone: 703.265.5553 > Fax: 703.265.2007 > Cell: 703.593.3199 > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php