Hello!!
Your right!!
Advertising
don't use = on the like part...I don't know what I was thinking!!!
Anyway here is the code right from my search page...
include("./navbar2.php");
$nav = new navbar;
$nav->numrowsperpage = 30;
$sql = "SELECT Print_Name, Art_Job_Number, Size, Item_Number FROM
Table1 WHERE Print_Name LIKE '%$Print_Name%' ORDER BY $or $place";
$result = $nav->execute($sql, $db, "mysql");
$rows = mysql_num_rows($result);
for ($y = 0; $y < $rows; $y++){
$data = mysql_fetch_object($result);
That should do it!!
Dan
On Thursday, April 25, 2002, at 09:23 AM, [EMAIL PROTECTED] wrote:
> The query should read as below, without the = after the LIKE:
>
> $query = "SELECT uid, id, image, iname, quantity, type FROM
> {$config["prefix"]}_shop WHERE iname LIKE '%$shopsearch% ORDER BY
> iname'";
>
> HTH
>
> Maureen
>
>
> Jennifer Downey <[EMAIL PROTECTED]> said:
>
>> Hi all,
>>
>> I have been trying to build a search script for my site that deals
>> with only
>> one table in my db.
>> As Julie Meloni pointed out look in the MySQL manual for LIKE clauses I
>> can't seem to locate that clause in ether
>> manual.
>> Dan Brunner gave me this to go on:
>>
>> $query = "SELECT uid, id, image, iname, quantity, type FROM
>> {$config["prefix"]}_shop WHERE iname LIKE = '%$shopsearch% ORDER BY
>> iname'";
>> $ret = mysql_query($query);
>> while(list($quantity)=mysql_fetch_row($ret))
>>
>> But I can't seem to get this to work. I have never worked with LIKE
>> before
>> and would appreciate any help on this.
>>
>> Thanks Julie and Dan for your time and effort.
>>
>> Thanks all for your time and help
>> Jennifer
>>
>>
>> --
>> The sleeper has awaken
>>
>>
>> ---
>> Outgoing mail is certified Virus Free.
>> Checked by AVG anti-virus system (http://www.grisoft.com).
>> Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002
>>
>>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>
>
>
> --
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
