0) echo "
Folio Academy Courses:";
while($row = mysqli_fetch_array($result)){
$noresults="";
echo "
{$row['itemname']}";
}
$query = "SELECT * FROM contributors WHERE CONCAT(firstname, ' ', lastname) LIKE '%{$temp}%' and contribtype='a';";
$result = mysqli_query($GLOBALS['conn'],$query) ;
$coursestring="";
if (mysqli_num_rows($result)>0) echo "
Folio Academy Artists:";
while($row = mysqli_fetch_array($result)){
$noresults="";
echo "
{$row['firstname']} {$row['lastname']}";
}
$query = "SELECT * FROM mediums where (h1 LIKE '%{$temp}%') or (h2 LIKE '%{$temp}%') or (h3 LIKE '%{$temp}%') order by name";
$result = mysqli_query($GLOBALS['conn'],$query) ;
$coursestring="";
if (mysqli_num_rows($result)>0) echo "
Mediums:";
while($row = mysqli_fetch_array($result)){
$noresults="";
echo "
{$row['name']}";
}
$query = "SELECT * FROM categories where (h1 LIKE '%{$temp}%') or (h2 LIKE '%{$temp}%') or (h3 LIKE '%{$temp}%') order by name";
$result = mysqli_query($GLOBALS['conn'],$query) ;
$coursestring="";
if (mysqli_num_rows($result)>0) echo "
Categories:";
while($row = mysqli_fetch_array($result)){
$noresults="";
echo "
{$row['name']}";
}
echo $noresults;
}
?>