Error querying database.

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

I get the above error when trying to insert some values to a datatable.
Here's the code :

Code: $dbc = mysqli_connect('127.0.0.1:3306', 'root', 'xxxx', 'aliendatabase')
or die('Error connecting to MySQL server.');

$query = "INSERT INTO aliens_abduction (first_name, last_name, " .
"when_it_happened, how_long, how_many, alien_description, " .
"what_they_did, fang_spotted, other, email) " .
"VALUES ('myFirstName', 'myLastName', '5 years ago', '2 years', '7 aliens', " .
"green eyes', 'we talked', " .
"'yes', 'none@gmail.com')";

$result = mysqli_query($dbc, $query)
or die('Error querying database.');

mysqli_close($dbc);

Any ideas on what am I doing wrong?
Thank you very much

Your Answer:

Login to answer

Other forums

Parse Error
Hi Guys,

I have a function in my class which returns a string link variable. The problem is i

value not going in data base
hello friends....
i am having a working javascript....when i am selecting any

check comment for html
hi, I just wanted to check if a comment a user posts contains HTML, and if it does, to not allow it

[newb] Image hosting help.
Hey there, I'm new to php, I know some basics and i can code PWN, I'm only 14 but I'm interested in

Parse Error with doctype
I'm getting a parse error with this simple code. I don't get it. It worked one time then when I relo

MVC - Code review
I'm in the process of trying to wrap my head around MVC, and as part of that, I'm attempting to impl

Multiple Options for a Single Page
For this example I want to use the Handlers option which is under Fed Admin and all the related codi

Simple AND question
Hello,

I've got following code:

Code: if(strpos($row[13],"http://")

Batch update record with Pagination
Hoping someone can help me with this issue I'm having, im trying to batch update records from a resu

Significance of BPM
Hi Experts,
I am a novice in BPM , I just want to know how BPM as permenant department is