Search found 2 matches
- Sun Feb 03, 2008 5:06 pm
- Forum: Databases
- Topic: Help with MySQL Select statement in PHP code
- Replies: 3
- Views: 347
Re: Help with MySQL Select statement in PHP code
It is an array. I'm wanting to exclude certain results from the query. This is what I was thinking I just don't know how to write it. $query="SELECT * FROM #__alberghi_facilities WHERE id IN (".$item->facilities.") and id isnot '8' "; I know that is written incorrectly. Also ther...
- Sun Feb 03, 2008 3:22 pm
- Forum: Databases
- Topic: Help with MySQL Select statement in PHP code
- Replies: 3
- Views: 347
Help with MySQL Select statement in PHP code
I've got the following SQL statement that I'm wanting to customize for a website I'm working on. $query="SELECT * FROM #__alberghi_facilities WHERE id IN (".$item->facilities.")"; Basically, I'm wanting to not include certain id's in the query. For example, lets say that $item->f...