Kod
function ulubione($gnick) {
global $guest_tbl, $access, $PHP_SELF, $op, $goto, $id, $icon, $icon_, $itype;
global $fav1, $cmd, $aadres, $config;
global $guest_tbl, $cmd, $cmd2, $mail_tbl;//////////avat
if($cmd<>'usave') {
$query = "SELECT * FROM $guest_tbl WHERE nick='$gnick'";
$result = mysql_query($query);
$r = mysql_fetch_array($result);
$id = $r['id'];
$fav1 = $r['fav1'];
echo '<form name="form_1" method="post" action="login.php?cmd=usave">
<br><table border="0" cellspacing="3" cellpadding="0">';
echo'<tr>
<td align="right" valign="top" class="uni_01">dział</td>
<td class="next">';
echo '<select name="kanal1">
<option value="no">(wybierz kanał)</option>';
$query = "SELECT * FROM chanels ORDER BY id";
$result = mysql_query($query);
while($r = mysql_fetch_array($result)) {
$id = $r['id'];
$tid = $r['tid'];
if($tid==$fav1) {
echo '<option value="'.$id.'" selected>'.$fav1.'</option>';
} else {
echo '<option value="'.$tid.'">'.$tid.'</option>';
}
}
echo '</select></td>
</tr>
<tr>
<td align="right" class="uni_01"></td>
<td class="uni_01"> </td>
</tr>
<tr>
<td align="right" class="uni_01"> </td>
<td class="uni_01"><input style="font-weight: bold;" type="submit" name="ok" value="zapisz">
<input type="reset" name="Reset" value="domyślne"></form></td>
</tr>';
echo '</table>
</form><br>';
}
}
function update_ulubione() {
global $guest_tbl, $access, $PHP_SELF, $op, $goto, $gnick, $config;
global $name, $mail, $www, $gg, $icq, $_pass, $pass_, $kraj, $fav1, $tid, $title;
global $miej, $wiek_d, $wiek_m, $wiek_r, $pod, $guest_tbl, $cmd, $cmd2, $mail_tbl;
$qu = "SELECT * FROM $guest_tbl WHERE nick='$gnick'";
$re = mysql_query($qu);
$rs=mysql_fetch_array($re);
$query = "UPDATE $guest_tbl SET fav1='$tid' WHERE nick='$gnick'";
$result = mysql_query($query);
echo mysql_error();
echo 'Ustawienia zostały zapisane!';
}
global $guest_tbl, $access, $PHP_SELF, $op, $goto, $id, $icon, $icon_, $itype;
global $fav1, $cmd, $aadres, $config;
global $guest_tbl, $cmd, $cmd2, $mail_tbl;//////////avat
if($cmd<>'usave') {
$query = "SELECT * FROM $guest_tbl WHERE nick='$gnick'";
$result = mysql_query($query);
$r = mysql_fetch_array($result);
$id = $r['id'];
$fav1 = $r['fav1'];
echo '<form name="form_1" method="post" action="login.php?cmd=usave">
<br><table border="0" cellspacing="3" cellpadding="0">';
echo'<tr>
<td align="right" valign="top" class="uni_01">dział</td>
<td class="next">';
echo '<select name="kanal1">
<option value="no">(wybierz kanał)</option>';
$query = "SELECT * FROM chanels ORDER BY id";
$result = mysql_query($query);
while($r = mysql_fetch_array($result)) {
$id = $r['id'];
$tid = $r['tid'];
if($tid==$fav1) {
echo '<option value="'.$id.'" selected>'.$fav1.'</option>';
} else {
echo '<option value="'.$tid.'">'.$tid.'</option>';
}
}
echo '</select></td>
</tr>
<tr>
<td align="right" class="uni_01"></td>
<td class="uni_01"> </td>
</tr>
<tr>
<td align="right" class="uni_01"> </td>
<td class="uni_01"><input style="font-weight: bold;" type="submit" name="ok" value="zapisz">
<input type="reset" name="Reset" value="domyślne"></form></td>
</tr>';
echo '</table>
</form><br>';
}
}
function update_ulubione() {
global $guest_tbl, $access, $PHP_SELF, $op, $goto, $gnick, $config;
global $name, $mail, $www, $gg, $icq, $_pass, $pass_, $kraj, $fav1, $tid, $title;
global $miej, $wiek_d, $wiek_m, $wiek_r, $pod, $guest_tbl, $cmd, $cmd2, $mail_tbl;
$qu = "SELECT * FROM $guest_tbl WHERE nick='$gnick'";
$re = mysql_query($qu);
$rs=mysql_fetch_array($re);
$query = "UPDATE $guest_tbl SET fav1='$tid' WHERE nick='$gnick'";
$result = mysql_query($query);
echo mysql_error();
echo 'Ustawienia zostały zapisane!';
}
Próbuję zrobić tak aby na liście rozwijalnej formularza select opcją wybraną aktualnie była wartość z pola fav1 tabeli quest_tbl a po rozwinięciu inne wartości z pola tid tabeli chanels. Aktualizacja się nie odbywa wogóle, i pole fav zostaje nie zmienione. Ktoś ma pomysł co robię źle?
Proszę o lincz , problem rozwiązany nie mogę uwierzyć że robię takie błędy. pozdrawiam