This is basically what I am trying to do
    $query = "SELECT uid, id, image, iname, quantity, type FROM
{$config["prefix"]}_shop WHERE  iname = $shopsearch";
  $ret = mysql_query($query);

   $name = $row['user'];
   echo $name;


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

"Julie Meloni" <[EMAIL PROTECTED]> wrote in message
> 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
> -->
> Find "Sams Teach Yourself MySQL in 24 Hours" at

Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to