Witam
Mam cos takiego:
[php:1:8ebe45d261]<?php
session_start();
include "./common_db.inc";
echo "<link rel=stylesheet href=style.css type=text/css>";
echo "<body bgcolor=#f0f0f0>";
include "./menu.php";
$link_id=db_connect();
$alc_t_1="SELECT count(*) FROM dane WHERE model='ALC' AND second_rekl='TAK' AND powod='1'";
$res_alc_t_1=mysql_query($alc_t_1);
$qd_alc_t_1=mysql_fetch_row($res_alc_t_1);
$alc_n_1="SELECT count(*) FROM dane WHERE model='ALC' AND second_rekl='NIE' AND powod='1'";
$res_alc_n_1=mysql_query($alc_n_1);
$qd_alc_n_1=mysql_fetch_row($res_alc_n_1);
$alc_t_2="SELECT count(*) FROM dane WHERE model='ALC' AND second_rekl='TAK' AND powod='2'";
$res_alc_t_2=mysql_query($alc_t_2);
$qd_alc_t_2=mysql_fetch_row($res_alc_t_2);
$alc_n_2="SELECT count(*) FROM dane WHERE model='ALC' AND second_rekl='TAK' AND powod='2'";
$res_alc_n_2=mysql_query($alc_n_2);
$qd_alc_n_2=mysql_fetch_row($res_alc_n_2);
$alc_t_3="SELECT count(*) FROM dane WHERE model='ALC' AND second_rekl='TAK' AND powod='3'";
$res_alc_t_3=mysql_query($alc_t_3);
$qd_alc_t_3=mysql_fetch_row($res_alc_t_3);
$alc_n_3="SELECT count(*) FROM dane WHERE model='ALC' AND second_rekl='TAK' AND powod='3'";
$res_alc_n_3=mysql_query($alc_n_3);
$qd_alc_n_3=mysql_fetch_row($res_alc_n_3);
print "<table border='1' cellpadding='0' cellspacing='0'>
<tr>
<td> </td>
<td colspan=2><b>ALC</b></td>
</tr>
<tr>
<td>Jakis tekst</td>
<td>TAK</td>
<td>NIE</td>
</tr>
<tr>
<td>Jakis tekst</td>
<td colspan=20> </td>
</tr>
<tr bgcolor=#E1E0FE>
<td align=middle><b>1</b></td>
<td>$qd_alc_t_1[0]</td>
<td>$qd_alc_n_1[0]</td>
</tr>
<tr bgcolor=#EEFDB9>
<td align=middle><b>2</b></td>
<td>$qd_alc_t_2[0]</td>
<td>$qd_alc_n_2[0]</td>
</tr>
<tr bgcolor=#E1E0FE>
<td align=middle><b>3</b></td>
<td>$qd_alc_t_3[0]</td>
<td>$qd_alc_n_3[0]</td>
</tr>
</table>";
?>[/php:1:8ebe45d261]
Chciałbym aby zapytanie było odpowienio modyfikowane i zamiast kolejno klepac:
[php:1:8ebe45d261]<?php
$alc_t_1="SELECT count(*) FROM dane WHERE model='ALC' AND second_rekl='TAK' AND powod='1'";
$res_alc_t_1=mysql_query($alc_t_1);
$qd_alc_t_1=mysql_fetch_row($res_alc_t_1);
?>[/php:1:8ebe45d261]
skorzystac np z czegos takiego + tabela mysql ze zmiennymi
[php:1:8ebe45d261]<?php
$zap="SELECT count(*) FROM dane WHERE model=$model AND second_rekl=$rekl AND powod=$powod";
$res_zap=mysql_query($zap);
$qd_zap=mysql_fetch_row($res_zap);
?>[/php:1:8ebe45d261]
np tworzy sie zmienna
$zap --> alc_t_1; alc_n_1; alc_t_2; alc_n_2; alc_t_3; alc_n_n_3 itd
$model --> ALC; COS; COS1; itd..
$rekl --> TAK; NIE
$powod--> 1;2;3;4;5;6;7;8;9
a wyniki zapytan w tabeli jak wyżej
Chciałbym jeszcze całą wynikową tabele exportować do pliku txt
Dzieki za wszelkie sugestie
POzdr