[Resolved] Need help passing URL parameters *TOTAL NEWBIE QUESTION*

[Rodney_H_]

On my items list page, I use the following code::::::::::::::::::::::::

<?php [...snip...]

$str_requete = "SELECT id,title,author FROM Article WHERE display='yes' ORDER BY date DESC";

$result_articles = mysql_query ($str_requete,$ezine_db) or ezine_mysql_die();

print ('<table>');

while ($articleDb =mysql_fetch_object($result_articles))
{
     print("
           <tr>
             <td>$articleDb->id</td>
             <td>$articleDb->title</td>
			 <td> <I>par  $articleDb->author</I></td>
             <td><a href='detail.php?id=$articleDb->id'>Read the poem</a></td>
           </tr>
          ");
}

print ('</table>');

?>

This works fine:::::::::::::::::::::::::::

QUESTION:

How can I retrive just ONE record on my details page rather than showing the details for ALL of the records in the DB.

What do I do to modify this line:

"

$str_requete = "SELECT id,title,author FROM Article WHERE display='yes' ORDER BY date DESC";

"

How can I modify the above script to show the specific article by the ID number that is passed in the URL
???

THANKS A MILLION.

[m_tt]

Hi Rodney,

I think I got the jist of what you are trying to do...

To pull only from a specific ID # from a URL you would do something like this:

$str_requete = "SELECT id,title,author FROM Article WHERE display='yes' WHERE id='" . $_GET['id'] . "'";

or to just limit the number of results you do something like this:

$str_requete = "SELECT id,title,author FROM Article WHERE display='yes' ORDER BY date DESC LIMIT 1";

This will only return the newest result ordered by date.

[Rodney_H_]

M@tt:

You were right. You did catch the jist of it. The code snippet you suggested works:

" WHERE id='" . $_GET['id'] . "'"; "

Thanks a million!

-Rodney H.

🙂

[m_tt]

Cool.

Also since you are pulling the ID # from the URL, it would be wise to make a basic check for a real ID in case someone decides to modify your URL.

Something like this

WHERE id='" . (isset($GET['id']) ? $GET['id'] : 1) . "'

Basically the format is (function ? true_result : false_result). It will default the ID to 1 if there isn't an ID present in the URL

You could also add an is_int function in there. Get creative.

🙂

[Rodney_H_]

Thanks a million that is a great idea. I have so much to learn but building these page with PHP is so much better than creating and updating a page for every single item!!!!

-Rodney H.