RE: [PHP] Create a table with more than 1 column

I would have done it a different way, but it would look something like that this code has not been tested and is guaranteed to have bugs :) but it just to get you started on a different approach. ==================================================== $ultletra = ''; $row = '<tr>'; while($resultado = $query->dados()) { $curletra = $resultado['letra']; if($counter++%3==0) { $row .= "</tr><tr>\n"; } $row .= sprintf("\n<td>\n<img src=\"img/letras/%s.gif\" width=\"24\" height=\"24\">\n</td>",$curletra); $row .= sprintf("<td><a href=\"interna.php?cat=%s&celebID=%s\">%s</a></td>\n",urlencode($resultado[N ome_Categoria]),urlecode($resultado[CelebI D ]),$resultado['Nome_Artistico']) ; } while($counter++%3>0) $row .= sprintf("<td>&nbsp;</td><td>&nbsp;</td>"); $row.="</tr>"; ================================================== Jerry Verhoef -----Original Message----- From: Miles Thompson [mailto:milesthompson@ns.sympatico.ca] Sent: Thursday, December 27, 2001 4:20 PM To: Rodrigo Peres; PHP Subject: Re: [PHP] Create a table with more than 1 column Rodrigo, Nice looking page. I'm not going to try and fix your logic, because you've approached it somewhat differently than I would. Here's my logic or pseudocode ... Set max_columns to 3 Set a letter variable While I have results While column_count is less than max_columns or letter is the same as old_letter Create a cell, fill it with data, echo it to screen Increment the column counter Set old_letter to this letter Otherwise Close the row, echo it Start a new row, echo it Reset column counter Set a letter variable That's roughly it. I've skipped putting in the cell for the letter graphic, you may want to do that in the Otherwise block. I've also skipped creation of the initial row, which would be done outside the while loop. I know this can be improved upon to make it more robust, but let's hope it gets you to your goal. Merry Christmas - Miles Thompson On Thursday 27 December 2001 10:22 am, Rodrigo Peres wrote: > Hi list, > > I am in a big trouble. My deadline is coming and I couldn't solve my > problem yet! I have this script that outputs a table that can be seen at > http://www.celebnet.com.br/abc.php > > $ultletra = ''; > $row = ''; > while($resultado = $query->dados()) { > $curletra = $resultado['letra']; > if($curletra != $ultletra) { > if (!empty($row)) { > $row .= "</tr>\n"; > } > $row .= "<tr>\n<td>\n<img > src=\"img/letras/$curletra.gif\" width=\"24\" height=\"24\">\n</td>\n</tr>\n"; > } > $row .= "<td><a > href=\"interna.php?cat=$resultado[Nome_Categoria]&celebID=$resultado[CelebI >D ]\">".$resultado['Nome_Artistico']."</a></td>\n"; > $ultletra = $curletra; > } > if (!empty($row)) { > $row .= "<tr>\n"; > } > > SQL is: > > SELECT > categorias.Nome_Categoria,celebridades.CelebID,celebridades.Nome_Artistico, > lcase(left(Nome_Artistico,1)) as letra FROM categorias LEFT JOIN > celebridades ON categorias.CategoriaID=celebridades.Categoria WHERE > CategoriaID='1' ORDER BY Nome_Artistico > > My problem is that I need to modify the script to output a 3 column table. > I have tried everything but nothing works, and I've tried also all url > about PHP that i could found. Please I'll appreciate any help. > > Thank's in advance and happy new year to all!!! > > Rodrigo Peres (Brazil) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net The information contained in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any form of disclosure, production, distribution or any action taken or refrained from in reliance on it, is prohibited and may be unlawful. Please notify the sender immediately. The content of the email is not legally binding unless confirmed by letter bearing two authorized signatures.