scott botkins Posted June 10, 2007 Share Posted June 10, 2007 I have a client who has a sql file which will be imported using phpmyadmin. Basically what they are wanting is to have a search form where they enter the id number is will show the information for that id. What would be the best way to do this? Quote Link to comment https://forums.phpfreaks.com/topic/55014-best-way-to-search-a-sql-file/ Share on other sites More sharing options...
AndyB Posted June 10, 2007 Share Posted June 10, 2007 pass the id value from the search form to another script that does this: makes a database connection selects the (right) database executes an SQL query like SELECT * from table_name WHERE id = '$id' retrieve the SQL result array display the array values if any Quote Link to comment https://forums.phpfreaks.com/topic/55014-best-way-to-search-a-sql-file/#findComment-271962 Share on other sites More sharing options...
scott botkins Posted June 10, 2007 Author Share Posted June 10, 2007 Yea that's what I'm wanting to do where it it will be search.php?id=1 and then on search.php it's showing the id (1) results from that database. I'm kind of new at this mysql stuff, do you know where I could find a good tutorial for this? Quote Link to comment https://forums.phpfreaks.com/topic/55014-best-way-to-search-a-sql-file/#findComment-271967 Share on other sites More sharing options...
AndyB Posted June 10, 2007 Share Posted June 10, 2007 http://www.tizag.com/mysqlTutorial/index.php Quote Link to comment https://forums.phpfreaks.com/topic/55014-best-way-to-search-a-sql-file/#findComment-271981 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.