pandemonium7386
New member
I asked this before, but I need more answers. I am trying to output a table using a PHP script.
<?php
include("dbLogin.php");
mysql_connect(localhost,$username,$password) or die("cannot connect");
mysql_select_db($database) or die("Unable to select database");
$CDMA = mysql_real_escape_string(CDMA);
$query = mysql_query("select siteID,siteNum,siteName,siteAddress,siteCity,siteState,siteZip,siteNotes from siteTbl,sectorTbl where siteID = secSiteID and technology = $CDMA and sector = 1");
while($info = mysql_fetch_assoc($query)){
extract($info);
echo $database;}
?>
I get an error when I use this. What's wrong this code?
<?php
include("dbLogin.php");
mysql_connect(localhost,$username,$password) or die("cannot connect");
mysql_select_db($database) or die("Unable to select database");
$CDMA = mysql_real_escape_string(CDMA);
$query = mysql_query("select siteID,siteNum,siteName,siteAddress,siteCity,siteState,siteZip,siteNotes from siteTbl,sectorTbl where siteID = secSiteID and technology = $CDMA and sector = 1");
while($info = mysql_fetch_assoc($query)){
extract($info);
echo $database;}
?>
I get an error when I use this. What's wrong this code?