Kļuda

[FT3]

vai kads varetu man pateiks kas ši ir pa kļudu ?

 

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 'from, text) VALUES ('1', '1', 'aaaa')' at line 1

 

 

kods ir tads !

<?function add(){ ?>

<form action="" method="POST" >

<textarea  class="commFl" rows="8" cols="30" name="text"></textarea>
<input type="submit" name="aiziet" value="Pievienot!">

</form>
<?}

if ($_POST['aiziet']) { 

$id = $_GET['id'];
$from = $_SESSION['wID'];
$text = $_POST['text'];

if (($text != "")) { ?>

<b>Done!</b>
<?
mysql_query("INSERT INTO message (id, from, text) VALUES ('$id', '$from', '$text') ") or die(mysql_error());
}}else{add();}
?>

[Rincewind]

Raksti šitā:

INSERT INTO message (`id`, `from`, `text`) ...

[FT3]

tnx nostradaja :D

[FT3]

vel viens jautajums !

 

Parse error: syntax error, unexpected T_VARIABLE in C:\AppServ\www\includes\message.php on line 2

 

$result = mysql_query("SELECT * FROM messages WHERE to = '"$_SESSION['wID']"' ORDER by id LIMIT 1");

[Code]

'".$_SESSION['wID']."' OR '{$_SESSION['wID']}'

[waplet]

php variabļu konkatenācijas simbols ir . vai ,

'".$_SESSION['wID']."'

[briedis]

derētu arī palasīt par sql inkjekcijām (mysql_real_escape_string funkcija).

[FT3]

Kļuda

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\includes\message.php on line 4

 

kods

<?php
$result = mysql_query("SELECT * FROM messages WHERE to = '{$_SESSION['wID']}' ORDER by id LIMIT 1");

while($row = mysql_fetch_array($result))
 {
 echo $row['from'] . " " . $row['text'];
 echo "<br />";
 }
?>

[Code]

Tu te kopēsi visas kļūdas pēc kārtas, nemaz nepadomājot?

Apskaties ar mysql_error() kas notika.

Edited October 30, 2010 by Code

[FT3]

hmm uzrada šo ;/

 

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 'to = '1' ORDER by id LIMIT 1' at line 1

 

palidziet vel šo plizzz , vairs jautajumu nebus ;/

[Code]

Šito jau tev palīdzēja sākumā atrisināt - palasi te.

Edited October 30, 2010 by Code

[waplet]

ieliec to iekš ``

[FT3]

tnx waplet :))

[FT3]

ka lai ustaisa lai refresh taisitos 2 reiz ?

 

<meta http-equiv='refresh' content='javascript:location.reload(true)'>

 

 

atrisinats :D

Edited October 30, 2010 by FT3

[marcis]

waplet, komats nav php konkatenācijas simbols. Tikai punkts.

 

Topika autoram links uz dokumentāciju: http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html

Edited October 30, 2010 by marcis