PHP meets SQL

I have spent over a hour trying to figure out how to sort by position but have null values displayed last.

I finally came up with 2 solutions. this will make sure column "position" sorts from 1 to max-number, after that displays all nulls (positions).

Language: SQL
SELECT * FROM some_table ORDER BY ISNULL(POSITION), POSITION ASC;
 
SELECT * FROM some_table ORDER BY COALESCE(POSITION, 99999) ASC;

if you have:

Language: SQL
SELECT * FROM some_table ORDER BY POSITION ASC;

NULLs or zeros will be displayed first.


The COALESCE function - returns the first nonnull expression among its arguments.


there are other functions that can be used, depending on which Database you are using.

Only an hour?

Just wondering why you need this?

well it is for the project I a m working on... not related to this course.

I just thought I should share... who knows someone out there might need this some day

Read this!

____________________________________________Nazi Coder____________________________________________

I'm not antisocial, I'm just not user friendly

"It's not a bug; it's an undocumented feature!" ~ some unknown Microsoft developer

Hi

My easyPHP display shows Apache and MySQL has started.

I have tried

http://127.0.0.1/mysql/

and

http://127.0.0.1/home/mysql/

in IE but both give Object not found Error 404. Has anyone any suggestions. Or is this one of those go to Chrome or Firefox.

I am a bit confused because if I use http://127.0.0.1/login.php to run my php program that is in C:\PHP\EasyPHP-12.1\www why will
http://127.0.0.1/mysql get me to C:\PHP\EasyPHP-12.1\mysql\bin.

Right click the icon and select Local web. That is the address, e.g. http:// 127.0.0.1:8887/

Also try this http://127.0.0.1:8080/

Sorry lets try this again:-

http://127.0.0.1:8080/

aaahhhhh

Put 8080 at end of 127.0.0.1: