Jump to content


Photo

dont include in where statement


  • Please log in to reply
1 reply to this topic

#1 CanMan2004

CanMan2004
  • Members
  • PipPipPip
  • Advanced Member
  • 254 posts

Posted 24 September 2006 - 11:53 PM

hi

is there a way to tell a query not to include a particluar value, so if you were doing days of the week and you didnt want mondays to be shown, you could put that into the statement?

thanks in advance

Dave

#2 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,021 posts

Posted 25 September 2006 - 12:29 AM

... WHERE dayOfWeek <> 'Monday'
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users