wierd MySQL problems....
| From: | Chris Lee | Date: | Fri, 22 Dec 2000 00:10:53 +0000 |
| Subject: | wierd MySQL problems.... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-31502@lists.php.net to get a copy of this message | ||
I know this isn't a PHP problem, MySQL is giving wierd results all of a
suddend, all query's except this one work.
[root@portlee /root]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.28-gamma
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql> use cooldragons
Database changed
mysql> select * from community;
+--------------------+-------------+-----------+-------+----------------+------------+----------+
| peopleID | dragon_name | descrip | image | title | color_font | color_bg |
+--------------------+-------------+-----------+-------+----------------+------------+----------+
| 974806802083190501 | kriskringle | hey there | | Chris Web Page | | |
| 974806802083190502 | kriskringle | hey there | | Chris Web Page | | |
| 974806802083190503 | kriskringle | hey there | | Chris Web Page | | |
| 974806802083190504 | kriskringle | hey there | | Chris Web Page | | |
+--------------------+-------------+-----------+-------+----------------+------------+----------+
4 rows in set (0.00 sec)
mysql> SELECT * FROM community WHERE peopleID = '974806802083190501' ;
+--------------------+-------------+-----------+-------+----------------+------------+----------+
| peopleID | dragon_name | descrip | image | title | color_font | color_bg |
+--------------------+-------------+-----------+-------+----------------+------------+----------+
| 974806802083190501 | kriskringle | hey there | | Chris Web Page | | |
| 974806802083190502 | kriskringle | hey there | | Chris Web Page | | |
| 974806802083190503 | kriskringle | hey there | | Chris Web Page | | |
| 974806802083190504 | kriskringle | hey there | | Chris Web Page | | |
+--------------------+-------------+-----------+-------+----------------+------------+----------+
4 rows in set (0.00 sec)
mysql> describe community;
+-------------+--------------+------+-----+---------+-------+---------------------------------+
| Field | Type | Null | Key | Default | Extra | Privileges |
+-------------+--------------+------+-----+---------+-------+---------------------------------+
| peopleID | bigint(20) | YES | | NULL | | select,insert,update,references |
| dragon_name | varchar(255) | YES | | NULL | | select,insert,update,references |
| descrip | varchar(255) | YES | | NULL | | select,insert,update,references |
| image | varchar(255) | YES | | NULL | | select,insert,update,references |
| title | varchar(255) | YES | | NULL | | select,insert,update,references |
| color_font | varchar(255) | YES | | NULL | | select,insert,update,references |
| color_bg | varchar(255) | YES | | NULL | | select,insert,update,references |
+-------------+--------------+------+-----+---------+-------+---------------------------------+
7 rows in set (0.00 sec)
mysql>
any idea's ?
Chris Lee
Mediawaveonline.com