PHP Form, SQL connectivity issues, please help.

[NolanVW]

<?php

$hostname = "myhostname";
$username = "myusername";
$password = "mypassword";
$dbname = "mydbname";
$sqlConn=@mssql_connect($hostname, $username, $password);

$query = "SELECT * FROM mytable ORDER BY fname";
$result = mysql_query($query) or die ("Query failed");
//number of rows in our result for loop
$numofrows = mysql_num_rows($result);

echo "\n";
echo "First NameLast NameE-mail\n";
for($i = 0; $i < $numofrows; $i++) {
$row = mysql_fetch_array($result); //get a row from result set
if($i % 2) { //if there is a remainder
echo "\n";
} else { //if there isn't a remainder
echo "\n";
}
echo "".$row['fname']."".$row['lname']."".$row['email']."\n";
echo "\n";
}
//now let's close the table and be done with it
echo "\n";

?>

[zippee]

You have to indicate/select the database before the query is placed
[php]$dbhost = "hostname";
$dbuser = "dbuser";
$dbpass = "dbpwd";
$database = "dbname";

$sqlConn = mysql_connect($dbhost, $dbuser, $dbpass) or die ("Unable to connect!");
mysql_select_db($database) or die ("Unable to open database!");[/php]
The digit after the hostname is not necessary.

[Zachery]

Notice they are using a mssql connection, not mysql, they may need to specify the port to make a connection, depending on the MS SQL server is configured.

[NolanVW]

Notice they are using a mssql connection, not mysql, they may need to specify the port to make a connection, depending on the MS SQL server is configured.

yep....just realized that and got it straightened out with our hosting company. Just had to switch from SQL Server to MySQL since it was originally set up with SQL server....thanks for the help everyone.

[phper]

The 4 digits after the hostname are the port number