I have a problem with a MySQL request. Insertion doesn't work overnight. I don't know why.
mysql_connect('localhost', 'root', '') or die("Impossible de se connecter : ".mysql_error());
mysql_select_db('db');
$name = mysql_query("SELECT name FROM fruitandvegetable WHERE name='".mysql_real_escape_string(stripcslashes($_POST['name']))."'") or die('Erreur :'.mysql_error());
if (mysql_num_rows($name) != 0) {
$doublonName = "The name already exists";
}
$nombre = mysql_query("SELECT nombre FROM fruitandvegetable WHERE nombre='".mysql_real_escape_string(stripcslashes($_POST['nombre']))."'") or die('Erreur :'.mysql_error());
if (mysql_num_rows($nombre) != 0) {
$doublonNombre = "The number already exists";
} else {
$quer1y = mysql_query("INSERT INTO fruitandvegetable VALUES('', '".$_POST['name']."', 'color', '$month', '$description', '".$_POST['nombre']."')");
}
thanks for your help.