Re: [PHP] Search function not working...

2008-02-01 Thread Jim Lucas
Jason Pruim wrote: So I said in another thread that I would be asking another question about functions... So here it goes, I am attempting to write a function to search the database, which used to work just fine when I wrote it without using a function (Would that be considered static?) Now tha

Re: [PHP] Search function not working...

2008-02-01 Thread David Giragosian
> > Jason, > > Untested, but try this... > > function search($searchvar, $table, $num_rows, $FName, $LName, $Add1, > $Add2) { >$qstring = "SELECT * FROM ".$table." WHERE FName like > '%$searchvar%' > or LName like '%$searchvar%' or Add1 like > '%$searchvar%' or Add2

Re: [PHP] Search function not working...

2008-02-01 Thread David Giragosian
On 2/1/08, Jason Pruim <[EMAIL PROTECTED]> wrote: > > On Feb 1, 2008, at 2:20 PM, David Giragosian wrote: > > On 2/1/08, Jason Pruim <[EMAIL PROTECTED]> wrote: > > > > [snip long explanation of problem] > > > function search($searchvar, $table, $num_rows, $FName, $LName, $Add1, > $Add2) { >

Re: [PHP] Search function not working...

2008-02-01 Thread Jason Pruim
On Feb 1, 2008, at 2:20 PM, David Giragosian wrote: On 2/1/08, Jason Pruim <[EMAIL PROTECTED]> wrote: [snip long explanation of problem] function search($searchvar, $table, $num_rows, $FName, $LName, $Add1, $Add2) { $qstring = "SELECT * FROM ".$table." WHERE FName like '% $searchvar

Re: [PHP] Search function not working...

2008-02-01 Thread David Giragosian
On 2/1/08, Jason Pruim <[EMAIL PROTECTED]> wrote: > > So I said in another thread that I would be asking another question > about functions... So here it goes, I am attempting to write a > function to search the database, which used to work just fine when I > wrote it without using a function (Woul

Re: [PHP] Search function

2007-05-09 Thread Chris
Ryan A wrote: Hey! .A little background: We have a site that has already been made.. a couple of hundred pages displayed via SMARTY templates, the site's in Swedish. The navigation and other parts except for the center is taken care of by the templates and other scripts... the center main

Re: [PHP] Search function

2007-05-09 Thread Richard Lynch
On Wed, May 9, 2007 7:34 am, Ryan A wrote: > Now they want to add a "search function" to the site... a simpe > textbox where a user enters a word or sentance and they get 20 results > per page... with a "x.xx % closest to your query" can anybody give me > basic pointers on where to start? > Any li