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

[PHP] PhP/MySQL Search Results code

2003-10-27 Thread Robb Kerr
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 page. The search form is using the GET function and the form field name is "manufacturer". The following code is generated by DW in the results page.

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

2002-07-28 Thread Tech Support
; <[EMAIL PROTECTED]> To: "PHP PHP" <[EMAIL PROTECTED]> Sent: Saturday, July 27, 2002 9:31 PM Subject: [PHP] PHP/MySQL Search Engine Query Question > I am currently working on a website that is implemented using PHP and MySQL. > > The site currently has a simple sear

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

2002-07-27 Thread Naintara Jain
exes (refer to the MySQL manual). -Naintara -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] t]On Behalf Of Paul Maine Sent: Sunday, July 28, 2002 8:02 AM To: PHP PHP Subject: [PHP] PHP/MySQL Search Engine Query Question I am currently working on a website that is implem

[PHP] PHP/MySQL Search Engine Query Question

2002-07-27 Thread Paul Maine
I am currently working on a website that is implemented using PHP and MySQL. The site currently has a simple search engine that allows a shopper to type in a search string that is stored in $search. For example, if a shopper types in 1972 Ford Mustang $string ="1972 Ford Mustang" Using the follo

[PHP] php/mysql search. need help

2001-09-07 Thread lizlynch
i have a form where a user inputs a home service type and this results in a list of that value, eg a user inputs 'plumber' and a list of plumbers is displayed. if a user accidentally types plumbar no results are displayed. is there anyway of making php/mysql recognise the first three letters or

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

[PHP] PHP & MySQL Search Results

2001-04-13 Thread Jason Caldwell
Does anyone know (or have) of a good example of how to create search results like a Yahoo or MSN search? for example: Say I do a search for "cars" and there are 10,000 records in my table that match "car"... I would like to show the results in blocks of (say) 25 at a time, therefore I will need

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

[PHP] PHP | MySQL Search

2001-03-13 Thread Andre \"Tuin\" Boontjes
Hya'll, I've got a little problem with coding some php/mysql, this is what I have : - Table Search - HouseID | FacilityID | SurroundingID | PriceID | TypeID | C

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

[PHP] PHP+MySQL SEARCH

2001-02-18 Thread Gerry
I got this from a book but given the fact that it would only search for one type of information I modified it and it works great, but I wanted to know what you think about it if anything. Could an array be maid to trim it down? if ($search_in == "1"){ $query1 = "SELECT * FROM FISH where ID L