[PHP] How to show data in one row from two rows from the database
Hi everybody
What I wrote in the subject may look complicated so I added a html file. It
explains what I have and what I want to show.
Thanks in advance
begin 666 test.html
M/%$3T-465!%($A434P@4%53$E#((M+R]7,T,O+T141!(5$U,(#0N,#$
M5')A;G-I=EO;F%L+R]%3B(^#0H\:'1M;#X-CQH96%D/T*/'1I=QE/E5N
M=ET;5D($1O8W5M96YT/]T:71L93X-CQM971A(AT=' M97%U:78](D-O
M;G1E;G0M5'EP92(8V]N=5N=#TB=5X=]H=UL.R!C:%RV5T/6ES;RTX
M.#4Y+3$B/T*/]H96%D/T*#0H\8F]D3X-CQH,SY4:ES($D:%V92!I
M;B!T:4@1%T84)AV4Z/]H,SX-CQT86)L92!W:61T:#TB-S4E(B!B;W)D
M97(](C$B/T*( \='(^#0H( /'1H/D-/54Y44ED\+W1H/T*( (#QT
M:#Y'4D]54#PO=^#0H( /'1H/E1)344\+W1H/T*( (#QT:#Y405))
M1D8\+W1H/T*( \+W1R/T*( \='(^#0H( /'1D/DE.1$E!/]T9#X-
MB ( \=0^3$]#04P\+W1D/T*( (#QT9#Y014%+/]T9#X-B ( \
M=0^,3 \+W1D/T*( \+W1R/T*( \='(^#0H( /'1D/DE.1$E!/]T
M9#X-B ( \=0^3$]#04P\+W1D/T*( (#QT9#Y/1D9014%+/]T9#X-
MB ( \=0^-3PO=0^#0H(#PO='(^#0H(#QTCX-B ( \=0^24Y$
M24$\+W1D/T*( (#QT9#XX,# \+W1D/T*( (#QT9#Y014%+/]T9#X-
MB ( \=0^,C \+W1D/T*( \+W1R/T*( \='(^#0H( /'1D/DE.
M1$E!/]T9#X-B ( \=0^.# P/]T9#X-B ( \=0^3T94$5!2SPO
M=0^#0H( /'1D/C$U/]T9#X-B /]TCX-B /'1R/T*( (#QT
M9#Y#2$E.03PO=0^#0H( /'1D/DQ/0T%,/]T9#X-B ( \=0^4$5!
M2SPO=0^#0H( /'1D/C$P/]T9#X-B /]TCX-B /'1R/T*(
M(#QT9#XN+BX\+W1D/T*( (#QT9#XN+BX\+W1D/T*( (#QT9#XN+BX\
M+W1D/T*( (#QT9#XN+BX\+W1D/T*( \+W1R/T*/]T86)L93X-CQH
M,SY4:ES($D@5V%N=!T;R!S:]W(]N('1H92!W96(.CPO:#,^#0H\=%B
M;4@=VED=](CU)2(8F]R95R/2(Q(CX-B /'1R/T*( (#QT9#Y2
M871E(9OB Z($E.1$E!/]T9#X-B ( \=0^4$5!2SPO=0^#0H(
M/'1D/D]1E!%04L\+W1D/T*( \+W1R/T*( \='(^#0H( /'1D/DQ/
M0T%,/]T9#X-B ( \=0^,3 \+W1D/T*( (#QT9#XU/]T9#X-B
M/]TCX-B /'1R/T*( (#QT9#XX,# \+W1D/T*( (#QT9#XR,#PO
M=0^#0H( /'1D/C$U/]T9#X-B /]TCX-CPO=%B;4^#0H-CPO
08F]D3X-CPO:'1M;#X-``
`
end
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] How to show data in one row from two rows from the database
From: Ing. Rajesh Kumar [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 9:36 AM
To: [EMAIL PROTECTED]
Subject: [PHP] How to show data in one row from two rows from
the database
Hi everybody
What I wrote in the subject may look complicated so I added a
html file. It
explains what I have and what I want to show.
Thanks in advance
Something like:
$sql = Select DISTINCT COUNTRY from tariffs;
$result=mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
echo Rates for {$row['COUNTRY']}br\n;
$sql = select DISTINCT GROUP from tariffs where COUNTRY='{$row['COUNTRY']}' order
by GROUP;
$result2=mysql_query($sql) or die(mysql_error();
while ($row2 = mysql_fetch_array($result)) {
$sql = select TIME,TARIFF from tariffs where COUNTRY='{$row['COUNTRY']}' and
GROUP='{$row2['GROUP']}' order by TIME DESC;
$result3=mysql_query($sql) or die(mysql_error();
$peak ='nbsp';
$offpeak = 'nbsp;';
while ($row3 = mysql_fetch_array($result3)) {
switch (strtoupper($row3['TIME'])) {
'PEAK': $peak = $row3['TARIFF'];
break;
'OFFPEAK': $offpeak = $row3['TARIFF'];
break;
}
}
echo {$row2['GROUP']} {$row3['TIME']} {$row3['TARIFF']}br\n;
}
}
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] How to show data in one row from two rows from the database
[snip]
Something like:
$sql = Select DISTINCT COUNTRY from tariffs;
$result=mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
echo Rates for {$row['COUNTRY']}br\n;
$sql = select DISTINCT GROUP from tariffs where
COUNTRY='{$row['COUNTRY']}' order by GROUP;
$result2=mysql_query($sql) or die(mysql_error();
while ($row2 = mysql_fetch_array($result)) {
$sql = select TIME,TARIFF from tariffs where
COUNTRY='{$row['COUNTRY']}' and GROUP='{$row2['GROUP']}' order by TIME
DESC;
$result3=mysql_query($sql) or die(mysql_error();
$peak ='nbsp';
$offpeak = 'nbsp;';
while ($row3 = mysql_fetch_array($result3)) {
switch (strtoupper($row3['TIME'])) {
'PEAK': $peak = $row3['TARIFF'];
break;
'OFFPEAK': $offpeak = $row3['TARIFF'];
break;
}
}
echo {$row2['GROUP']} {$row3['TIME']} {$row3['TARIFF']}br\n;
}
}
[/snip]
Actually it can be handled as a CROSSTAB query in SQL without any PHP
code(save for forming your tables). Have a look at this article,
http://www.mysql.com/articles/wizard/index.html .
HTH!
Jay
Im the man of this house and I have my wifes permission to say so
***
* Texas PHP Developers Conf Spring 2003 *
* T Bar M Resort Conference Center *
* New Braunfels, Texas*
* San Antonio Area PHP Developers Group *
* Interested? Contact [EMAIL PROTECTED] *
***
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
