Why does my php give me an error when running a query?

Question

I would appreciate some help with this. It has been two years since I tried any PHP and I'm having issues running an SQL query. I just want to connect to the server and display some test data from a table

$dbconn = mysqli_connect("ip address and socket for server", "databaseusername", "databasepassword") or die ("Could not connect to database server."); 

mysqli_select_db($dbconn, "gig_calender") or die ("Could not select db.");

$sql = 'SELECT * FROM test';

mysqli_query($conn , $sql);

It gives no errors until i add in the mysqli_query();

Next time => http://php.net/manual/en/function.error-reporting.php and http://php.net/manual/en/mysqli.error.php while you're at it. — Funk Forty Niner, Apr 21 '16 at 17:34

score 2 · Accepted Answer · answered Apr 21 '16 at 17:32

2

You miss-typed a variable, it should be:

mysqli_query($dbconn , $sql);

answered Apr 21 '16 at 17:32

yardie

1,583
1
14
29

thanks, very poor attention to detail from me – Tom Peters Apr 22 '16 at 16:50

Why does my php give me an error when running a query?

1 Answers1