Topic: problemele su Select'ais
Atsirado problema kuriant paieskos sistema. duomenu redagavime reiktu kad is DB paimtu visu 5 selectu info, paciau paima tik pirmo.(idedant ta if eilute, pagal kuri pirmame veikia, kituose jis neveikia)
<head>
<meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" />
</head>
<BODY bgcolor="CCCCCC"><br/>
<?php
session_start();
include("include.php");
// create SQL statement
$query = "SELECT * FROM bendra WHERE id=".$_POST["id"]." LIMIT 2";
// execute SQL query and get result
$sql_result = mysql_query($query) or die("Couldn't execute query.");
$one=mysql_fetch_array($sql_result);
$_SESSION['petras']=$_POST['id'];
?>
<form action="update5.php" method="post">
Duomenų redagavimas:<br/><br/>
1.Cronologinės Ribos
<select name="tipas">
<option value="">Pasirinkti</option>
<?php
$sql = "SELECT id, tipas FROM cronologija";
// execute SQL query and get result
$sql_result = mysql_query($sql) or die("Couldn't execute query.");
// put data into drop-down list box\
$option_block="";
while ($row = mysql_fetch_array($sql_result)) {
$id = $row["id"];
$pavadinimas = $row["tipas"];
if($one["cronribos"]==$pavadinimas){$sel=" selected='selected' ";}else{$sel="";}
$option_block .= "<OPTION value='$pavadinimas' $sel>$pavadinimas</OPTION>";
}
echo $option_block; ?>
</select> <br/>
2.Teminė grupė
<select name="tegrupes">
<option value="">Pasirinkti</option>
<?php
$sql = "SELECT id, tegrupes FROM teminesgrupes";
// execute SQL query and get result
$sql_result = mysql_query($sql) or die("Couldn't execute query.");
// put data into drop-down list box\
$option_block="";
while ($row = mysql_fetch_array($sql_result)) {
$id = $row["id"];
$pavadinimas = $row["tegrupes"];
$option_block .= "<OPTION value='$pavadinimas'>$pavadinimas</OPTION>";}
echo $option_block; ?>
</select> <br/>
3.Vietovė
<select name="vietove">
<option value="">Pasirinkti</option>
<?php
$sql = "SELECT id, viet FROM vietoves";
// execute SQL query and get result
$sql_result = mysql_query($sql) or die("Couldn't execute query.");
// put data into drop-down list box\
$option_block="";
while ($row = mysql_fetch_array($sql_result)) {
$id = $row["id"];
$pavadinimas = $row["viet"];
$option_block .= "<OPTION value='$pavadinimas'>$pavadinimas</OPTION>";
}
echo $option_block; ?>
</select> <br/>
4.Personalija
<select name="personos">
<option value="">Pasirinkti</option>
<?php
$sql = "SELECT id, personos FROM personalijos";
// execute SQL query and get result
$sql_result = mysql_query($sql) or die("Couldn't execute query.");
// put data into drop-down list box\
$option_block="";
while ($row = mysql_fetch_array($sql_result)) {
$id = $row["id"];
$pavadinimas = $row["personos"];
$option_block .= "<OPTION value='$pavadinimas'>$pavadinimas</OPTION>";
}
echo $option_block; ?>
</select> <br/>
5.Dokumentų tipas
<select name="doktipas">
<option value="">Pasirinkti</option>
<?php
$sql = "SELECT id, doktipas FROM dokutipas";
// execute SQL query and get result
$sql_result = mysql_query($sql) or die("Couldn't execute query.");
// put data into drop-down list box\
$option_block="";
while ($row = mysql_fetch_array($sql_result)) {
$id = $row["id"];
$pavadinimas = $row["doktipas"];
$option_block .= "<OPTION value='$pavadinimas'>$pavadinimas</OPTION>";
} echo $option_block; ?>
</select> <br/> <br/><br/>
6.Pavadinimas <input type="text" name="pav" value="<?php echo $one["pav"];?>" /><br/>
7.Dokumento data <input type="text" name="data"value="<?php echo $one["data"];?>" /> <br/><br/>
Dokumento Apskaitos duomenys:<br/>
8.GEK <input type="text" name="gek"value="<?php echo $one["gek"];?>" /> <br/>
9.I-R <input type="text" name="ir" value="<?php echo $one["ir"];?>" /><br/><br/>
Dokumento laikymo vieta: <br/>
10.Kambarys <input type="text" name="room_nr" value="<?php echo $one["room_nr"];?>"/><br/>
11.Dėžė <input type="text" name="box_nr" value="<?php echo $one["box_nr"];?>"/><br/><br/>
Aprašymas: <br/>
<textarea rows="5" cols="30" wrap="physical" name="aprasymas" "><?php echo $one["aprasymas"];?>
</textarea> <br/>
<input type='submit' value='Išsaugoti duomenis'>
</form>
<form action="admin.php" method="post">
<input type="submit" value="Grįžti atgal">
</form>
<br />
</body>
</html>