HELP PLEASE!!!!! PLEASE......ive been at this a long time
Posted: Wed Jan 14, 2004 11:30 am
I am have trouble with a simple task but cant figure out a way to solve the problem. I have a main page that lists my records. However, i also have other pages that query to that main page. Now i dont want to have to create a dozen other pages, i want everything to happen on that main page.
now the problem is when i add the OR.........the 'address' part might work, but the 'type' doesnt (it doesnt filter my information).......i dont know if u understand my problem. But what it boils down to is that i have numerous pages that when i click on a query (lets say, sort by name, or show me the records according to...... ) i want them ALL to go to my main page, i dont want to have to create a bunch of other pages
thank you in advance
Code: Select all
<?php
SELECT name, address, smalldescription, type, location, icons, smallpic, blackline
FROM listing
WHERE type = 'coltype' OR address LIKE '%coladdress%'
ORDER BY name ASC
?>thank you in advance