inhodinky.sk, hodinky pre Vás

Užívateľ

uz si neviem rady ako spojazdnit UPDATE ACC. meno, priezvisko, a nejake veci funguju no na icq skype a O mne vypisuje stale sql chybu...vzdy vypise:

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 = "test" skype = "test" omne = "1" WHERE ' at line 7

casti kodu kde su spomenute tieto casti:

kód:

$icq = (isset($_POST['icq'])) ? trim($_POST['icq']) : '';
$skype = (isset($_POST['skype'])) ? trim($_POST['skype']) : '';
$omne = (isset($_POST['omne']));

kód:

$query = 'UPDATE site_user_info SET
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
user_id = ' . $user_id;
mysql_query($query, $db) or die(mysql_error());
mysql_close($db);
?>

kód:

$query = 'SELECT
u.user_id, 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
username = "' . mysql_real_escape_string($_SESSION['username'], $db) . '"';
$result = mysql_query($query, $db) or die(mysql_error());
$row = mysql_fetch_assoc($result);

extract($row);

mysql_free_result($result);
mysql_close($db);

Užívateľ

chýbajú ti tam čiarky

Užívateľ

dakujem moc... fakt uz som nevedel kde je chyba

Užívateľ

nemáš zač

Užívateľ

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>

Skúsený užívateľ

no ved za

kód:

state = "' . mysql_real_escape_string($state, $db) . '"

ti chyba ciarka

Užívateľ

dakujem moc... prepacte za spam.. ale proste robim vela chyb strasne... a nekedy uz fakt neviem kde

inhodinky.sk, hodinky pre Vás

SunSoft e-shop

Hodinky - zásielkový predaj

Štýlové hodinky za super ceny

Nová súťaž

Update acount