Re: [PHP] Record ID not being recognized

2006-05-09 Thread David Doonan
On May 9, 2006, at 3:27 PM, Wolf wrote: $recordcatID = $_GET[ID]; //place before the query Grazi! da

[PHP] Record ID not being recognized

2006-05-09 Thread David Doonan
While I am by no strech of the imagination a ColdFusion expert, I have built a couple of dozen CF sites over the past 5 years. Am currently working on my first PHP site and am running into a problem with the simplest little thing. An index page is returning a list of active category names.

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 -- P

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 reme

[PHP] php newbie having trouble going to list page

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

[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 something

Re: [PHP] newbie question

2006-04-05 Thread David Doonan
On Apr 5, 2006, at 11:51 AM, Evan Priestley wrote: On Apr 5, 2006, at 11:41 AM, Jay Blanchard wrote: ^ Not sure if this is just a transcription error, but that should be an 'l' (ell), not a '1' (one) in "nl2br". Evan Grazi! Exactly what I'm looking for! a very grate

Re: [PHP] newbie question

2006-04-05 Thread David Doonan
Writings_Text is the field in the d/b that contains the text I'm trying to return. I've done a couple of dozen ColdFusion sites and would format like this: #ParagraphFormat(Writings_Text)# and the results would be retuned exactly as stored in the d/b. What I'm searching for is the php equileva

[PHP] newbie question

2006-04-05 Thread David Doonan
I'm developing my first php mysql site and have hit a stumbling block regarding how text is being returned out of the database. This is the code that I'm using on the display page. It is displaying the returned text as one long paragraph, instead of mulitiple paragraphs: --- Th