Dynamically creating a table

[vmicchia]

What I want to do is create a table out of records from a table that shows an image and a radio button under the image (so I would imagine it would be in 2 rows). I want it to have 3 columns across. Here's what I have to get and output the results:

    $fabricsql = "SELECT * FROM Fabric f, Images i WHERE f.SKU = i.SKU";
        //echo $fabricsql;
        $fabricResult = mysql_query($fabricsql);
        $i=0;
        while($fabricAssoc = mysql_fetch_assoc($fabricResult)){
            //echo $fabricAssoc['SKU']. "+ ".$fabricAssoc['Name'];
            echo "<a href=\"\"><img src='../../".$fabricAssoc['ThumbPath']."' alt='".$fabricAssoc['Description']."' width='".$fabricAssoc['ThumbWidth']."' /></a><br />
             <input type=\"radio\" name=\"fabricSelect\" value='".$fabricAssoc['SKU']."' id=\"RadioGroup1_".$i."\" /><br /><br />";    
             $i++;
        }
        

 

Any help is much appreciated. I'm not even sure this is the best way to go about this so any suggestions are appreciated.

[Ninjakreborn]

I would need to get more information. From what I can tell, what you want to look into are mapping tables.

 

Mapping Table References

 

http://www.wellho.net/solutions/mysql-many-to-many-table-mapping-pivot-tables.html

[Pikachu2000]

To be clear, you're talking about building an HTML table from with the contents of a database table. correct?

[vmicchia]

Yes Pikachu200 that is exactly what I would like to do. I am sorry I was not more clear. I also want to apologize for not responding sooner I was away for the weekend with no internet access. I will check out that articles businessman332211 thank you for posting them.

[vmicchia]

I would need to get more information. From what I can tell, what you want to look into are mapping tables.

 

Mapping Table References

 

http://www.wellho.net/solutions/mysql-many-to-many-table-mapping-pivot-tables.html

 

I see where my original post was ambiguous as to what I wanted. Those a very helpful articles and I appreciate the read. However, it's not hat I was looking for. I am wanting to make HTML tables that are 3 columns wde but I am not sure how to make the width in the given while statement or really any.