help needed

[Raisario]

how do you save a text box entry from a previous page then use it in a WHERE part of the sql statement............

[Oleg Butuzov]

can you explain me what are you want to do?

(my english is not good for understendig what are you say)

[Raisario]

look at my newest Topic I posted, it is more detailed and its exactly same question....

I just forgot i already asked this question. hehe

[Oleg Butuzov]

I had delete your post.

What i'm trying to do is take an entry from a drop down box from a previous page to my WHERE clause in a SQL statement in a different page.

Dropdown box code from previous page:

<?php
if ($viewby=="description")
{
echo "<FORM NAME='SelectDescription' ACTION='PHPSearchResults2.php?Displayby=description' Method='Post'>
Select Category:<SELECT NAME='description'>
<OPTION SELECTED>The Home MarketPlace
<OPTION SELECTED>Walter Drakes
<OPTION SELECTED>Both
</SELECT>
<INPUT TYPE='submit' Name='cmdSearch' Value='Search'>
</FORM>";
}
?>

SQL statement in a different page:

$query_coupon = mysql_query ("SELECT coupontypes.coupon_id, coupontypes.percent_discount, coupontypes.description, coupons.status, coupons.purchase_amount, coupons.retailer_ordernum, coupons.purchase_time, users.username FROM coupontypes, coupons, users WHERE coupontypes.description = $description");
-------------------------------------------------------------------------------------

This code doesnt work. i need to know how to save entry from previous page without using session variables then use it in my sql statement
pls help a noob ASAP if possible, this project is almost due and teacher is gonna beat me down :cry:

<?php
if ($viewby=="description")
{
echo "<FORM NAME='SelectDescription' ACTION='PHPSearchResults2.php?Displayby=description' Method='Post'>
Select Category:<SELECT NAME='description'>
<OPTION value=some1>The Home MarketPlace</option>
<OPTION value=some2>Walter Drakes</option>
<OPTION value=some3>Both</option>
</SELECT>
<INPUT TYPE='submit' Name='cmdSearch' Value='Search'>
</FORM>";
}
?>


$query_coupon = mysql_query ("SELECT `coupontypes.coupon_id`, `coupontypes.percent_discount`, `coupontypes.description`, `coupons.status`, `coupons.purchase_amount`, `coupons.retailer_ordernum`, `coupons.purchase_time`, `users.username` FROM `coupontypes`, `coupons`, `users` WHERE `coupontypes.description` = '$description'");

[wiredme]

I had delete your post.

What i'm trying to do is take an entry from a drop down box from a previous page to my WHERE clause in a SQL statement in a different page.

Dropdown box code from previous page:

<?php
if ($viewby=="description")
{
echo "<FORM NAME='SelectDescription' ACTION='PHPSearchResults2.php?Displayby=description' Method='Post'>
Select Category:<SELECT NAME='description'>
<OPTION SELECTED>The Home MarketPlace
<OPTION SELECTED>Walter Drakes
<OPTION SELECTED>Both
</SELECT>
<INPUT TYPE='submit' Name='cmdSearch' Value='Search'>
</FORM>";
}
?>

SQL statement in a different page:

$query_coupon = mysql_query ("SELECT coupontypes.coupon_id, coupontypes.percent_discount, coupontypes.description, coupons.status, coupons.purchase_amount, coupons.retailer_ordernum, coupons.purchase_time, users.username FROM coupontypes, coupons, users WHERE coupontypes.description = $description");
-------------------------------------------------------------------------------------

This code doesnt work. i need to know how to save entry from previous page without using session variables then use it in my sql statement
pls help a noob ASAP if possible, this project is almost due and teacher is gonna beat me down :cry:

<?php
if ($viewby=="description")
{
echo "<FORM NAME='SelectDescription' ACTION='PHPSearchResults2.php?Displayby=description' Method='Post'>
Select Category:<SELECT NAME='description'>
<OPTION value=some1>The Home MarketPlace</option>
<OPTION value=some2>Walter Drakes</option>
<OPTION value=some3>Both</option>
</SELECT>
<INPUT TYPE='submit' Name='cmdSearch' Value='Search'>
</FORM>";
}
?>


$query_coupon = mysql_query ("SELECT `coupontypes.coupon_id`, `coupontypes.percent_discount`, `coupontypes.description`, `coupons.status`, `coupons.purchase_amount`, `coupons.retailer_ordernum`, `coupons.purchase_time`, `users.username` FROM `coupontypes`, `coupons`, `users` WHERE `coupontypes.description` = '$description'");

I have a code like this all text is quiried from database : heres the code
<SELECT NAME="day" style='font-family: Verdana; font-size: 10px; border: 1px solid #A0D2FF'>
<?
$resultd = mysql_query("SELECT * FROM days", $link_id);
while ($datad=mysql_fetch_array($resultd))
{
$optiond=$datad['day'];
if ($optiond!="[select one]")
{
if ($day==$optiond)
{
echo "<OPTION selected="selected" VALUE="inputevent.php?day=$optiond" size='20'>$optiond</OPTION>";
}
else
{
echo "<OPTION VALUE="$optiond">$optiond</OPTION>";
}
}
}
?>
</SELECT>