JD> By the way SELECT uid, id, image, iname, quantity, type, user where it shows
JD> below that user isn't in the query- it is there in my editor.
>> $query = "SELECT uid, id, image, iname, quantity, type FROM
>{$config["prefix"]}_shop WHERE iname = $shopsearch";
The first problem would be that
Hello!!
Use LIKE in your WHERE clause...
You can also more then when Field
Example.
$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
By the way SELECT uid, id, image, iname, quantity, type, user where it shows
below that user isn't in the query- it is there in my editor.
I just forgot to put it in before sending.
Jennifer
"Jennifer Downey" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> This
This is basically what I am trying to do
if($search)
{
$query = "SELECT uid, id, image, iname, quantity, type FROM
{$config["prefix"]}_shop WHERE iname = $shopsearch";
$ret = mysql_query($query);
while(list($quantity)=mysql_fetch_row($ret))
$name = $row['user'];
echo $name;
}else{
JD> Would someone kindly point me to a tutorial on designing a search script for
JD> mysql db.
JD> I have tried to build one but can't get anywhere with it.
Well, that would depend on what and how you are searching, your table
structure, etc. Essentially, every SELECT query is a "search".
If y
Getting a search function running perplexed me, too, until I looked at the
MySQL docs. With the Full-Text Search function I got a search function
working in minutes.
http://www.mysql.com/doc/F/u/Fulltext_Search.html
Watch out for the weird bug that ignores duplicate rows, though. It can make
Hi all,
Would someone kindly point me to a tutorial on designing a search script for
mysql db.
I have tried to build one but can't get anywhere with it.
Thanks
Jennifer
--
The sleeper has awaken
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.co
