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

[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