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

[PHP] Search function not working...

2008-02-01 Thread Jason Pruim
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 that I am attempti

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

[PHP] Search function

2007-05-09 Thread Ryan A
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 text is taken f

[PHP] PHP search function for MySQL db

2002-08-22 Thread Kristoffer Strom
I've set up a mysql db to store all news updates at our site and I'm thinking about setting up a search function so our visitors can search the news db after specifics words or strings. Is there somewhere some nice place that have posted a "change-some-variables-then-its-ready-to-go" PHP file some