PHP bug sql t.t

[Kask]

i dont know how to solve this bug...

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 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 'desc,rewards = level' at line 1' in I:\xampp\htdocs\quest\quest.php:15 Stack trace: #0 I:\xampp\htdocs\quest\quest.php(15): PDO->query('SELECT * FROM z...') #1 I:\xampp\htdocs\index.php(87): include('I:\xampp\htdocs...') #2 {main} thrown in I:\xampp\htdocs\quest\quest.php on line 15

line 15

$show = $SQL->query('SELECT * FROM z_quest_sytem WHERE level,desc,rewards = level');

SQL TABLE:

CREATE TABLE IF NOT EXISTS `z_quest_sytem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `level` char(50) DEFAULT NULL,
  `desc` char(50) DEFAULT NULL,
  `rewards` char(15) DEFAULT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ;

I dont know much from MySQL >.< i agree all critic
rep+ who's help me

 

[Diazapam]

Your trying to select all from the table z_quest_system where level and desc and rewards is the same as level.

I'm not sure what your trying to do but the query is indeed bad.

 

[Kask]

i try to make a quest system with "<from></from>" and show it with same archive.

 

[Xampy]

I neither understand what you really want

 

[Diazapam]

$show = $SQL->query('SELECT * FROM z_quest_sytem WHERE level,desc,rewards = \'level\'');

And if your trying to use a php variable use:

$show = $SQL->query('SELECT * FROM z_quest_sytem WHERE level,desc,rewards = '.$level);