how to search an entry in php sqlite db
| From: | Aravalli Sai | Date: | Fri, 03 Dec 2004 21:07:57 +0000 |
| Subject: | how to search an entry in php sqlite db | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-37567@lists.php.net to get a copy of this message | ||
hi
i am trying to find(search) an entry in the
inventory data base system ...i want to find the entry
based on the "tagno" since this is the primary key in
my table..
the logic i had written is
if(isset($_POST['submit'])) {
if (!empty($_POST['tagno']))
{
$insquery ="select
agno=(\"".sqlite_escape_string($_POST['tagno'])."\")
from
inventory where
tagno=(\"".sqlite_escape_string($_POST['tagno'])."\")";
$insresult = sqlite_query($handle,$insquery) or
die("error:".sqlite_error_string(sqlite_last_error($handle)));
echo "<i>successfully found!</i>";
}
else
{
echo "<i>not found!!!</i>";
}
}
if i run this,it is giving me entire table ...but i
want only that particular row whose tagno i had
entered...
i would appreciate if anyone can figure out this...
__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250