note 28837 deleted from function.mysql-fetch-array by philip
| From: | philip@php.net | Date: | Sun, 08 Aug 2004 16:46:08 +0000 |
| Subject: | note 28837 deleted from function.mysql-fetch-array by philip | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-74249@lists.php.net to get a copy of this message | ||
Note Submitter: c.bock@qbiz.de
----
I have a small table, having only two columns (id + name). For keeping
my PHP code general, i executed the following SQL Statement:
"select name, id, 1 from tablename"
The Result was:
+----+------+---+
| id | name | 1 |
+----+------+---+
| 1 | 1 | 1 |
| 2 | 1 | 1 |
| 3 | 1 | 1 |
| 4 | 1 | 1 |
+----+------+---+
Later on, i tried the same statement with 0 instead of 1, and the id was all set to 0.
The workaraound, i found was writing "select name, id, 1 as type from tablename", which
worked fine for me.
I've checked, if mySQL delivers a correct result and it does. I have not checked, if this is a
general database problem.