The method is right, for your form, the problem is the lowercase $_get, I believe. use $_GET['formfield']
Jeff "Mike Germain" <mike.germain@zi To: [EMAIL PROTECTED] nsser.com> cc: Subject: [PHP-DB] help with $_Get in form 06/21/2002 02:24 PM I'm trying to get a partnum field into a select statement but i'm not getting anything passed into the varable. i'm sure it's a simple fix but i can't find it. thx mike <html> <head> Inventory Lookup <meta name="GENERATOR" content="W3e 2000"> <title></title> </head> <body> <?php $partnum=""; function get_partnum($partnum="") { ?> <FORM ACTION="default.php" METHOD="get"> PartNum:<INPUT TYPE="TEXT" NAME="partnum"> <INPUT TYPE="submit" VALUE="submit"> </FORM> <?php } $dsn="invfile"; $user= ""; $upasswd= ""; get_partnum(); #$partnum= $_get['partnum']; echo $partnum; $conn = odbc_connect($dsn,$user ,$upasswd, SQL_CUR_USE_ODBC ); echo "conn: $conn"; if ($conn <= 0) { echo "Error in connection<BR>"; exit; } else { echo "<P>Connection successful\n"; }; $query = "SELECT whs,loc,miprod,mndesc,onhand FROM npshrlib_prdinv1 where miprod = '$partnum' "; $result = odbc_exec($conn, $query); odbc_result_all($result); ?> </body> </html> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php