Justtechjobs.com Find a programming school near you






Online Campus Both


php-general | 2001122

Re: [PHP] multicolumn table From: Andrey Hristov (ahristov <email protected>)
Date: 12/17/01

try to start the sql at a prompt
and post the error which mysql returns

Regards,
Andrey Hristov

----- Original Message -----
From: "Rodrigo Peres" <rperes <email protected>>
To: "PHP" <php-general <email protected>>
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 <email protected>
> For additional commands, e-mail: php-general-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
>
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>