Querying The Database
Moderator: General Moderators
Querying The Database
Help Anybody
I'm designing a database(db) driven webpage using PHP and MYSQL. The webpage has 5 frames, and from the headerFrame I'm wanting to run a query from a table in the db and have the results appear in the mainFrame. eg Search by Artist Name, Song Title or Album, and have results appear below the search options in mainFrame. How would I script this using PHP and MYSQL 
Search Near/Like Function
When querying the database for near results what is the function for this, eg: when querying the database for an exact phone number I would use:
but I would like to be able to query the database for phone numbers that are like the numbers entered on the website form.. eg entered phone number: 12345, and in database would be 12346, 12345, 23456, 23487. so I would want the phone numbers that are like the entered number displayed on the website form.. Appreciate the feedback..
Code: Select all
$query="SELECT * FROM requestee WHERE phone ='$phone'";