First I posted the whole script cause I am not sure what I am doing wrong. I been at this all day and cant figure it out.
What this should do is when i open it up, it should echo the info in the fields, from what I entered in the formed and saved it. If I edit it, it should only update the same row and not make another row.
But I cant get it to do neither. At some point after changing things and moving things around, i was able to submit the data. But now cant remember what I did then. Regardless i cant figure this out. If someone could help me so that I learn from this all day problem that would be great.
<?
require_once "common.php";
checklogin();
dbconnect();
$res="";
if ($setpaypal=='1'){
$query="insert into paypal (admin_paypal_email, paypaltext1, image1, amount1, paypaltext2, image2, amount2, paypaltext3, image3, amount3) VALUES ('$admin_paypal_email', '$paypaltext1', '$image1', '$amount1', '$paypaltext2', '$image2', '$amount2', '$paypaltext3', '$image3', '$amount3')";
}
mysql_query($query) or die( "ERROR: " . mysql_error() . "\n");
$query="SELECT admin_paypal_email, paypaltext1, image1, amount1, paypaltext2, image2, amount2, paypaltext3, image3, amount3 from paypal";
$result = mysql_query($query) or die("Query failed"); {
$admin_paypal_email=$myrow["admin_paypal_email"];
$paypaltext1=$myrow["paypaltext1"];
$image1=$myrow["image1"];
$amount1=$myrow["amount1"];
$paypaltext2=$myrow["paypaltext2"];
$image2=$myrow["image2"];
$amount2=$myrow["amount2"];
$paypaltext3=$myrow["paypaltext3"];
$image3=$myrow["image3"];
$amount3=$myrow["amount3"];
$res="Successfully added an record";
?>
<p><center>Please note that when setting up Buttons for your PayPal, that you must use primary Paypal ID</center></p><br>
<form action="addpaypal.php" method=post>
<table width="600" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333333">Paypal Receiver Email</font></td>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333333">
<input type="text" name="admin_paypal_email" size="80" value="<?echo $myrow["admin_paypal_email"];?>">
</font></td>
</tr>
<tr>
<td colspan="2">
</td>
</tr>
<!-- Payment1-->
<tr>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333333">Heading for Silver Payment</font></td>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333333">
<input type="text" name="paypaltext1" size="80" value="<?echo $myrow["paypaltext1"];?>">
</font></td>
</tr>
<tr>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333333">Image for Silver Payment</font></td>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333333">
<input type="text" name="image1" size="80" value="<?echo $myrow["image1"];?>">
</font></td>
</tr>
<tr>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333333">Amount for Silver Payment</font></td>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333333">
<input type="text" name="amount1" size="80" value="<?echo $myrow["amount1"];?>">
</font></td>
</tr>
<tr>
<td colspan="2">
</td>
</tr>
<!-- Payment2-->
<tr>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333333">Heading for Gold Payment</font></td>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333333">
<input type="text" name="paypaltext2" size="80" value="<?echo $myrow["paypaltext2"];?>">
</font></td>
</tr>
<tr>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333333">Image for Gold Payment</font></td>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333333">
<input type="text" name="image2" size="80" value="<?echo $myrow["image2"];?>">
</font></td>
</tr>
<tr>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333333">Amount for Gold Payment</font></td>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333333">
<input type="text" name="amount2" size="80" value="<?echo $myrow["amount2"];?>">
</font></td>
</tr>
<tr>
<td colspan="2">
</td>
</tr>
<!-- Payment3-->
<tr>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333333">Heading for Platium Payment</font></td>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333333">
<input type="text" name="paypaltext3" size="80" value="<?echo $myrow["paypaltext3"];?>">
</font></td>
</tr>
<tr>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333333">Image for Platium Payment</font></td>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333333">
<input type="text" name="image3" size="80" value="<?echo $myrow["image3"];?>">
</font></td>
</tr>
<tr>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333333">Amount for Platium Payment</font></td>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333333">
<input type="text" name="amount3" size="80" value="<?echo $myrow["amount3"];?>">
</font></td>
</tr>
<tr>
<td colspan="2">
</td>
</tr>
<tr>
<td colspan="2">
<div align="center"> <font face="Arial, Helvetica, sans-serif" size="2" color="#333333">
<input type="hidden" name="setpaypal" value="1">
<input type="reset" name="Submit2" value="Reset">
<input type="submit" name="Submit" value="Save">
</font></div>
</td>
</tr>
</table>
</form>
<?
}
?>
