Re: [PHP] PhP/MySQL Search Results code

2003-10-27 Thread Curt Zirzow
* Thus wrote Robb Kerr ([EMAIL PROTECTED]): > > I'm always getting an error when testing the page. The error is... > > Parse error: parse error, expecting `T_VARIABLE' or `'$'' in > /home/s/k/user992816/html/RobesonWeb/TMP4np9nf7zp.php on line 4 > > The line to which it refers is the line statin

Re: [PHP] PhP/MySQL Search Results code

2003-10-27 Thread Robb Kerr
That was it! Thanx for the help. This board has proven invaluable to me. Robb -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] PhP/MySQL Search Results code

2003-10-27 Thread Marek Kilimajer
The line should be $vManufacturer_rs_RobesonResultsList = (get_magic_quotes_gpc()) ? $manufacturer : addslashes($manufacturer); Robb Kerr wrote: Newbie question - please excuse. I'm using Dreamweaver to generate most of my PhP. I have created a search page and am trying to generate the results pa

RE: [PHP] PhP/MySQL Search Results code

2003-10-27 Thread Jay Blanchard
[snip] if (isset(manufacturer)) { $vManufacturer_rs_RobesonResultsList = (get_magic_quotes_gpc()) ? manufacturer : addslashes(manufacturer); } Parse error: parse error, expecting `T_VARIABLE' or `'$'' in /home/s/k/user992816/html/RobesonWeb/TMP4np9nf7zp.php on line 4 [/snip] Looks like 'manufac

Re: [PHP] PHP/MySQL Search Engine Query Question

2002-07-28 Thread Tech Support
Here is an idea using this method "car" would match "car", "carwash", "scar", "scarred", etc. Since this result will contain the entire boy of text you could some more matching or scoring for relevancy I had that code from a previous working project. I copied it and changed some var names to

RE: [PHP] PHP/MySQL Search Engine Query Question

2002-07-27 Thread Naintara Jain
You can use explode/split functions on the search parameters - that will give u an array with each search token indexed individually. Suppose the search input was 'abc xyz' $strsearch = "abc xyz"; $search=explode(" ",$strsearch); your array "search" will contain $search[0]=abc $search[1]=xyz

Re: [PHP] PHP & MySQL Search Results

2001-04-14 Thread Jason Caldwell
Hi Jason, Say you have a search form that says search for "searchbox" and the search box has a variable name of "search": NO Valid search results. "> 1) { echo "Previous"; } if (($num > 25) && (($limit + 25) < $num)) { echo "Next."; } /* End the initial "Else" */ } ?> ___

Re: [PHP] PHP & MySQL Search Results

2001-04-14 Thread Plutarck
In a MySQL query you can use the LIMIT keyword, like in phpmyadmin. Use limit 0,10 to get the first ten results in a query. Then do the query again but use 10,10 for the limit. The first number is the "offset", and the second one is the maximum results to return. That's the way most people do

Re: [PHP] PHP | MySQL Search

2001-03-13 Thread David Bouw
Hi there.. Try: SELECT HouseID FROM Search WHERE (CountryID='2' AND PriceID='3' OR (FacilityID='1' OR FacilityID='5')) The extra brackets are only to make it easier to read.. (For me it is..) What you basically asked where all records in which CountryID is 2 and PriceID is 3 AND (only) where t

Re: [PHP] PHP+MySQL SEARCH

2001-02-19 Thread Richard Lynch
> if ($search_in == "1"){ >$query1 = "SELECT * FROM FISH where ID LIKE '%$search_text%' > OR name LIKE '%$search_text%' OR Category LIKE '%$search_text%' OR Color > LIKE '%$search_text%' OR Size LIKE '%$search_text%'"; > } Looks good the way it is for now. Things you *could* do: 1) Break up