rpicms

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

commit b0cf21af345fa1de84f8b675091ec7a0a36650c4
parent 39abf6e2498ff611138b82684929fbf1b6735825
Author: MTRNord <mtrnord1@gmail.com>
Date:   Sun, 14 Dec 2014 11:12:28 +0100

reupdate sql strings

Diffstat:
Mcore/backend/blog/posts.php | 4++--
1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/core/backend/blog/posts.php b/core/backend/blog/posts.php @@ -60,7 +60,7 @@ if ($root_3[1] == 'core') { 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() ){ @@ -94,7 +94,7 @@ if ($root_3[1] == 'core') { function read_category(){ global $id, $category, $connection, $read, $category_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 category LIKE '$category' AND id LIKE '$id'")) { + if ($resultat = $connection->query("SELECT id,title,text,author,category,date FROM posts WHERE category LIKE '$category' AND id LIKE '$id'")) { //echo 'SELECT * FROM posts WHERE id LIKE '.$id; //Put database data in variables while($daten = $resultat->fetch_object() ){