Mysql query failed where everything looks fine

Question

I am executing below query in mysql but its not working. Giving following error,

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /usr/share/info/.info/php/userutil.php on line 228

This is my code:

  echo $con = mysql_connect('localhost', 'root', 'root123','qhutm');
  if(!$con){
    echo 'connection failed';
   }else{

    echo 'conn successful';
  }
    $query ="SELECT no_of_license 
             FROM Service_Master AS s,Service_Details AS d
             WHERE s.service_id=d.service_id 
             AND s.description='Internet Access' ";
    $result = mysql_query($query,$con)
    print_r($result);
    echo $result.'--pra';
    echo mysql_num_rows($result);

output

conn successful

If I echo and execute same query on mysql it works fine.
If I echo $con it gives Resource id #126

in mysql ur getting result data? – Kalpit Feb 13 '14 at 10:33 — Kalpit, Feb 13 '14 at 10:33
what is the result of print_r($query)? – marcosh Feb 13 '14 at 10:33 — marcosh, Feb 13 '14 at 10:33
use `echo mysql_error()` for debugging. – Gerald Schneider Feb 13 '14 at 10:36 — Gerald Schneider, Feb 13 '14 at 10:36

score 1 · Answer 1 · answered Feb 13 '14 at 10:34

1

Maybe if you use a normal join?

select no_of_license 
from   Service_Master as s
join   Service_Details as d on s.service_id = d.service_id 
where  s.description = 'Internet Access'

answered Feb 13 '14 at 10:34

winkbrace

2,634
24
19

Yah you got the point as fast than me – Gautam3164 Feb 13 '14 at 10:36

score 0 · Answer 2 · answered Feb 13 '14 at 10:35

0

Try with JOIN like

"SELECT no_of_license 
         FROM Service_Master AS s,
         LEFT JOIN Service_Details AS d
         ON s.service_id=d.service_id 
         WHERE s.description='Internet Access'

answered Feb 13 '14 at 10:35

Gautam3164

28,027
10
58
83

score 0 · Answer 3 · answered Feb 13 '14 at 10:37

$query ="SELECT XXXXX FROM `Service_Master` s, `Service_Details` d WHERE s.service_id=d.service_id  AND s.description='Internet Access' ";   


replace it 
and also XXXXX  if no_of_license field in Service_Master this table write  s.`no_of_license`
else if this field  is in Service_Details than write d.`no_of_license`
i think its work fine

score 0 · Answer 4 · answered Feb 13 '14 at 10:40

you have not selected the database, use mysql_select_db()

your connection should be like this

<?php

$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
    die('Not connected : ' . mysql_error());
}

$db_selected = mysql_select_db('foo', $link);
if (!$db_selected) {
    die ('Can\'t use foo : ' . mysql_error());
}
?>

score 0 · Accepted Answer · answered Feb 24 '14 at 06:21

0

You forgot to select db after creating db connection.
Please add below line after creating connection with database.

mysql_select_db('qhutm', $con);

answered Feb 24 '14 at 06:21

Praveen D

2,313
2
27
43

Mysql query failed where everything looks fine

output

5 Answers5