html image in php
Posted: Sat Nov 08, 2003 5:29 pm
why is this page being pulled up blank?
[Admin Edit: tags added for clarity.][/b]
Code: Select all
<?php
//short variables
$submit = $_POST['submit'];
$username = $_POST['alias'];
$serial = $_POST['serial'];
$host = '*********';
$dbusername = '*********';
$dbpass = '*********';
$dbname = '*********';
if (!$username || !$serial)
{
echo "<table border="1">
<tr>
<td>
</td>
<td>
<img src="http://www.go-l.com/_images/error_fill_user_serial.gif">
</A></td>
</tr>
</table>
"; //End ech
}
else
{
$conn = mssql_connect($host, $dbusername, $dbpass) or die('Error: MSSQL
connection');
mssql_select_db($dbname) or die('Error: Database Selection');
$query = "SELECT * FROM support_101 where alias = '$username' AND serial =
'$serial' ";
$result = mssql_query($query) or die('Error: Query');
$num_rows = mssql_num_rows($result);
if ($num_rows > 0)
{
mssql_close($conn);
require_once 'hollywood.php';
header ('Location: http://www.go-l.com/support/hollywood.php');
}
else
{
echo 'Your username and/or serial number do not match our records. Please try again.';
exit;
}
}
$sql = "SELECT ALIAS FROM support_101 WHERE ALIAS='$ALIAS'";
$sql_result = mssql_query($sql, $connection)
or die ("Couldn't execute query.");
?>Code: Select all