rpicms

A CMS for the Raspberry Pi
git clone git://archive.git.mtrnord.blog/RpicmsTeam/rpicms.git
Log | Files | Refs | README | LICENSE

commit a1982162d411aeedf1dfd637237c1246a50fda78
parent dc85b0ed4f9db037c14264ca24234cc38786deaf
Author: MTRNord <mtrnord1@gmail.com>
Date:   Sat, 13 Dec 2014 15:53:02 +0100

optimize sqlstring for posts

Diffstat:
Mcore/backend/blog/posts.php | 2+-
1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/core/backend/blog/posts.php b/core/backend/blog/posts.php @@ -48,7 +48,7 @@ function read_only(){ global $id, $connection, $read, $post_id_clean; global $post_id, $post_title, $post_text, $post_author, $post_date, $post_category, $post_text_short; - if ($resultat = $connection->query("SELECT * FROM posts WHERE id LIKE '$id'")) { + if ($resultat = $connection->query("SELECT id,title,text,author,category,date, FROM posts WHERE id LIKE '$id'")) { //echo 'SELECT * FROM posts WHERE id LIKE '.$id; //Put database data in variables while($daten = $resultat->fetch_object() ){