php mysql beginner echo MySQL query

Question

i want to count row and print php echo. But when i echo the query it show: Resource id #5. But it must show only number 5.

<?php 
$db=require "script_database/connect.php"; 
$query="select count(name) from selection where salary>2000 and job='teacher' ";
        $key=mysql_query($query);
        echo $key;
         if(key>0)
        {

        echo "no row found";

        }
 ?>

You want to echo your query or the records ? Also never use mysql_* as it is depreciated — Sulthan Allaudeen
– Sulthan Allaudeen, Commented May 26, 2015 at 5:17
Do you want to display the count of rows affected or the count of names? — Kentot
– Kentot, Commented May 26, 2015 at 5:25
@sulthanallaudeen it's deprecated. I can't say what effect this has had on its intrinsic value — Strawberry
– Strawberry, Commented May 26, 2015 at 7:33

Community · Accepted Answer · 2020-06-20 09:12:55Z

4

mysql_query will return the resource of the executed query, not the data. You have to fetch it -

    $query="select count(name) from selection where salary>2000 and job='teacher' ";
    $result=mysql_query($query);
    $key = mysql_fetch_array($result);
    echo $key['count(name)'];

mysql is deprecated now. Use mysqli or PDO instead.

Return

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

For other type of SQL statements, INSERT, UPDATE, DELETE, DROP, etc, mysql_query() returns TRUE on success or FALSE on error.

The returned result resource should be passed to mysql_fetch_array(), and other functions for dealing with result tables, to access the returned data.

Use mysql_num_rows() to find out how many rows were returned for a SELECT statement or mysql_affected_rows() to find out how many rows were affected by a DELETE, INSERT, REPLACE, or UPDATE statement.

mysql_query() will also fail and return FALSE if the user does not have permission to access the table(s) referenced by the query.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered May 26, 2015 at 5:19

Sougata Bose

31.8k8 gold badges52 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

CyberPunkCodes Over a year ago

Would 'count(name)' be returned? Never tried, I would assign the count to a variable: select count(name) as count from selection where salary>2000 and job='teacher' .. Then echo $key['count'] -- Still doesn't get around he assigned $db to an include, and thinks that if the query returns > 0 then nothing was found..

Sougata Bose Over a year ago

If you dont use any alias then count(name) will be returned in this case.

CyberPunkCodes Over a year ago

Learn something new every day. I always have added an alias. Up-voted your answer for your extra efforts by adding the doc info. I still think he needs to fix his $db=require "script_database/connect.php"

cse14 35 Over a year ago

but i cannot say your answer use full why??

Narendrasingh Sisodia · Accepted Answer · 2015-05-26 05:24:17Z

-3

You may have to use mysql_num_rows

$query = "Select * from selection where salary>2000 and job='teacher'"

echo mysql_num_rows($query);

edited May 26, 2015 at 5:24

Narendrasingh Sisodia

21.4k6 gold badges51 silver badges54 bronze badges

answered May 26, 2015 at 5:23

Brandon Jake Sullano

3352 gold badges8 silver badges25 bronze badges

2 Comments

Sougata Bose Over a year ago

Selecting all fields for a simple count?

CyberPunkCodes Over a year ago

Down voted for 2 reasons. 1) Your answer was already answered by another member. 2) You shouldn't use SELECT *, especially since the OP specifically declares his columns.

Collectives™ on Stack Overflow

php mysql beginner echo MySQL query

2 Answers 2

4 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related