Tag Archive for order

snippets | February 24, 2012
No comments

Arrange MCs from Library to Stage

private function attachThumbs (anzreihe:Number, anzgesamt:Number, itemwidth:Number, itemheight:Number, margin:Number) :Void {

trace("attachThumbs");

var anzahl_reihe:Number = anzreihe;
var anzahl_gesamt:Number = anzgesamt;

var mc_breite:Number = itemwidth;
var mc_hoehe:Number = itemheight;

var abstand:Number = margin*2;

var x_wert:Number = 48;
var y_wert:Number = 248;

var x_start:Number = x_wert/2;
var y_start:Number = y_wert/2;

for (var i:Number=0; i<anzahl_gesamt; i++) {

var initObj:Object = new Object();
initObj.targetx = x_start+(i%anzahl_reihe)*(mc_breite+abstand);
initObj.targety = y_start+Math.floor(i/anzahl_reihe)*(mc_hoehe+abstand);

initObj._x = initObj.targetx;
initObj._y = initObj.targety;

initObj._alpha = 0;
initObj.count = i;

var tmpMC:MovieClip = UI.attachMovie("VideoThumb","videothumb"+i,i+3, initObj);
tmpMC.loadThumbPic(imagepath+"thumb.png");

tmpMC.alphaTo(100,1,'linear',i*0.1);
//tmpMC.tween(["_alpha","_x","_y"],[100,initObj.targetx,initObj.targety],1,'easeOutQuad',i*0.1);

}

}

source

Category: Uncategorized | Tags: , ,
snippets | February 7, 2012
No comments

Posts by month

function monthNewsList() {

$query = "SELECT COUNT(id) total, MONTHNAME(date) month, YEAR(date) year ";
$query .= "FROM news ";
$query .= "GROUP BY MONTH(date), YEAR(date) ";
$query .= "ORDER BY date ";
$result = mysql_query($query);
$count = mysql_num_rows($result);

while ($row = mysql_fetch_assoc($result)) {
echo $row["month"].' '.$row["year"].' ('.$row["total"].")<br />
";
}
mysql_free_result($result);

}

source

Category: Uncategorized | Tags: , , ,
snippets | January 22, 2012
No comments

Ordering multiple SELECT statements in a UNION

(SELECT a FROM t1 WHERE a=10 AND B=1)
UNION
(SELECT a FROM t2 WHERE a=11 AND B=2)
ORDER BY a LIMIT 10;

source

Category: Uncategorized | Tags: , , , , , , ,
snippets | January 19, 2012
No comments

Add Column After Another Column SQL

alter table `table_name` add column new_column_name float after existing_column

source

Category: Uncategorized | Tags: , ,