Jump to content

[SOLVED] Does anyone see anything wrong with this script?


DeepakJ

Recommended Posts

I get no error messages but nothing happens, this script used to work fine. I am completely lost.

 

<html><head><title>AlibreCam Verification System</title></head>

<center><h3>AlibreCam Verification System</h3></center>

<center><TABLE border=0 cellpadding=3><form name="input" action="verification.php" method="get">
<tr><td><center>Customer ID:</center></td>
<td><input type="text" name="user"></td></tr>
<tr><td colspan=2><center><input type="submit" value="Submit"></center></td></tr>
</form><br></table><br>

<?php 
$hostname = "mysql123.hosting.earthlink.net";
$username = "licensinginfo";
$password = "98989lol";
$dbname = "licensinginfo";

$customerid = $_GET['user'];
mysql_connect($hostname, $username, $password) or DIE("Unable to connect to MySQL server $hostname");
$selected = mysql_select_db($dbname) or DIE("Could not select requested db $dbname");

if ($customerid == ""){
echo "Please enter a customer name";
}else{

$query = "SELECT * FROM invoiceid WHERE customerid='$customerid'";
$cResult = mysql_query($query) or die("could not query");

while($row=mysql_fetch_array($cResult)){
$value=$value+$row['numoflicenses'];
}

echo "Total number of licenses purchased: ".$value; 

}
?>
</html>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.