Brtain Damage Monday
Posted: Mon Dec 08, 2003 2:25 pm
Okay would someone have a look at this and tell me why it won't work, been staring at it for hours and cannot figure out what I did.
Danke,
Saethyr
Code: Select all
<?php
function ListTechs($Location, $Search, $Search2, $Search3, $Cert, $Cert2)
{
@ $db = mysql_connect($DbPath, $DbUsername, $DbPassword);
if (!$db)
{
$ErrLevel = "Fatal";
echo "$ErrLevel Error: Database Busy, Please try again later!";
exit();
}
//Build Query Based on Input
$query = "SELECT distinct * FROM techinfo, skills, cert";
$query = $query.' WHERE techinfo.TechID=skill.TechID AND cert.TechID=skill.TechID';
if ($Location)
{
$query = $query.' AND techinfo.TechCity='$City'';
}
if ($Search)
{
$query = $query.' AND skill.SkillName LIKE '% $Search %'';
}
if ($Search2)
{
$query = $query.' AND skill.SkillName LIKE '% $Search2 %'';
}
if ($Search3)
{
$query = $query.' AND skill.SkillName LIKE '% $Search3 %'';
}
if ($Cert)
{
$query = $query.' AND cert.CertName LIKE '% $Cert %'';
}
if ($Cert2)
{
$query = $query.' AND cert.CertName LIKE '% $Cert2 %'';
}
$query = $query.' ORDER BY techinfo.TechLName ASC';
$result = mysql_query($query);
if ($result)
{
echo mysql_affected_rows().' Tech(s) Found.';
while($row=mysql_fetch_array($result) {
$TechID = $row["TechID"];
$thisFName = $row["TechFName"];
$thisLName = $row["TechLName"];
$resultskill = mysql_query("SELECT DISTINCT * FROM skills WHERE TechID='$TechID'", $db);
$resultcert = mysql_query("SELECT DISTINCT * FROM cert WHERE TechID='$TechID'", $db);
$thisSkill = mysql_num_rows($resultskill);
$thisCert = mysql_num_rows($resultcert);
echo <<<TECHLIST
<table border="1">
<tr>
<td>$thisFName $thisLName</td>
<td>$thisSkill Total Skills</td>
<td>$thisCert Total Certifications</td>
</tr>
</table>
TECHLIST;
}
}
}
?>Saethyr