|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
Laplink Gold 2008 - $15 Off with Coupon Code CJM9NE
|
|
#1
March 22nd, 2008, 05:12 PM
|
|||
|
|||
|
MySQL 5 - Strange issue with basic SELECT
Hi all,
Thanks in advance for any advice. I'm having a strange problem with a simple SELECT query. Basically, I want to retrieve all the entries that have a certain value on a variable. And then I'll do some other operations on them. But the weird thing is that the query is only returning one row, instead of all the rows that match the criteria. For example: $result=mysql_query("SELECT email FROM mytable WHERE sent='0'"); This will just return 1 row (running a count on the length of $result verifies this...just 1 entry being returned). Even if I do a simple SELECT * FROM mytable , only one entry is returned (and yes, there are many many more entries than just 1 in the db). I'm guessing that I'm doing something completely obvious and stupid, but am somehow overlooking it. Any thoughts would be appreciate... AK
|
|
#2
March 22nd, 2008, 06:20 PM
|
||||
|
||||
|
go to the information _schema and do
Code:
USE INFORMATION_SCHEMA; SELECT * FROM TABLES WHERE TABLE_NAME = '$table'\G In there it will say how many rows are in the table that the database sees.
__________________
life is a game.... Have fun ----------------------------- http://www.phpwomen.org strength in unity PHPCommunity IRC #phpc on freenode
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > MySQL 5 - Strange issue with basic SELECT |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
