NathanS Posted February 15, 2008 Share Posted February 15, 2008 Hi guys, I've setup a control panel at work - put simply, it's a way of people being able to view records retrieved from a MySQL database. Currently, they input the ID number into a box and hit "Go" as that's the only way I can think of to pull through the ID number to the next page, so I can do a "SELECT * FROM database WHERE id = $_POST['id'];" Any way I can make the ID's linkable, so they just click on them and it pulls through that ID number that I can use in the select statement? Thanks in advance! Quote Link to comment Share on other sites More sharing options...
Michan Posted February 15, 2008 Share Posted February 15, 2008 Yes, use $_GET instead of $_POST. You can output a number of results spanned over several pages, and have each result a clickable link. Make the link for each record yourfile.php?id=x (where x = the ID#). In the ID page, you can then use $_GET['id'] instead of $_POST['id']. Quote Link to comment Share on other sites More sharing options...
NathanS Posted February 15, 2008 Author Share Posted February 15, 2008 You just made my day! Thankyou very much! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.