Category Archives: database

Why my query is not functioning in MySQL using php?

Posted on August 2, 2010 by Alessandro Orsi

Well maybe because you are parsing a query using a wrong type of character to envelope the fields. Let’s say you have this query (it’s a query I found online, I don’t agree with the choice of the field type): $query=mysql_query(“CREATE TABLE `test` … Continue reading →

Posted in database, mysql, php | 2 Comments

Display values ordering by names that are greater than others in sql query

Posted on July 29, 2010 by Alessandro Orsi

If you have a table with some rows, say: SELECT EMPNO, JOB, SAL FROM EMP; EMPNO     JOB         SAL ———- ———-    ——— 7369   CLERK            10000 7566   MANAGER   … Continue reading →

Posted in database, sql | Comments Off

Sort null value in sql query

Posted on July 29, 2010 by Alessandro Orsi

If you have a table with some rows, say: SELECT EMPNO, JOB, SAL FROM EMP; EMPNO     JOB         SAL ———- ———-    ——— 7369   CLERK            10000 7566   MANAGER … Continue reading →

Posted in database, sql | Comments Off