Implementation of the idea

Question

$q = mysql_query('SELECT `balance` FROM `users` WHERE `unic1` = "'.(int)$_SESSION['ID64'].'"');
echo $q;

Displays: Resource id #17п»ї . How to display the value?

Have you even looked at the examples in the [manual](http://uk3.php.net/mysql_query)? — Quentin, Jul 18 '14 at 08:41
You are using [an **obsolete** database API](http://stackoverflow.com/q/12859942/19068) and should use a [modern replacement](http://php.net/manual/en/mysqlinfo.api.choosing.php). — Quentin, Jul 18 '14 at 08:41

score 0 · Answer 1 · answered Jul 18 '14 at 08:41

0

You need to use mysql_fetch_assoc for example to get data.

You should also not use mysql_functions any more but mysqli or PDO

answered Jul 18 '14 at 08:41

Marcin Nabiałek

109,655
42
258
291

score 0 · Answer 2 · answered Jul 18 '14 at 08:59

0

Try with mysql_fetch_assoc like this

$q = mysql_query('SELECT `balance` FROM `users` WHERE `unic1` = '.(int)$_SESSION['ID64'].'"');
while ($row = mysql_fetch_assoc($q)) {
    echo $row["balance"];
}

answered Jul 18 '14 at 08:59

Sadikhasan

18,365
21
80
122

Sadikhasan, nothing is displayed – S C O T T I E Jul 18 '14 at 09:22
Can you post your code which you have tried my answer? – Sadikhasan Jul 18 '14 at 09:23
I posted answer here which you implemented code post in question. – Sadikhasan Jul 18 '14 at 09:39
I wrote exactly the same code as your. Sorry for bad English. – S C O T T I E Jul 18 '14 at 09:45
If you can't post your code here then I cant help further. – Sadikhasan Jul 18 '14 at 09:47
echo your query what it prints just paste in phpmyadmin and what you get just tell me – Sadikhasan Jul 18 '14 at 10:11
This - SELECT `balance` FROM `users` WHERE `jsonid` = "'.(int)$_SESSION['ID64'].'" ?? – S C O T T I E Jul 18 '14 at 10:23
What is `jsonid` you mentioned in question `unic1` in where clause – Sadikhasan Jul 18 '14 at 10:26
No, still nothing is displayed. – S C O T T I E Jul 18 '14 at 10:38
please echo your proper query and display here so i can help you according to it. – Sadikhasan Jul 18 '14 at 10:39
MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0003 sec ) – S C O T T I E Jul 18 '14 at 10:50
There is no record found that's why display empty string – Sadikhasan Jul 18 '14 at 10:51

Implementation of the idea

2 Answers2