Why do I get an internal server error from my SQL query?

Question

I am attempting to retrieve some data from my database, I appear to be able to connect to the database as I do not get an error message after the connection is tested. But when I attempt to run a select query, it causes an internal error.

If I take the FROM part away from the query, the page loads with no data. If I add the FROM part back in, with the table to be selected from, the internal error occurs.

The code is below:

$con = mysqli_connect("50.62.209.87:3306","myusername","mypassword",
"FiveExtras");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

     $query = "SELECT `EventVenue`,`EventDate`,`EventTime`,
     `EventPostCode` FROM `event`";

  $result = mysqli_query($con, $query);


$row = $result;

echo $row;

If you are using XAMPP have a look at [this question](http://stackoverflow.com/questions/3719549/where-does-phps-error-log-reside-in-xampp) — pbaldauf, Feb 06 '15 at 18:33

Deimantas · Answer 1 · 2015-02-06T19:50:28.253

1

did you change your htacess? Changes to .htacess often cause internal server error. or your host ip is bad(try no-ip.com, they give free subdomains for your ip's)

i checked it with removed port it worked(well...not connecting but no error about host), so maybe it's something to do with port

if error 500 remains try get support ticket or email webmaster or get another hosting provider

why would you say no error?

here we go:

Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given
in /home/u451361813/public_html/test.php on line 13

and

Warning: mysqli_connect(): (28000/1045): Access denied for user
'myusername'@'185.28.20.221' (using password: YES) in /home/u451361813
/public_html/test.php on line 3
Failed to connect to MySQL: Access denied for user 
'myusername'@'185.28.20.221' (using password: YES)

1st one is for no information returned second for no password

edited Feb 06 '15 at 19:50

answered Feb 06 '15 at 18:35

Deimantas

56
1
14

OK tahnsk, I took the host address from the databse section on my godadddy management page so i thought it would be ok – user3519506 Feb 06 '15 at 18:43
I hope theOP didn't include the ACTUAL ID/pwd to a live database. – Matt Runion Feb 06 '15 at 18:45
No, I used 'myusername' and 'mypassword' to show that I had no left the fields blank – user3519506 Feb 06 '15 at 18:52
I took the database select out to see if the database connection was ok so thas probably why you could see it without error. I have put the database select back in now, so the error is back – user3519506 Feb 06 '15 at 19:20
did you try your ip and/or port? – Deimantas Feb 06 '15 at 19:31
I dont have a test.php file anymore, so I am not sure why that is showing up – user3519506 Feb 06 '15 at 19:33
I have tried the ip with the socket, how do I tryy the port? – user3519506 Feb 06 '15 at 19:34
that from my test page – Deimantas Feb 06 '15 at 19:34
if you can, try to remove :3306 at the end of your ip and see what happens – Deimantas Feb 06 '15 at 19:35
but surly you would need my login details to test it? – user3519506 Feb 06 '15 at 19:36
you can create new blank db for me to test it – Deimantas Feb 06 '15 at 19:37
also if you're on shared hosting theres email ...@...... try emailing them or getting a ticked – Deimantas Feb 06 '15 at 19:38

score 1 · Answer 2 · edited Feb 06 '15 at 19:17

1

Rewrite your connection:

$db_conn = mysqli_connect("$host", "$dbuser", "$dbpass") or die("Unable to connect to the database");
mysql_select_db("$dbase", $db_conn) or die("Unable to select the database");

$query = mysqli_query("SELECT `EventVenue`,`EventDate`,`EventTime`,
 `EventPostCode` FROM `event`");

And why $result = $row ?

EDIT: For a better query , use "SELECT * ... "

edited Feb 06 '15 at 19:17

Makyen

31,849
12
86
121

answered Feb 06 '15 at 18:48

GasKa

54
6

I have changed my code to yours. The code for connecting seems to work, but the database select causes internal error – user3519506 Feb 06 '15 at 19:04
it gives 500 internal error, I tto screen print but cant find a way to show you. – user3519506 Feb 06 '15 at 19:17
1

note a small typo, it should be `mysqli_select_db'. – Dan Feb 06 '15 at 19:35
Using `SELECT * ...` doesn't make it a better query. Select only the fields you need. – Feb 06 '15 at 19:35

Why do I get an internal server error from my SQL query?

2 Answers2