type of value

[rutin]

Hi there,
Since very long time i am trying to write some sort of payment module.
I have this table

 
CREATE TABLE `paytype` (
  `paytype_id` int(11) NOT NULL auto_increment,
  `paytypes` varchar(50) default NULL,
  `pay_active` varchar(50) default NULL,
  PRIMARY KEY  (`paytype_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

INSERT INTO `paytype` VALUES (1, 'Pay Flow Pro', 'no');
INSERT INTO `paytype` VALUES (2, 'Pay Pall', 'yes');
INSERT INTO `paytype` VALUES (3, 'Check/Money Order', 'no');

Depends of value " yes " or "no", i would like to show form for payment.

I have started on something, but dont know how to continue from this part.
Here is what i have :

                    <? 
$sel_paytype = mysql_query("SELECT * from paytype Where paytypes = 'Pay Pall' and pay_active = 'yes'");
$sel_pall = mysql_query("SELECT * from paypall");

$row_pall = mysql_fetch_array($sel_pall);

if ($pay_mode_t == "paypall") 

{ ?>
                      <form action="https://www.paypal.com/cgi-bin/webscr" method="post" name="form1">
                        <? } else {?>
                      </form>

I was thinking if any1 can help me with this function, based on what type of payment is on to brig form.

          <?
		   $sel_paytype = mysql_query("SELECT * from paytype Where paytypes = 'Pay Pall' and pay_active =' yes'");
		   if (mysql_num_rows($sel_paytype) <> 0) {
		  ?>

Thanks

[Roger_Ramjet]

??????

[rutin]

Hi there,
I am sorry for broken english, allow me to try again and explain.
If one of the options has value yes, that will mean " paymanet method is on "
I would like to execute the part of my code which i putting right now.

<?
// Method Pay Flow Pro
$sel_paytype = mysql_query("SELECT * from paytype Where paytypes = 'Pay Flow Pro' and pay_active = 'yes'");
if (mysql_num_rows($sel_paytype) <> 0) {
?>
<tr class="bodytext">
<td colspan="2"><div align="right"><strong>Payment Mode:</strong></div></td>
<td>
<input name="pay_mode_t" type="radio" value="cc" <? if ($pay_mode_t == "cc" or $pay_mode_t == "") echo "checked";?> onClick="javascript:submit();">
Credit Card</td>
<? } ?>
</tr>


<?
//Method Pay Pal
$sel_paytype = mysql_query("SELECT * from paytype Where paytypes = 'Pay Pall' and pay_active =' yes'");
if (mysql_num_rows($sel_paytype) <> 0) {
?>
<tr class="bodytext">
<td colspan="2">&nbsp;</td>
<td>
<input type="radio" name="pay_mode_t" value="paypall" <? if ($pay_mode_t == "paypall") echo "checked";?> onClick="javascript:submit();">
Pay Pal</td>
</tr>
<? } ?>


<?
// Method Check Money Order
$sel_paytype = mysql_query("SELECT * from paytype Where paytypes = 'Check/Money Order' and pay_active = 'yes'");
if (mysql_num_rows($sel_paytype) <> 0) {
?>
<tr class="bodytext">
<td colspan="2">&nbsp;</td>
<td>
<input type="radio" name="pay_mode_t" value="mo" <? if ($pay_mode_t == "mo") echo "checked";?> onClick="javascript:submit();">
Check/Money Order</td>
</tr>
 <? } ?>








// Whats seleceted proceed
// Payment via Credit Card
<? if ($pay_mode_t == "cc" or $pay_mode_t == "") { ?>
<a href="pay_2.php?tot=<? echo number_format(($sum_total1+$row_ship[1] + $sum_total1*$row_vat[3]/100) + $ship_tax_tot_list, 2) ?>&send_to=<? echo $ship_id?>&ship_met_send=<? echo $ship_tax_tot_list?>&shop_tax=<? echo number_format($sum_total1*$row_vat[3]/100, 2)?>">
<img src="images/next.gif" width="51" height="19" border="0">
</a>
<? } ?>


// Payment By Wire
<? if ($pay_mode_t == "mo") { ?>
 <a href="pay_mo.php?tot=<? echo number_format(($sum_total1+$row_ship[1] + $sum_total1*$row_vat[3]/100) + $ship_tax_tot_list, 2) ?>&send_to=<? echo $ship_id?>&ship_met_send=<? echo $ship_tax_tot_list?>&shop_tax=<? echo number_format($sum_total1*$row_vat[3]/100, 2)?>"><img src="images/next.gif" width="51" height="19" border="0">
</a>
<? } ?>

<?
// Method Pay Flow Pro
$sel_paytype = mysql_query("SELECT * from paytype Where paytypes = 'Pay Flow Pro' and pay_active = 'yes'");
if (mysql_num_rows($sel_paytype) <> 0) {
?>
<tr class="bodytext">
<td colspan="2"><div align="right"><strong>Payment Mode:</strong></div></td>
<td>
<input name="pay_mode_t" type="radio" value="cc" <? if ($pay_mode_t == "cc" or $pay_mode_t == "") echo "checked";?> onClick="javascript:submit();">
Credit Card</td>
<? } ?>
</tr>


<?
//Method Pay Pal
$sel_paytype = mysql_query("SELECT * from paytype Where paytypes = 'Pay Pall' and pay_active =' yes'");
if (mysql_num_rows($sel_paytype) <> 0) {
?>
<tr class="bodytext">
<td colspan="2">&nbsp;</td>
<td>
<input type="radio" name="pay_mode_t" value="paypall" <? if ($pay_mode_t == "paypall") echo "checked";?> onClick="javascript:submit();">
Pay Pal</td>
</tr>
<? } ?>


<?
// Method Check Money Order
$sel_paytype = mysql_query("SELECT * from paytype Where paytypes = 'Check/Money Order' and pay_active = 'yes'");
if (mysql_num_rows($sel_paytype) <> 0) {
?>
<tr class="bodytext">
<td colspan="2">&nbsp;</td>
<td>
<input type="radio" name="pay_mode_t" value="mo" <? if ($pay_mode_t == "mo") echo "checked";?> onClick="javascript:submit();">
Check/Money Order</td>
</tr>
 <? } ?>








// Whats seleceted proceed

<? if ($pay_mode_t == "cc" or $pay_mode_t == "") { ?>
<a href="pay_2.php?tot=<? echo number_format(($sum_total1+$row_ship[1] + $sum_total1*$row_vat[3]/100) + $ship_tax_tot_list, 2) ?>&send_to=<? echo $ship_id?>&ship_met_send=<? echo $ship_tax_tot_list?>&shop_tax=<? echo number_format($sum_total1*$row_vat[3]/100, 2)?>">
<img src="images/next.gif" width="51" height="19" border="0">
</a>
<? } ?>


<? if ($pay_mode_t == "mo") { ?>
 <a href="pay_mo.php?tot=<? echo number_format(($sum_total1+$row_ship[1] + $sum_total1*$row_vat[3]/100) + $ship_tax_tot_list, 2) ?>&send_to=<? echo $ship_id?>&ship_met_send=<? echo $ship_tax_tot_list?>&shop_tax=<? echo number_format($sum_total1*$row_vat[3]/100, 2)?>"><img src="images/next.gif" width="51" height="19" border="0">
</a>
<? } ?>


<? if ($pay_mode_t == "paypall") { ?>
<? include "pay_pall.php"?>
<input name="image" type="image" title=" Next " src="images/next.gif" width="51" height="19" border="0">
<? } ?>

At the moment i have payopal option on ( or value in mySql table "yes" )
Which means payment is via paypal. Script still makes an order via Credit Card.
I dont understand why.Can you tell me what did i do wrong here?
Could it be because its first ?

Thank you very much for reading, and i thank you in advance for your answer.