Specific records to specific HTML table cells

mccrie

I have a dataset of bird records, with two of the columns holding 'species' and 'grid', where 'grid' is the refs of an 8x8 grid (A1 to H8) that was mapped over a survey area.
eg. species 1 (seen in) A1
species 1 (seen in) B3
etc. for nearly 300 species.

I want to be able to retrieve the data and put a marker (eg '1') in an 8x8 HTML table, where each table cell corresponds directly to the grid ref of the record, so that in effect the table shows the bird distribution.
I can query the data and show the grid records in an HTML table in the order they appear (ie, the ORDER BY sequence), but haven't been able to get even close to a way that I can make the records go to the specific cells I need them to. Nothing that I could find through searching seems to be near what I want. Any ideas on how I can solve this?
Many thanks

Bjom

you need to create the html table dynamically in php, perhaps in a loop. then on creation of a cell, check if it is within your results, if so: mark it (make it blue or whatever you plan to do).

got any code to show

mccrie

Thanks for the reply. The table aspect works fine (without the if ... else), it's just getting the right data into the right cell that's bewildering. Code I've used is:

   

 if(isset($_POST['bird_id']))
{
   $bird_id = $_POST['bird_id'];
}

$query= "SELECT * FROM summary WHERE at_no = $bird_id GROUP BY grid";

$result = mysql_query($query);

echo "<table border='1' cellpadding='5' width='600' HEIGHT = '600'>"; 

while ($row = mysql_fetch_array($result))

{      

echo "<tr><td>"; 
if ($row['grid'] = "A1") {echo "1";} else {echo "0";}
echo "</td><td>"; 

if ($row['grid'] = "A2") {echo "1";} else {echo "0";}
echo "</td><td>"; 

if ($row['grid'] = "A3") {echo "1";} else {echo "0";}

// etc
echo "</td></tr>";
echo "</table>";

Clearly the if..else is way out, but I can't think of what it should be. 😕