Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: billyjeffjoe
- Order by date
-
PHP MySQL query doesn't return all results
OK. If I put the db initialization in this script and go straight to it (instead of using it as an include) I get the results I expect. ------------------------ <?php $db = mysql_connect('localhost', '****', '****'); mysql_select_db('****',$db); $result = mysql_query("SELECT SourceIp FROM...- billyjeffjoe
- Post #8
- Forum: PHP
-
PHP MySQL query doesn't return all results
OK, so I tried the suggestions (thanks!) but no luck. So I cut the script down to this: -------------------------- <?php $result = mysql_query("SELECT SourceIp FROM DredgeEvent GROUP BY SourceIp ORDER BY inet_aton(SourceIP);",$db); while ($myrow = mysql_fetch_array($result)) {...- billyjeffjoe
- Post #7
- Forum: PHP
-
PHP MySQL query doesn't return all results
Yes, I tried the echo statement and pasted the output into my MySQL command line. I got all 179 rows intact. Here is my script. (Please don't laugh--I'm new and this is in the early stages...) <?php if ($OB = $_GET['OB']) { } else { $OB = 'TimeStamp DESC'; } $WidthOne='40px'...- billyjeffjoe
- Post #4
- Forum: PHP
-
PHP MySQL query doesn't return all results
I am having a wierd problem. I have a MySQL database with some data in it. When I query it from the command line, it returns 179 rows with the expected content. If I do this: $rows = mysql_num_rows($result); printf("ROWS = $rows\n"); from PHP I get 179 back. However the...- billyjeffjoe
- Thread
- Replies: 7
- Forum: PHP
