query($query); $num_results = $result->num_rows; //gets how many rows are in the array echo "

Number of results found: ".$num_results."

"; //outputs the results for ($i=0; $i <$num_results; $i++) { $row = $result->fetch_assoc(); echo "

".($i+1).". ID: "; echo stripslashes($row['ID']); echo "
Specie: "; echo stripslashes($row['Specie']); echo "
Location: "; echo stripslashes($row['Location']); echo "
Date Planted: "; echo stripslashes($row['Date']); echo "
Special Designation: "; echo stripslashes($row['Designation']); echo "
Family: "; echo stripslashes($row['Family']); echo "
Genus: "; echo stripslashes($row['Genus']); echo "
Picture: "; $pic = stripslashes($row['Picture']); echo ''; echo "

"; } $result->free(); $db->close(); ?>