[PHP] php newbie having trouble going to detail page

2006-04-08 Thread David Doonan
I'm having trouble getting the correct results on a display page. The first query is pulling the name of active authors from the d/b and sending a request to only return essay titles by the requested author. The list page however is displaying essay titles by all authors. No doubt

Re: [PHP] php newbie having trouble going to detail page

2006-04-08 Thread John Hicks
David Doonan wrote: I'm having trouble getting the correct results on a display page. The first query is pulling the name of active authors from the d/b and sending a request to only return essay titles by the requested author. The list page however is displaying essay titles by all

Re: [PHP] php newbie having trouble going to detail page

2006-04-08 Thread David Doonan
On Apr 8, 2006, at 11:24 AM, John Hicks wrote: So your solution is this: Include a PHP variable in your SQL query to specify which author you want to select. You probably want something like this: WHERE Author.Author_Name = Writings.Author_Name AND Author.ID = '$MySelectedAuthorID' (but

Re: [PHP] php newbie having trouble going to detail page

2006-04-08 Thread John Hicks
David Doonan wrote: On Apr 8, 2006, at 11:24 AM, John Hicks wrote: So your solution is this: Include a PHP variable in your SQL query to specify which author you want to select. You probably want something like this: WHERE Author.Author_Name = Writings.Author_Name AND Author.ID =

Re: [PHP] php newbie having trouble going to detail page

2006-04-08 Thread David Doonan
On Apr 8, 2006, at 12:55 PM, John Hicks wrote: $recordID = $_GET['recordID']; Note that your request URL has a value for 'ID' whereas your program is looking for a value for 'recordID'. Changed above to: $recordID = $_GET['ID']; And all was right with the world. Thanks John! david --