I can't seem to get this working. Both sets of instruction given were very clear, and I'm convinced all is entered correctly.
The link is this:
<a href="eventInfo.php?id=<?php echo $row_calendar['event_id']; ?>">more . . .</a>
There is currently only one record, so the link directs correctly to the page with the query string in the URL ( eventInfo.php?id=1)
That (detail) page - eventInfo.php - has the recordset properly added, filtering by event_id (which is the unique auto-incrementing primary key) equal to 'URL', and populating the box next to it correctly with event_id. (Image: recordset.jpg)
When I press the 'Test' button (CS5) i get the message asking me to provide a test value for the URL Parameter: event_id. I enter the Test value 1 (the only record) and the test succeeds and shows me the correct data for that query. (Image: Test_SQL_Statement.jpg)
Howevr, when I click the 'more . . .' link from the home page, I get to a blank 'detail' page, with no record pulled from the database.
I hope someone may be able to throw some light on this.
P.S - I'm also getting an error message at the bottom of the page, if I use a template page with the 'Quick Links' include on the page:
Warning: mysql_free_result(): 17 is not a valid MySQL result resource in /home/users/uks45031/html/katelissauer.com/eventInfo.php on line 185.(I don't know what the '17' is about)
If I create a 'detail' page from a blank .php page, I don't get that error, but I still don't get a record returned.