View Issue Detail

ID	Project	Category	Submitted / Last Updated
01151	UserSpice	Misc	2021-02-25 06:25:45 / 2021-05-13 01:49:11
Reported	Banging Heads	Assigned To	Unassigned
Priority	none	Reported	5.2.5
Status	closed fixed	Resolution Version and Commit	5.3.1
Summary	Charts Plugin Example is Incorrect
Description	<p>The SQL Query as an example for the charts plugin is incorrect.<br /><br />$data = $db->query("SELECT username, logins FROM users LIMIT 10 ORDER BY logins DESC")->results();</p> <p>should be</p> <p>$data = $db->query("SELECT username, logins FROM users ORDER BY logins DESC LIMIT 10")->results();</p> <p> </p> <p>As limit should be applied last and the current query example will result in an error.</p> <p>The SQL Query as an example for the charts plugin is incorrect.<br /><br />$data = $db->query("SELECT username, logins FROM users LIMIT 10 ORDER BY logins DESC")->results();</p> <p>should be</p> <p>$data = $db->query("SELECT username, logins FROM users ORDER BY logins DESC LIMIT 10")->results();</p> <p> </p> <p>As limit should be applied last and the current query example will result in an error.</p>