{"action":"created","issue":{"url":"https://api.github.com/repos/rorystandley/MySQL-CRUD-PHP-OOP/issues/17","labels_url":"https://api.github.com/repos/rorystandley/MySQL-CRUD-PHP-OOP/issues/17/labels{/name}","comments_url":"https://api.github.com/repos/rorystandley/MySQL-CRUD-PHP-OOP/issues/17/comments","events_url":"https://api.github.com/repos/rorystandley/MySQL-CRUD-PHP-OOP/issues/17/events","html_url":"https://github.com/rorystandley/MySQL-CRUD-PHP-OOP/issues/17","id":102975343,"number":17,"title":"sql query problem?","user":{"login":"alleory","id":12956690,"avatar_url":"https://avatars.githubusercontent.com/u/12956690?v=3","gravatar_id":"","url":"https://api.github.com/users/alleory","html_url":"https://github.com/alleory","followers_url":"https://api.github.com/users/alleory/followers","following_url":"https://api.github.com/users/alleory/following{/other_user}","gists_url":"https://api.github.com/users/alleory/gists{/gist_id}","starred_url":"https://api.github.com/users/alleory/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alleory/subscriptions","organizations_url":"https://api.github.com/users/alleory/orgs","repos_url":"https://api.github.com/users/alleory/repos","events_url":"https://api.github.com/users/alleory/events{/privacy}","received_events_url":"https://api.github.com/users/alleory/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":9,"created_at":"2015-08-25T08:27:01Z","updated_at":"2015-08-25T09:37:38Z","closed_at":"2015-08-25T09:36:08Z","body":"How can i use the query after your methoud??\r\n\r\nMy methoud of use\r\n$sql = \"SELECT * FROM news where id=\"$id\" LIMIT 1\";\r\n\r\nhow can i do it with this methoud???\r\n<?php\r\ninclude('class/mysql_crud.php');\r\n$db = new Database();\r\n$db->connect();\r\n$db->select('CRUDClass','id,name','name=\"Name 1\"','id DESC'); // Table name, Column Names, WHERE conditions, ORDER BY conditions\r\n$res = $db->getResult();\r\n\r\ni tried but i does not work, how you use the LIMIT????\r\n\r\n<?php\r\ninclude('class/mysql_crud.php');\r\n$db = new Database();\r\n$db->connect();\r\n$db->select('news', LIMIT 1);\r\n$res = $db->getResult();"},"comment":{"url":"https://api.github.com/repos/rorystandley/MySQL-CRUD-PHP-OOP/issues/comments/134539958","html_url":"https://github.com/rorystandley/MySQL-CRUD-PHP-OOP/issues/17#issuecomment-134539958","issue_url":"https://api.github.com/repos/rorystandley/MySQL-CRUD-PHP-OOP/issues/17","id":134539958,"user":{"login":"alleory","id":12956690,"avatar_url":"https://avatars.githubusercontent.com/u/12956690?v=3","gravatar_id":"","url":"https://api.github.com/users/alleory","html_url":"https://github.com/alleory","followers_url":"https://api.github.com/users/alleory/followers","following_url":"https://api.github.com/users/alleory/following{/other_user}","gists_url":"https://api.github.com/users/alleory/gists{/gist_id}","starred_url":"https://api.github.com/users/alleory/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alleory/subscriptions","organizations_url":"https://api.github.com/users/alleory/orgs","repos_url":"https://api.github.com/users/alleory/repos","events_url":"https://api.github.com/users/alleory/events{/privacy}","received_events_url":"https://api.github.com/users/alleory/received_events","type":"User","site_admin":false},"created_at":"2015-08-25T09:37:38Z","updated_at":"2015-08-25T09:37:38Z","body":"Yes i did it i said that i want to output all from crud_news table LIMIT 1"}}