[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

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

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

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 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 stating,

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

2002-07-28 Thread Tech Support
, 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 search engine that allows a shopper to type in a search string that is stored in $search. For example

[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

[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

[PHP] PHP MySQL Search Results

2001-04-14 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 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 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": ? /* Include connection details, with a variable of $connection */ if (!$page) { $page = 1; } $limit = $page * 25; $limit = $limit - 25; $sql = "SELECT FROM table

[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 |

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