Nu am obiceiul sa deschid cate un thread pentru fiecare problema, asa ca va mai cer ajutorul inca odata tot aici...
Vreau sa selectez anumite inregistrari. Am facut formularul unde selectez ce am nevoie..
Asta este codul de afisare..Cod PHP:<form method='get' action='?show=raportare'>
<div class="module_content">
<h4 class='alert_info'>Raportarea in functie de asigurator</h4>
<div class="clear"></div>
<fieldset style="width:48%; float:left;"><label>Asigurator</label>
<select style="width:92%;" name="asigurator_tag">
<option></option>
<?php
$sql="SELECT * FROM asiguratori ORDER BY asigurator_tag ASC";
$result=mysql_query($sql);
while($rows=mysql_fetch_array($result, MYSQLI_ASSOC)){
?>
<option value="<? echo $rows['asigurator_id']; ?>"><? echo $rows['asigurator_tag']; ?></option>
<?php }?>
</select>
</fieldset>
<div class="clear"></div>
<fieldset style="width:48%; float:left;"><label>Data inceput</label>
<input type="date" style="width:92%;" name="dela"></fieldset>
<fieldset style="width:48%; float:right;"><label>Data sfarsit</label>
<input type="date" style="width:92%;" name="panala"></fieldset>
<div class="clear"></div>
</div>
<footer>
<div class="submit_link">
<input type="submit" value="Afiseaza raportul" class="alt_btn">
</div>
</footer>
</form>
Asta este pagina de afisareCod PHP:<?php
include('config.php');
switch($_GET['show']){
case 'raport':include'ext/raport.php';break;
case 'raportare':include'ext/raportare.php';break;
}
?>
Cod PHP:<?php
$asigurator_id=$_POST['asigurator_id'];
$dela=$_POST['dela'];
$panala=$_POST['panala'];
$sql="SELECT * FROM polite WHERE asigurator_id=$asigurator_id AND data_emitere >= " . $dela . " AND data_emitere <= " . $panala . " ORDER by data_emitere ASC";
$result = mysql_query($sql) or die(mysql_error());
?>
+afisarea propriu-zisa
Nu imi afiseaza si nu inteleg de ce.. am incercat 400000 de variante, niciuna nu e buna, plus ca nu imi afiseaza la link ?show=raportare&asigurator_id=...., ci ?asigurator_id=...
Multumesc anticipat pentru ajutor.



Răspunde cu citat