[RESOLVED] List contents of MySQL database.

[noahssite]

Hello i have a mySQL database and in the database there is a table called products. Here is the order of columns in products:

"Title","Description","Seller","Picture","Qaulity","Price","Country","Province","City","School","Cam pus","Grade","Room"

I want the user to be able to search for the title and then all the rows found with the title the user specified will be displayed to the user in a table. When it gets to the Picture column i want it displayed in img tags. As well i need the table to display the information it gets in a different order. The picture will be the last column of the table etc..

When the user searches for the title it doesn't need to be an exact match for example:

Title = Book1
Search can be = Book

[dclamp]

Use the wildcard character %. The code below will search for anything with 'Book' in the title. (Example: 'Book of Music', 'Cook Book' and 'Dog Books')

SELECT FROM 'mytable' WHERE Title='%Book%'

I am assuming you already know how to use mysql functions in php. If not, check out the tutorial in my signature.

[noahssite]

I didn't have time yesterday to reply but i solved it on my own anyway. I didn't use wildcards instead i just added in an additional if statement containing: stristr() function. As well i used a While loop and SELECT FROM products WHERE Title=... to create a table.

[kows]

that is a seriously bad way to filter results when dealing with a database. it might seem fast and efficient with a small table, but when you have hundreds or thousands of records you will notice how slow it is.

now, to use wild cards correctly, you need to use the LIKE operator (rather than "="). this will also always be a case insensitive search. you can build your SQL statement like so:

SELECT * FROM table WHERE title LIKE '%book%'

hope that helps.

[noahssite]

Thank you i will probally replace my old means of filtering with that.