Sorry list,
I think, I was not clear enough. I don't have errors, what I could do with
this code is output a table in alphabetical order ex:
A
a..
ab..
B
b...
bc...
But what I really need and I couldn't make work is, my table output one name
per row and a long one singlke column, and I need a table with 3 colmns and
many rows as necessary to have all names.
Thank's
Rodrigo Peres
on 12/17/01 12:10 PM, Andrey Hristov at [EMAIL PROTECTED] wrote:
> 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]
