[php/mysql] Nietypowy problem z pętlą while Opcje

[rafnal]

Witam,

A oto moj nietypowy problem z jakim sie borykam a
mianowicie potrzebuje pobrac jedna petla dane z tej samej tabeli
ale niestety musza byc zastosowane 2 petle
aby wyswietlic poprawnie to co potrzebuje.
Kod wyglada na chwile obecna tak:

petla 1

[PHP] pobierz, plaintext 
while (($row = mysql_fetch_array($res) != NULL) {
?>
<tr><td><p><?for($i=0;$i<10;$i++)echo $row[date][$i];?></p></td><td
align="center"><p><?=$row['ip_count']?></p></td><td
align="center"><p><?=$row2['ip_count']?></p></td></tr>
<?
}
[PHP] pobierz, plaintext 

petla 2

[PHP] pobierz, plaintext 
while (($row2 = mysql_fetch_array($res2) != NULL) {
?>
<tr><td><p><?for($i=0;$i<10;$i++)echo $row2[date][$i];?></p></td><td
align="center"><p><?=$row['ip_count']?></p></td><td
align="center"><p><?=$row2['ip_count']?></p></td></tr>
<?
}
[PHP] pobierz, plaintext 

Chce aby jedna petla wyswietlala dane. Probowalem tez zrobic petle w petli to
pobiera tylko dane z jednego zapytania a wynik drugiego wyswietla czesciowo.

[PHP] pobierz, plaintext 
<?
$res = mysql_query("SELECT COUNT(DISTINCT ip) as ip_count FROM stats
WHERE site = $site AND date >= '" . date("Ymd") . "' - $period + 1");
$row = mysql_fetch_array($res);
$total_count = $row[ip_count];
 
$res2 = mysql_query("SELECT COUNT(ip) as ip_count FROM stats WHERE
site = $site AND date >= '" . date("Ymd") . "' - $period + 1");
$row2 = mysql_fetch_array($res2);
$total_count2 = $row2[ip_count];
 
$res3 = mysql_query("SELECT date, COUNT(DISTINCT ip) as ip_count FROM
stats WHERE site = $site AND date >= '" . date("Ymd") . "' - $period +
1 GROUP BY date ORDER BY date DESC");
 
$res4 = mysql_query("SELECT date, COUNT(ip) as ip_count FROM stats
WHERE site = $site GROUP BY date ORDER BY date DESC");
 
$max = 0;
while (($row = mysql_fetch_array($res3)) != NULL) {
if ($row[ip_count] > $max)
$max = $row[ip_count];
}
while (($row2 = mysql_fetch_array($res4)) != NULL) {
if ($row2[ip_count] > $max)
$max = $row2[ip_count];
}
$st = "SELECT date, COUNT(DISTINCT ip) as ip_count FROM stats WHERE
site = $site AND date >= '" . date("Ymd") . "' - $period + 1  GROUP BY
date ORDER BY date DESC";
$res = mysql_query($st) or die(mysql_error());
$st2 = "SELECT date, COUNT(ip) as ip_count FROM stats WHERE site =
$site GROUP BY date ORDER BY date DESC";
$res2 = mysql_query($st2);
 
while (($row = mysql_fetch_array($res) != NULL) {
?>
<tr><td><p><?for($i=0;$i<10;$i++)echo $row[date][$i];?></p></td><td
align="center"><p><?=$row['ip_count']?></p></td><td
align="center"><p><?=$row2['ip_count']?></p></td></tr>
<?
}
?>
[PHP] pobierz, plaintext 

Ten post edytował rafnal 13.07.2010, 13:47:35

[krzysztof_kf]

Za pomocą mysql_fetch_array wyświetlasz poszczególne pola za pomocą numerów kolejnych a za mysql_fetch_assoc możesz się odwoływać do pól rekordów za pomocą nazwa .