[PHP] Create a table with more than 1 column
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\ntd\nimg src=\img/letras/$curletra.gif\
width=\24\ height=\24\\n/td\n/tr\n;
}
$row .= tda
href=\interna.php?cat=$resultado[Nome_Categoria]celebID=$resultado[CelebID
]\.$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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
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\ntd\nimg src=\img/letras/$curletra.gif\ width=\24\
height=\24\\n/td\n/tr\n;
}
$row .= tda
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 .= /trtr\n;
}
$row .= sprintf(\ntd\nimg src=\img/letras/%s.gif\ width=\24\
height=\24\\n/td,$curletra);
$row .= sprintf(tda
href=\interna.php?cat=%scelebID=%s\%s/a/td\n,urlencode($resultado[N
ome_Categoria]),urlecode($resultado[CelebI
D ]),$resultado['Nome_Artistico']) ;
}
while($counter++%30)
$row .= sprintf(tdnbsp;/tdtdnbsp;/td);
$row.=/tr;
==
Jerry Verhoef
-Original Message-
From: Miles Thompson [mailto:[EMAIL PROTECTED]]
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\ntd\nimg src=\img/letras/$curletra.gif\
width=\24\ height=\24\\n/td\n/tr\n;
}
$row .= tda
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
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.
--
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]
Re: [PHP] Create a table with more than 1 column
Rodrigo ---
This is really an SQL question, not an PHP one?
What database are you using? On what OS?
For MySQL check this link:
http://www.mysql.com/doc/A/N/ANSI_diff_SELECT_INTO_TABLE.html
If your running on a Unix server, and is something that runs on a regular
basis (say hourly or daily), you could use a simple shell script and
run it as a cron job.
Hope this helps,
David Jackson
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\ntd\nimg src=\img/letras/$curletra.gif\
width=\24\ height=\24\\n/td\n/tr\n;
}
$row .= tda
href=\interna.php?cat=$resultado[Nome_Categoria]celebID=$resultado[CelebID
]\.$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: [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]
