Help with fetching and returning PHP results from a MYSQL Database.

[alexsaidani]

I am attempting to develop a PHP search engine that fetches results from a MYSQL database, however i am struggling on getting the search engine to fetch results from the database, i'm not sure how you do that. If anyone could offer any help or code to help with this that would be great 🙂

Also i am developing another PHP search engine that when you type the name of a film it will fetch and return a random result from the database that is in the same category as the film typed in, i hope to get it to forward to another page with the result on that page. If anyone can offer any help or code with this too that would be most appreciated.

Thanks in advance 🙂

[djjjozsi]

Its really depends on how your table(s) look like. Do you have a well normalized table? How you store these categories?
What sort of form elements you want to use to filter the results.

[alexsaidani]

Well my column names are as follows: Name ID, Category ID, Rating ID, Names, Category, Rating and Description , my idea was for you to be able to enter a name or something relating to that name and for the script to look in the database for a film that has the same category number as that film typed in and fetch an random one. The thing is i dont understand how to implement the code in a script and i don't know how to retrieve a random result and show it. I have looked for help on the internet and stuff, but none of the tutorials show me the code for implementing this. Thanks for your reply.