Re: product listing columns

Ashley Sheridan wrote: > On Wed, 2009-05-20 at 19:20 -0400, PJ wrote: > >> Ashley Sheridan wrote: >> >>> On Wed, 2009-05-20 at 17:47 -0400, PJ wrote: >>> >>> >>>> Forgot: you can get an idea of what I'm trying to do at >>>> http://www.chiccantine.com/preview.html >>>> -- >>>> Hervé Kempf: "Pour sauver la planète, sortez du >>>> capitalisme." >>>> ------------------------------------------------------------- >>>> Phil Jourdan --- pj@ptahhotep.com >>>> http://www.ptahhotep.com >>>> http://www.chiccantine.com/andypantry.php >>>> >>>> >>>> >>>> >>>> >>> The link you gave doesn't exist online, I'm getting a 404. What do you >>> mean by a list in columns? Do you want a mysql select to be output as >>> several columns of data, or one column per select? >>> >>> >> :-[ sorry bout that... should have checked - was working with my mouth >> & not my brain. >> >> It works now. I forgot to upload. >> hadn't thought about how many columns per select... ??? >> >> -- >> Hervé Kempf: "Pour sauver la planète, sortez du capitalisme." >> ------------------------------------------------------------- >> Phil Jourdan --- pj@ptahhotep.com >> http://www.ptahhotep.com >> http://www.chiccantine.com/andypantry.php >> >> >> > So you want the sql select to be dumped into a table as it exists in the > database? > > There is a simple way to do this, if you know which fields are in your > table, and that is just to use a while loop to iterate your records, and > then explicitly output each field as you want it. This is the preferred > way, and how I'd do it if I were you. > > print '<table>'; > // put column headers here > $query = "query here"; > $result = mysql_query($query); > while($row = mysql_fetch_array($result)) > { > print '<tr>'; > print "<td>{$row['field1'])</td>"; > print "<td>{$row['field2'])</td>"; > print "<td>{$row['field3'])</td>"; > // etc > print '</tr>'; > } > print '</table>'; > > Thanks, Ashley, So, you're advocating using tables... I thought it might be interesting to do the columns with <div> inline and then populate them with the query results. It worked marvellously for the navigation layout and I was able to add background and color to the product page, regardless which product page we're showing. Quite neat, really, and very simple. Anyway, I'm going to try. I must be nuts or something like glutton for punishment, but when you get it working, it's quite a satisfaction. :-) Thanks again. -- Hervé Kempf: "Pour sauver la planète, sortez du capitalisme." ------------------------------------------------------------- Phil Jourdan --- pj@ptahhotep.com http://www.ptahhotep.com http://www.chiccantine.com/andypantry.php