Search found 2 matches

by satcom
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...
by satcom
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...