Hola maycolalvarez,
es verdad, lo que pasa es que en el código original en MySQL si esta declarada, pero al pasarla a SQLite no se como definirla.
Este es el mismo código pero para MYSQL:
Código PHP:
Ver original$sql = mysql_query("SELECT * FROM users WHERE phone='".$phone."' "); {
echo '
<SCRIPT LANGUAGE="javascript">
alert(\'Error, Phone Number is allready in the system !!\');
document.location=(\'new_player.php\');
</SCRIPT>
';
} else {
$sql = mysql_query("SELECT * FROM users WHERE email='".$email."' "); {
echo '
<SCRIPT LANGUAGE="javascript">
alert(\'Error, E-Mail allready in the system !!\');
document.location=(\'new_player.php\');
</SCRIPT>
';
} else {
$sql = mysql_query("SELECT * FROM archived WHERE first_name='".$first_name."' AND last_name='".$last_name."' AND email='".$email."' AND phone='".$phone."' "); {
echo '
<SCRIPT LANGUAGE="javascript">
alert(\'Error, this user is allready in the system on ARCHIVED list. !!\');
document.location=(\'new_player.php\');
</SCRIPT>
';
} else {
$sql = "INSERT INTO users (first_name, last_name, phone, email, level, uspa, comment, court_price, pala_rental_price, beberage_price, lesson_price, pala_sale_price, balls_price, overgrip_price, food_price, other, playing) VALUES ('$first_name', '$last_name', '$phone', '$email', '$level', '$uspa', '$comment', '$court_price', '$pala_rental_price', '$beberage_price', '$lesson_price', '$pala_sale_price', '$balls_price', '$overgrip_price', '$food_price', '$other', '$playing' )";
}
}
}
Alguna idea??
Gracias