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.

Inventory Lookup
  <meta name="GENERATOR" content="W3e 2000">


function get_partnum($partnum="") {
<FORM ACTION="default.php" METHOD="get">

 PartNum:<INPUT TYPE="TEXT" NAME="partnum">
 <INPUT TYPE="submit" VALUE="submit">


$user= "";
$upasswd= "";

#$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);


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to