Code: Select all
$copy = mysql_fetch_array(mysql_query("SELECT * FROM `snatest` WHERE `OEMSku`= '$_POST[OEMSku]'")) or die(mysql_error());
On the main form the code looks like this:
Code: Select all
<body bgcolor="#C0C0C0">
<h1> <img border="0" src="logo1.jpg" width="78" height="77">
<font face="Arial" color="#000080">Lookup Process</font> </h1>
<form id="form1"; name="form1"; method="post" action="lookup.php">
<table width="366"; border="0"; cellspacing="0"; cellpadding="4";>
<tr>
<td align="left" valign="top" width="94"><b>
<font face="Arial" color="#000080" size="2">OEM SKU:</font></b></td>
<td align="left" valign="top" width="224"><font color="#000080" face="Arial">
<font color="#000080"><select name="OEMSku" style="font-weight: 700">
<option value="1";>Test1</option>
<option value="2";>Test2</option>
<option value="3";>Test3</option>
<option value="4";>Test4</option>
</select></font><b><font size="2"> </font></b></font>
</td>
</tr>
<tr>
<td ; align="right"><input type="submit" name="Submit" value="Submit" />
</td>
</tr>
</table>
</form>
So what I need to understand is what should I call in this instance... the $_POST[OEMSku] or the variables the users are selecting? I have tried several attempts at trying to figure out the logic but I guess I'm not approaching this correctly.
Ideas?
Texman