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{
echo "<FORM METHOD=post ACTION='$PHP_SELF'>";
echo "Search Shops<BR><input type=text name=\"shopsearch\" value=\"\">";
echo "<BR><INPUT TYPE='submit' NAME='search' VALUE='Search'>";
}
This is a dump of the table
uid int(10) NOT NULL default '0',
id int(5) NOT NULL default '0',
iname varchar(50) NOT NULL default '',
image varchar(100) NOT NULL default '',
quantity int(10) unsigned NOT NULL default '1',
type varchar(20) NOT NULL default '',
price int(6) NOT NULL default '0',
user varchar(50) NOT NULL default '',
KEY uid (uid)
Just a note this works throughout my site and I have no trouble with it:
{$config["prefix"]}_shop
I'm not trying to be rude but I get sick of it when people tell me that this
is the problem when it has nothing to do with the question I am asking.
Thanks for your time and help
Jennifer
"Julie Meloni" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> 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 you post more information about your table(s) structure, your
> search methods and the search parameters, people would probably be
> able to help you.
>
>
> - Julie
>
> --> Julie Meloni
> --> [EMAIL PROTECTED]
> --> www.thickbook.com
>
> Find "Sams Teach Yourself MySQL in 24 Hours" at
> http://www.amazon.com/exec/obidos/ASIN/0672323494/thickbookcom-20
>
---
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
