Re: multicolumn table

try to start the sql at a prompt and post the error which mysql returns Regards, Andrey Hristov ----- Original Message ----- From: "Rodrigo Peres" <rperes@mac.com> To: "PHP" <php-general@lists.php.net> Sent: Monday, December 17, 2001 4:04 PM Subject: [PHP] multicolumn table > Hi list, > > I've tried for many times, but couldn't make a table with 3 columns and n > rows > This is my code, someone please, can help in make it outputs a 3 column > table?? > > > $sql = "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"; > $query = new Query($conexao); > $query->executa($sql); > > $ultletra = ''; > $row = ''; > while($resultado = $query->dados()) { > $curletra = $resultado['letra']; > if($curletra != $ultletra) { > $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[CelebID > ]\">".$resultado['Nome_Artistico']."</a></td>\n"; > $ultletra = $curletra; > > } > > Thank's in advance > > Rodrigo Peres > -- > > > > -- > 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 > >