Re: [PHP] Basic SQL syntax

2001-01-15 Thread James, Yz
> > Ah, so you can constantiate (right word?) the query? > > I don't know what you mean by 'constantiate', but glad to hear it worked It did, thank you ;) Someone pointed out where I'd gone wrong with the word privately: >> Ah, so you can constantiate (right word?) the query? > concatenate :)

Re: [PHP] Basic SQL syntax

2001-01-15 Thread Johannes Janson
> Ah, so you can constantiate (right word?) the query? I don't know what you mean by 'constantiate', but glad to hear it worked otis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the

Re: [PHP] Basic SQL syntax

2001-01-15 Thread James, Yz
""Johannes Janson"" <[EMAIL PROTECTED]> wrote in message 93vs9u$osj$[EMAIL PROTECTED]">news:93vs9u$osj$[EMAIL PROTECTED]... > try this: > $sql = "SELECT * FROM table > WHERE town LIKE '%$search_data%' "; > > if ($reference != "") > $sql .= "OR whatever"; Ah, so you can constantiate (right w

Re: [PHP] Basic SQL syntax

2001-01-15 Thread Johannes Janson
try this: $sql = "SELECT * FROM table WHERE town LIKE '%$search_data%' "; if ($reference != "") $sql .= "OR whatever"; ""James, Yz"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag 93vs2p$cng$[EMAIL PROTECTED]">news:93vs2p$cng$[EMAIL PROTECTED]... > OK, I got a simple search page working (thanks

[PHP] Basic SQL syntax

2001-01-15 Thread James, Yz
OK, I got a simple search page working (thanks to all of you who helped me). Another simple question for you. If I had a search and the data to be searched needs to be determined by check boxes, How would I write the sql>? Like this? $sql = "SELECT * FROM table WHERE town LIKE '%$search_data