help, php mysql

[maxbox]

hello

        I need change this code  can you help me...

 

I need delete the values code from jos_call  after validate and insert this to another tables  jos_call1

 

If code true  delete code  from jos_call  and insert the code in to jos_call1.

I must have a valid code only one time .

 

<?php


$mysql_host="XXXXXXXX";
$mysql_user="XXXXXX";
$mysql_password="XXXXXXXXX";
$mysql_db = "XXXXXXX"; 


$conn = mysql_connect("$mysql_host","$mysql_user","$mysql_password")or die("Could not connect : " . mysql_error());
mysql_select_db("$mysql_db",$conn) or die("Select database failed"); 


$var=@$_REQUEST['nombre']."'";
$query= mysql_query("Select * from jos_call where code = '".$var,@$conn);
if (mysql_num_rows($query) == 0 )  {
echo @$_REQUEST['nombre'].'  Su codigo 6 digitos.Codigo no valido.';
}else{
echo @$_REQUEST['nombre'].'  Codigo correcto! ' ;
}
mysql_close($conn);

?>