SQL connection problem

BoukeBuffel

ACK yet another newb question. This time about SQL

I tried to make connection to a database on a free provider, just to see if I could do it. All I had the script do was have it show the only table there is in the database I made.

When I ran the script, it said: SERVER ERROR! Error message:
Premature end of script headers: testsql.php

testsql.php

<?php
$user = "**";
$pass = "";
$host = "";
$dbdb = "****";

if (!mysql_select_db($dbdb, mysql_connect($host, $user, $pass)))
{
echo "Cannot connect to Database.";
exit();
}
unset($user);
unset($pass);
unset($host);
unset($dbdb);
$sql = "SELECT pres_name FROM PRESIDENT";
$res = mysql_query($sql);
if (mysql_num_rows($res) >= 1)
{
while ($row = mysql_fetch_array($res))
{
echo "$row";
}
}
else
{
echo "Nothing to show in database";
}
?>

I replaced the server info with ***** hehe.

The content of the table is really simple, I used it in some SQL lesson book:

So all I asked the script to do was show the 2 names in this table. But as I said, I seemed to have done something wrong with the connecting part. I'm pretty sure I got the username, host and password right.... looks confused

Any help is greatly appreciated 🙂

dalecosp

Well, split things out a bit, and try and get some info from the server as well:

<?php'

$conn=mysql_connect($host, $user, $pass);

if (!$conn) {
   echo "Connection failed! error was: ".mysql_error();
   exit;
} else {
   $sel=mysql_select_db($dbdb, $conn);
   if (!$sel) {
      echo "DB select failed!  error was: ".mysql_error();
   }
}
etc.
?>