| Dtu3ZOhtln | since i'm using php, i just found mysql_num_rows...made my worries go away :) |
| Aleksey2 | or you can just use count($query) (After you assign the MySQL query to $variable) |
| chadmaynard | count the query? hopefully there is one. Thats all PHP will handle at a time |
| Aleksey2 | ? $_db_result = mysql_query("SELECT foobar FROM `table`"); $_db_total_rows = count($_db_result); |
| Dtu3ZOhtln | does that work? i was under the impression that a mysql resource object (what is returned from a mysql_query) had to be manipulated or queried with the mysql_* functions in any case, mysql_num_rows does about the same, so i'm happy :) |
| Aleksey2 | $_db_result becomes an Array of returned data If you want to count rows in performed query that would do the trick Yup :) |
| arooni | do you folks distinguish between errors and notices that you put into the flash? opops wrong channel |
| chadmaynard | Aleksey2: note the difference. Try not to give false advice. ( http://hashmysql.org/paste/viewentry.php?id=6832 ) |
| nyc-h0st | hi all, what in the world does MySQL return if there are no matching rows, i'm doing an IFNULL(column, '0') FROM table WHERE column LIKE ... |
| Aleksey2 | Perhabs it's different for MySQL, I use it under Oracle env all the time |
| nyc-h0st | aleksey u talking about my case? |
| Aleksey2 | No |
| nyc-h0st | ok |
| Aleksey2 | nyc-h0st, no rows? |
| nyc-h0st | my query returns no rows ok let me backtrack a bit i'm doing this trough php so i need to know if nothing came back |
| chadmaynard | mysql_rum_rows($resource) == 0 |
| nyc-h0st | thats what i needed thanks |
| Aleksey2 | chadmaynard what about if (empty($resource)) {} |
| firefly2442 | How big is int(11) ? |
| SilentSounD | 00000000000 it's 4 bytes and can hold from 0 to 4294967295 (unsigned) or 2147483648 to 2147483647 signed er |
| chadmaynard | firefly: or 5 bytes whether or not its null |
| SilentSounD | or -2147483648 to 2147483647 signed |
| firefly2442 | SilentSound: thank you! :) |
| SilentSounD | no problem |