TalkPHP - View Single Post

xenon · 01-06-2008, 05:09 PM

I'm going with this style (extras from a piece of code of mine, I'm too lazy to come up with something right now :D):

PHP Code:


			
$sql->select( array( 'what' => 'p.project_name',
                     'from' => 'projects p',
                     'join' => array( array( 'type' => 'left',
                                             'table' => 'ratings r',
                                             'on' => 'r.project_id=p.project_id' ) ),
                     'groupby' => 'p.project_id',
                     'orderby' => 'p.project_name ASC',
                     'where' => 'r.rating<>"NULL"' ) );

PS: what does "sz" in front of your vars stand for? I know a is for array, o for object and so on, but sz? - string perhaps?

01-06-2008, 05:09 PM	#3 (permalink)
xenon The Frequenter Join Date: Dec 2007 Location: Bucharest, Romania Posts: 438 Thanks: 3	I'm going with this style (extras from a piece of code of mine, I'm too lazy to come up with something right now :D): PHP Code: $sql->select( array( 'what' => 'p.project_name', 'from' => 'projects p', 'join' => array( array( 'type' => 'left', 'table' => 'ratings r', 'on' => 'r.project_id=p.project_id' ) ), 'groupby' => 'p.project_id', 'orderby' => 'p.project_name ASC', 'where' => 'r.rating<>"NULL"' ) ); PS: what does "sz" in front of your vars stand for? I know a is for array, o for object and so on, but sz? - string perhaps? __________________ I have optimistic thoughts, even though sometimes (if not always) life's a bitch.