Welcome Guest, Not a member yet? Register   Sign In
categories display problem show all categories
#10

(This post was last modified: 01-16-2015, 02:29 PM by asifagaria.)

This Time Error Change

my table fields is
categories table and ( id pkey ) ( name var )

and articles table ( id pkey ) ( title var ) ( category_id int )

Code:
A PHP Error was encountered

Severity: Notice

Message: Undefined variable: category_name

Filename: models/article_model.php

Line Number: 83

PHP Code:
A Database Error Occurred

Error Number
1054

Unknown column 
'DESC' in 'order clause'

SELECT `a`.*, `c`.`name` as category_name FROM (`articles` as aLEFT JOIN `categories` AS c ON `a`.`category_id` = `c`.`idORDER BY `DESCDESC

Filename
: /var/www/html/post/models/article_model.php

Line Number
92 

This Time Error Change

Please Solve My Problem

my table fields is
categories table and ( id pkey ) ( name var )

and articles table ( id pkey ) ( title var ) ( category_id int )
Reply


Messages In This Thread
RE: categories display problem show all categories - by asifagaria - 01-16-2015, 01:45 PM



Theme © iAndrew 2016 - Forum software by © MyBB