RE: [PHP-DB] searching an entry in inventory db

try echoing the sql statement before execution to see if the variables are correctly set...also you can cut n paste the sql into phpmyadmin or some other gui to test the statement for correctness (like quotes in the correct place etc) bastien

From: Aravalli Sai <aravallisai@yahoo.com> To: php-db@lists.php.net Subject: [PHP-DB] searching an entry in inventory db Date: Sat, 4 Dec 2004 10:14:52 -0800 (PST) hi i had designed an inventory management system where in i can ADD,INSERT,DELETE,UPDATE the data elements..but when i am trying to find(search) an entry in theinventory data base system (i want to find the entrybased 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!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php