This is driving me nuts!

Posted on 16th Feb 2014 07:03 pm by admin

This insert query looks to be alright, however I get this error:

QuoteYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key, online) VALUES ('0', '8', 'nothing@poop.com', 'first', 'last', 'a3' at line 1


Here is the actually query:
Code: <?php
//This is only a snippet
function makeKey($id){
$key .= $id.rand(0, 10); //To Be Unique
for($j=0; $j<=3; $j++){
$key .= rand(11, 20);
}
for($k=0; $k<=3; $k++){
$key .= rand(21, 30);
}
return $key;
}
$key = makeKey($id);
mysql_query("
INSERT INTO ".TBL_PEOPLE." (id, level, email, first, last, password, activated, key, online)
VALUES ('$id', '$level', '$db_email', '$db_first', '$db_last', '$db_pass', '0', '$key', '0')
")or die(mysql_error());
?>

Any ideas? Maybe I am just tired.

Your Answer:

Login to answer

Other forums

mail() says sent but no email received
My code is quite simple:

Code: <?php
$to = "Ty44ler@yahoo.com";
$subje

PHP and SMS
Hi all forum members. I am new here and am unsure what category shoild I post this in.
Moderator

Multiple websites question.
Hi, does php have any functionality that enables a programmer to extract information from a website

'grab_files', multiple extension?
hey guys,

can anyone suggest a way to make to following line of code look for files with more

My query is being run with no results.
I have this.

Code: function DropUser($duser_id, $user_email, $user_username) {

Can't find a decent web analytics!!!
I've downloaded and installed Piwik. It's location detection based on IP addresses is fairly inaccur

Basic Question about Threading and PHP...
I have a page that I am working on and it is taking several hours to process. The basics of what th

BackButton Behaviour in AJAX
I have an ASPX Page AJAX Enabled!The page has a gridView and a DDL for filtering on it. The Gridview

User information
Hi All,
By using t-code SUIM we get all the user details,if suppose we donot have permission t

getting most records by count
Code: [Select]<?php

$connect = mysql_connect("localhost","dam