Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given on line 189

Question

I don't know why it keeps telling me

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\Program Files (x86)\EasyPHP-DevServer-14.1VC9\data\localweb\projects\kesedar\Sara_hidup_Rumusan_Tahunan.php on line 189

This is my code:

$query_fasa =  mysql_query("SELECT kodfasa as fasa FROM peneroka_sda WHERE kodrancangan ='".$row_rancangan['kodrancangan']."' AND kodfasa!='' UNION SELECT fasa FROM kodfasa WHERE kodrancangan ='".$row_rancangan['kodrancangan']."' ORDER BY fasa ASC");
$count_fasa=mysql_num_rows($query_fasa);

**Stop** using deprecated `mysql_*` API. Use `mysqli_*`or `PDO`with prepared statements instead — Jens, Jul 28 '16 at 07:49

score 0 · Answer 1 · answered Jul 28 '16 at 07:48

0

Check that is the query correct (output the query and run it through MySQL itself), also check why the query fails by using mysql_error(). I advise you to use MySQLi or PDO instead tho.

answered Jul 28 '16 at 07:48

Janno

540
4
14

Im already put mysql_error() in my codes and it show this error: Invalid query: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (keybcs2_bin,IMPLICIT) for operation 'UNION' – Saiful Ibn Roslan Jul 28 '16 at 08:15
Your tables are using different collations. – Janno Jul 28 '16 at 08:16
So how to fix it?? – Saiful Ibn Roslan Jul 28 '16 at 08:50
http://stackoverflow.com/questions/742205/how-to-change-the-default-collation-of-a-table – Janno Jul 28 '16 at 08:54

score 0 · Answer 2 · answered Jul 28 '16 at 07:49

First, stop using mysql_* they are deprecated. Second, from the docs:

For SELECT, SHOW, DESCRIBE, EXPLAIN and other statements returning resultset, mysql_query() returns a resource on success, or FALSE on error.

Learn to read the docs and figure stuff out for yourself before posting on StackOverflow. We are all more than willing to help, but not with these kind of trivial problems.

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given on line 189

2 Answers2