So... Hi All.

Need help with an engine or coding not on the list? Need help with a game or the website and forums here? Direct all questions here.
Post Reply
User avatar
OoZI
Posts: 109
Joined: Mon Jan 02, 2012 4:22 pm

So... Hi All.

Post by OoZI »

So... hers my problem. I keep getting this error:

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
for this code:

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++;

  }
?>
-OoZI

My Blog
User avatar
Elvar
Posts: 86
Joined: Sun Oct 07, 2012 7:04 pm

Re: So... Hi All.

Post by Elvar »

Should't

Code: Select all

first name, last name
be

Code: Select all

first_name, last_name
? :)
User avatar
OoZI
Posts: 109
Joined: Mon Jan 02, 2012 4:22 pm

Re: So... Hi All.

Post by OoZI »

*faceplam* Yup... that's it. Thanks!
-OoZI

My Blog
Post Reply

Return to “Advanced Help and Support”