try to start the sql at a prompt
and post the error which mysql returns
Regards,
Andrey Hristov
----- Original Message -----
From: "Rodrigo Peres" <[EMAIL PROTECTED]>
To: "PHP" <[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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
