MySQL Command

freeflow · 07-06-2009, 03:31 AM

Can you help me change this command?

$query = "SELECT Link FROM Web ORDER BY `Web`.`Link` DESC ";

How do I add:

WHERE Category NOT LIKE archive OR broken

sdsinc · 07-06-2009, 04:06 AM

Like this perhaps

Code:

SELECT Link FROM Web 
WHERE Category NOT IN ('archive', 'broken')
ORDER BY `Web`.`Link` DESC

freeflow · 07-07-2009, 01:45 AM

It works! Thanks

07-06-2009, 03:31 AM	THREAD STARTER #1 (permalink)
freeflow NamePros Regular Join Date: Dec 2006 Posts: 236	MySQL Command Can you help me change this command? $query = "SELECT Link FROM Web ORDER BY `Web`.`Link` DESC "; How do I add: WHERE Category NOT LIKE archive OR broken

07-06-2009, 04:06 AM	#2 (permalink)
sdsinc Domains my Dominion Join Date: Aug 2005 Location: Web 1.0 Posts: 9,963	Like this perhaps Code: SELECT Link FROM Web WHERE Category NOT IN ('archive', 'broken') ORDER BY `Web`.`Link` DESC __________________ NameNewsletter.com - free lists of available domain names ZoneFiles.net (beta) - ccTLD and gTLD droplists

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
bin/bash using 50% cpu usage, all the time!	BillyConnite	Web Hosting Discussion	6	09-16-2006 05:06 AM
Cpanel downgrade MYSQL 4.1.X to MySQL 4.0.xx	Webhosting-live.com	Web Hosting Discussion	3	09-01-2006 05:12 PM
Great Scripts for Sale With Resale Rights!	Zeeble	Scripts For Sale	20	01-04-2006 01:39 AM
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 09:46 PM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 01:17 PM

07-07-2009, 01:45 AM	THREAD STARTER #3 (permalink)
freeflow NamePros Regular Join Date: Dec 2006 Posts: 236	It works! Thanks

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)