Displaying data from mysql - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

jpowell11 · 10-11-2009, 11:32 PM

Hi I need to create a php script that pulls data from my mysql database and shows it in a custom format. Ive been able to show everything but im trying to limit it since i have alot of data to display

I only have two columns, the unique id and the name
I want to have a page like link.php?letter=a
and show everything in 'name' beginning with 'a'
then be able to use the unique id in a link suchas a href=refer.php?id=?'unique id'

i am under the impression i need to use a loop to do this but ive been having little to no success, any help?

CS-Cart · 10-13-2009, 08:09 AM

what you need is LIKE

select columnname from table where columnname LIKE 'A%';

you use like instead of = to use a match. The % can represent any number of characters. You can also use * which represents a single character.