Маlко помощ за един код...

[Noxy]

Чнг преди всичко ! Това е част от кода на една страничка...

1.понеже съм начинаещ и доста неща не са ми ясни все още... Кода е доста тежък и съм сигурен че има и по лесен и бърз начин за изпълнение...Такаче дали ще може да преработите малко заявките към базата данни...

2. Нещо тази заявка не се изпълнява...

//EI TUJA :

mysql_query_err("UPDATE " . $tprefix . "finansi SET change='$change' WHERE id='1'");

3. Понеже първо правя Select a после Update ... използвам този ред:

 echo("<META HTTP-EQUIV=\"Refresh\" CONTENT=\"1\"; URL=\"ad_fiksing.php\">");

може ли нещо друго да се измисли ?






Това е кода:

$query="SELECT `leva` FROM " . $tprefix . "finansi WHERE id = '1' ";
$result=mysql_query($query); 
$modprice=mysql_result($result,0,"leva"); 
$query="SELECT `leva` FROM " . $tprefix . "finansi WHERE id = '2' ";
$result=mysql_query($query); 
$modeuro=mysql_result($result,0,"leva");
 $query="SELECT `fixed` FROM " . $tprefix . "finansi WHERE id = '2' ";
$result=mysql_query($query); 
$eurofixed=mysql_result($result,0,"fixed"); 

include	"fiksing_bnb.php";

//kurs na evroto :
$eurofixed=round( $eurofixed,2);
echo "<form method=\"POST\" action=\"ad_fiksing.php\">
<table border=\"0\" width=\"600\" id=\"table1\" cellspacing=\"0\" cellpadding=\"0\">
	<tr>
		<td width=\"300\">	
		<p align=\"left\"><input type=\"checkbox\" name=\"C1\" value=\"1\"><font size=\"3\">USD</font> <input type=\"text\" name=\"dada0\" value=\"$res[1]\" size=\"9\"> <font size=\"3\">$</font></td>
		<td width=\"300\">
		<p align=\"right\"><font size=\"3\">USD</font> <input type=\"text\" name=\"dada\" value=\"$modprice\" size=\"9\"> <font size=\"3\">$</font></td>
	</tr>
</table><br><br>
<table border=\"0\" width=\"600\" id=\"table1\" cellspacing=\"0\" cellpadding=\"0\">
	<tr>
		<td width=\"300\">		
		<p align=\"left\"><input type=\"checkbox\" name=\"C2\" value=\"1\"><font size=\"3\">Euro</font> <input type=\"text\" name=\"dada\" value=\"$eurofixed\" size=\"9\"> <font size=\"3\">$</font></td>
		<td width=\"300\">
		<p align=\"right\"><font size=\"3\">Euro</font> <input type=\"text\" name=\"dada\" value=\"$modeuro\" size=\"9\"> <font size=\"3\">$</font></td>
	</tr>
</table><br><br>

	
	<select size=\"1\" name=\"T2\">
	<option selected value=\"1\">Добави към сегашната стойност.</option>
	<option value=\"2\">Въведи нова стойност.</option>
	</select><span lang=\"bg\">   </span>
	<input type=\"text\" name=\"T1\" size=\"20\"><span lang=\"bg\">              
	</span><input type=\"submit\" value=\"Submit\" name=\"B3\"><input type=\"reset\" value=\"Reset\" name=\"B4\">
</form>";
$eurofix=$_POST["dada"];
$checkbox=$_POST["C1"];
$checkbox2=$_POST["C2"];
$change = $_POST["T1"];
$type = $_POST["T2"];
$submit=$_POST["B3"];
$sum= round ($change+$res[1], 2);
$sum2=round ($change+$eurofixed, 2);
if (($submit=="Submit")&&($checkbox+$checkbox2!=0)){

if (($checkbox==1) && ($checkbox2!=1)){
if ($type==1){
mysql_query_err("UPDATE " . $tprefix . "finansi SET leva='$sum' WHERE id='1'");


//EI TUJA :

mysql_query_err("UPDATE " . $tprefix . "finansi SET change='$change' WHERE id='1'");
}
 else {mysql_query_err("UPDATE " . $tprefix . "finansi SET leva='$change' WHERE id='1'");}}


 else {if (($checkbox!=1) && ($checkbox2=1)){ if ($type==1)  {mysql_query_err("UPDATE " . $tprefix . "finansi SET leva='$sum2' WHERE id='2'");
} else {mysql_query_err("UPDATE " . $tprefix . "finansi SET leva='$change' WHERE id='2'");}}

}
if (($checkbox==1) && ($checkbox2==1)){
if ($type==1){
mysql_query_err("UPDATE " . $tprefix . "finansi SET leva='$sum' WHERE id='1'");
mysql_query_err("UPDATE " . $tprefix . "finansi SET leva='$sum2' WHERE id='2'");}
 else {mysql_query_err("UPDATE " . $tprefix . "finansi SET leva='$change' WHERE id='1'");
       mysql_query_err("UPDATE " . $tprefix . "finansi SET leva='$change' WHERE id='2'");}}
        echo("<META HTTP-EQUIV=\"Refresh\" CONTENT=\"1\"; URL=\"ad_fiksing.php\">"); 
}