https://www.webmaster-forums.net/crss/node/1038977 en https://www.webmaster-forums.net/serverside-scripting/business-directory-using-asp#comment-1221610 <p>Yeah, that would probably work, but not knowing your structure it's hard to say. And why ask us? Why not try it, debug it, and if you still can't figure it out THEN ask? That's pretty much the point of this site...</p> <p>Something you might want to also look at (since I know nothing about your database) is the LIKE attribute. It's similar to WHERE except that it allows for variables, so you might do something like...<br /> <div class="codeblock"><code><span style="color: #000000"><span style="color: #0000BB">&lt;?php<br />SELECT id</span><span style="color: #007700">, </span><span style="color: #0000BB">boat</span><span style="color: #007700">, </span><span style="color: #0000BB">dungeon FROM castle_frankenstein WHERE boat LIKE </span><span style="color: #DD0000">'%$needle%' </span><span style="color: #0000BB">ORDER BY id DESC<br />?&gt;</span></span></code></div><br /> So in that example, it would get the fields 'id', 'boat', and 'dungeon' from the table 'castle_frankenstein', and return results that have the contents of the $needle variable inside the 'boat' field... all in descending order based on the id value.</p> <p>Also, in your question, you say "WHERE Cat1 = Automotive" ... make sure you're using quotes after the equal sign.</p> Fri, 13 Jul 2007 19:25:48 +0000 brady.k comment 1221610 at https://www.webmaster-forums.net