Problem with query Ticket System

[jareczekjsp]

Hello Everyone ,I add to my Site(Gesior)Ticket System but I have Problem

Fatal error: Call to a member function fetch() on a non-object in C:\xampp173\xampp\htdocs\pages\helpdesk.php on line 310

$thread = $SQL->query('SELECT * FROM z_helpdesk where account = '.$acc.' and type = 1 order by id desc')->fetch();
$id_next = $SQL->query('SELECT MAX(id) FROM z_helpdesk where account = '.$acc.' and type = 1')->fetch();
$id_next = $id_next[0] + 1;

Because I dont Have Page in my phpmyadmin ,how I can add table to my sql?can somebody help me?please

 

[Mateus Robeerto]

It should work, but I'm not sure, you can give it a try.

DROP TABLE IF EXISTS `z_helpdesk`;
CREATE TABLE IF NOT EXISTS `z_helpdesk` (
  `account` varchar(255) NOT NULL,
  `type` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `text` text NOT NULL,
  `id` int(11) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `priority` int(11) NOT NULL,
  `reply` int(11) NOT NULL,
  `who` int(11) NOT NULL,
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `tag` int(11) NOT NULL,
  `registered` int(11) NOT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

 

[jareczekjsp]

Working now ,Thanks Bro for your time and help

 

[Mateus Robeerto]

glad it worked