ColdEdge Posted March 20, 2009 Share Posted March 20, 2009 Ok, I have a question how can I make a PHP based search?That search's the MySQL Database and then shows all results in a row, max 10 per page.So if they search for say "Full" the search result will come out with any thing in MySQL that starts with that so the output will beFullmetal Alchimist-Short DescriptionFull Metal Panic-Short DescriptionFull Metal Panic: Fumostsu-Short DescriptionFull Metal Panic: The 2nd Raid-Short DescriptionI need help making this script and MySQL tables also a way that I can add all of this into to MySQL... Link to comment Share on other sites More sharing options...
jlhaslip Posted March 20, 2009 Share Posted March 20, 2009 Use a SELECT query that includes a LIKE filter. Link to comment Share on other sites More sharing options...
ColdEdge Posted March 20, 2009 Author Share Posted March 20, 2009 So this?SELECT * FROM a WHERE id LIKE 'a%' ????But I dont get how that will display 10 results per page if any and display some description about the contence.... that is why I need help making the search.php form ^^ Link to comment Share on other sites More sharing options...
roondog Posted March 20, 2009 Share Posted March 20, 2009 You'll need to look into pagination. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.