Code: Select all
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'name, last name, age, birthday, gender, social_number, title) VALUES (Ellen, Mar' at line 1
Code: Select all
<?php
include('connect.php');
$i=1;
while($i<=100)
{
$gen_chance = rand(1,2);
switch($gen_chance) {
case 1:
$gender = "M";
break;
case 2:
$gender = "F";
break;
default:
$gender = "T";
}
switch($gender) {
case "M":
$title = "Mr.";
break;
case "F":
$title = "Miss";
break;
case "T":
$title = "Mr./Miss";
break;
default:
$title = "Mr./Miss";
}
$birthday = time();
$social_number = rand(1,9) . rand(1,9) . rand(1,9) . "-" . rand(1,9) . rand(1,9) . "-" . rand(1,9) . rand(1,9) . rand(1,9) . rand(1,9);
$name_chance = rand(1,10);
switch($gender) {
case "M":
switch($name_chance) {
case 1:
$name = "Gabriel";
break;
case 2:
$name = "Aiden";
break;
case 3:
$name = "Ethan";
break;
case 4:
$name = "Caleb";
break;
case 5:
$name = "Benjamin";
break;
case 6:
$name = "Carson";
break;
case 7:
$name = "Christopher";
break;
case 8:
$name = "Jackson";
break;
case 9:
$name = "Joshua";
break;
case 10:
$name = "Matthew";
break;
default:
$name = "John";
}
break;
case "F":
switch($name_chance) {
case 1:
$name = "Ellen";
break;
case 2:
$name = "Eleora";
break;
case 3:
$name = "Sophie";
break;
case 4:
$name = "Sharon";
break;
case 5:
$name = "Faith";
break;
case 6:
$name = "Chloe";
break;
case 7:
$name = "Olivia";
break;
case 8:
$name = "Grace";
break;
case 9:
$name = "Isabella";
break;
case 10:
$name = "Emma";
break;
default:
$name = "Sue";
}
break;
default:
$name = "Bobby";
}
$lname_chance = rand(1,20);
switch($lname_chance) {
case 1:
$lname = "Smith";
break;
case 2:
$lname = "Johnson";
break;
case 3:
$lname = "Williams";
break;
case 4:
$lname = "Jones";
break;
case 5:
$lname = "Brown";
break;
case 6:
$lname = "Davis";
break;
case 7:
$lname = "Miller";
break;
case 8:
$lname = "Wilson";
break;
case 9:
$lname = "Moore";
break;
case 10:
$lname = "Taylor";
break;
case 11:
$lname = "Anderson";
break;
case 12:
$lname = "Jackson";
break;
case 13:
$lname = "White";
break;
case 14:
$lname = "Harris";
break;
case 15:
$lname = "Martin";
break;
case 16:
$lname = "Thompson";
break;
case 17:
$lname = "Garcia";
break;
case 18:
$lname = "Martinez";
break;
case 19:
$lname = "Robinson";
break;
case 20:
$lname = "Baker";
break;
default:
$lname = "Nelson";
}
/*$check_q = "SELECT * FROM citizens WHERE social_number = '$social_number'";
$check_r = mysql_query($check_q) or die("Error!");
$check_a = mysql_fetch_assoc($check_r);
if(!isset($check_a)) {
*/
mysql_query("INSERT INTO citizens (first name, last name, age, birthday, gender, social_number, title) VALUES ($name, $lname, '18', $birthday, $gender, $social_number, $title)") or die(mysql_error());
//}
$i++;
}
?>