Displaying values from a SQL count...

Posted on 16th Feb 2014 07:03 pm by admin

Hi,
Easy enough question i just forget the exact method ..
I have ...

Code: //count wins ...
$count_wins = mysql_query("SELECT count(*) FROM `matches`
WHERE result = 'W'
AND Player1_ID = $player1_val
AND Player2_ID = $player2_val ");


Then i want to display this :
Code: echo "<h2><b> Wins ". $count_wins . "</h2></b>" ;

But what is displayed is Wins Resource ID # 3

(or similar...)

How to i convert this php variable to a normal int?

becuase i didn't need to do this before in another query when i used to compare values .

Your Answer:

Login to answer

Other forums

Filtering for a phrase using pregmatch
Here is my code which looks for addresses which start with ' src=" '

Code: [Select]preg_

Guixt issue
Hello all,

We are experiencing the following problem with Guixt:

Some transact

* Gridview and Detailsview in UpdatePanel, insert mode problem
I have a GridView and DetailsView working together. When a record from Gridview is selected, Detail

browse folder only
hi,
is there a way i can browse or get the directory or folder only and not the file?
i just w

Why does this file not return file names that start with numbers?
This file returns a list of filenames to help populate a drop down in my form. For some reason it ig

mod_rewrite.c on windows ??
why it's not working on windows while it's working on other hosts???

this is the code i got

Mysql error message
help me find out what this error message means:

"Duplicate entry '0' for key 'PRIMARY'&q

comparing tables across databases sql refinement ideas required
Hi all

Via pl/sql I need to ensure that data between tables in different databases match

EU VAT Package 2010
Does any one know whether SAP will be developing new reporting functionality due the new VAT rules t

having probem inserting data into db table
hi

i have a table with following columns in it
Code: candidate_id, degree, cgpa, institute