mozno mi mozes este raz pomoct x(. Robim administraciu, ale no nejak nejde x(. Ta ista chyba.
Kód:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'icq = "449 562 418", skype = "cervik266", omne = "" ' at line 8
Tu su spomentue subory:
Kód:
$icq = (isset($_POST['icq'])) ? trim($_POST['icq']) : '';
$skype = (isset($_POST['skype'])) ? trim($_POST['skype']) : '';
$omne = (isset($_POST['omne'])) ? ($_POST['omne']) : '';
Kód:
$query = 'UPDATE site_user u, site_user_info SET
username = "' . mysql_real_escape_string($username, $db) . '",
first_name = "' . mysql_real_escape_string($first_name, $db) . '",
last_name = "' . mysql_real_escape_string($last_name, $db) . '",
email = "' . mysql_real_escape_string($email, $db) . '",
city = "' . mysql_real_escape_string($city, $db) . '",
state = "' . mysql_real_escape_string($state, $db) . '"
icq = "' . mysql_real_escape_string($icq, $db) . '",
skype = "' . mysql_real_escape_string($skype, $db) . '",
omne = "' . mysql_real_escape_string($omne, $db) . '"
WHERE
u.user_id = ' . $user_id;
mysql_query($query, $db) or die(mysql_error());
mysql_close($db);
Kód:
$query = 'SELECT
username, first_name, last_name, email, city, state, icq, skype, omne
FROM
site_user u JOIN site_user_info i ON u.user_id = i.user_id
WHERE
u.user_id = ' . $user_id;
$result = mysql_query($query, $db) or die(mysql_error());
Kód:
<td><label for="icq">ICQ:</label></td>
<td><input type="text" name="icq" id="icq" size="20"
value="<?php echo $icq; ?>"/></td>
</tr><tr>
<td><label for="skype">Skype:</label></td>
<td><input type="text" name="skype" id="skype" size="20"
value="<?php echo $skype; ?>"/></td>
</tr><tr>
<td><label for="omne">Nieco o sebe:</label></td>
<td><textarea name="omne" id="omne" rows='10' cols='60'
<?php echo $omne; ?></textarea></td>