$n = 1;
echo ( $n == 1 ? “1st” : ( $n == 2 ? “2nd” : “” ) ) . “\n”;
// “1st”
$n = 2;
echo array_search( $n, array( ‘1st’ => 1, ‘2nd’ => 2 ) ) . “\n”;
// “2nd”

• 0 Comments

here’s how to effectively convert it to an object (stdClass) and use the object property syntax instead…
$a = array( ‘one’ => array( ‘number’ => 1, ‘ordinal’ => ‘1st’ ) );
echo $a[ ‘one’ ][ ‘number’ ] . “\n”;
$o = json_decode( json_encode( $a ) );
echo $o->one->ordinal . “\n”;

• 1 Comment

hadn’t filled in some code i was completing and within it was a sql statement of the form:
INSERT INTO TableName () VALUES ();
to my surprise, this is valid syntax, and inserted a row with a correct auto_increment for the primary key, and null or defaults for the remaining columns.

• 0 Comments

when mixing standard selects containing table aliases with LEFT JOIN’s you need be aware of a critical change as of mysql 5… if you reference a table alias in an ON clause the same way you might have in verison 4, mysql may report an ‘unknown column’ error.
so, a query of the form:
SELECT a.id FROM […]

• 13 Comments