mysqli_query返回错误

Question

Hi I'm very new to php and my query to my mysql database is returning an error. My connection is fine, but there's something wrong with my query. I've run it through php validators but they can't find any errors. Any help would be appreciated. Thanks in advance. Here's my code.

<?php
$dbc=mysqli_connect('url','username','password')
or die('error connecting');

$query = "INSERT INTO mailing_list (first_name, last_name, email_address)" . 
"VALUES ('one','two','three')";

$answer = mysqli_query($dbc,$query)
or die('error querying');


mysqli_close($dbc);
?>

Answer 1

you have the connection almost right but where is your database selector,also check your php extension whether it is mysql or mysqli