[SOLVED] Resource id #5 ??? Wrong

[prima]

OK, i have this kind of a problem, all seems working fine but it just displays Resource id #5  an id#6 and not the number that is in the database.


[quote]<?php
include 'connectdb.php';
session_start();

$regst="SELECT regst FROM number";  //in phpmyadmin it gives a number 4 that is correct, but here it doesn't
$rezultat = mysql_query($regst) or die("Error no reg users") ;

$onlinest="SELECT onlinest  FROM number";
$rezultat2 = mysql_query($onlinest) or die("Error no online users") ;


echo "$rezultat ";  //here should be 4
echo "$rezultat2"; //here 0


include 'closedb.php';

?>
[/quote]

[kenrbnsn]

The mysql_query function just returns a pointer to the result set. You need to use one of the mysql_fetch functions to actually get the value(s) retrieved:
[code]<?php
include 'connectdb.php';
session_start();

$regst="SELECT regst FROM number";  //in phpmyadmin it gives a number 4 that is correct, but here it doesn't
$rezultat = mysql_query($regst) or die("Error no reg users") ;
$rw = mysql_fetch_assoc($resultat); // inserted this statement
$onlinest="SELECT onlinest  FROM number";
$rezultat2 = mysql_query($onlinest) or die("Error no online users") ;
$rw2 = mysql_fetch_assoc($rezultat2); // inserted this statement

echo $rw['regst'].'<br>';  //here should be 4
echo $rw2['onlinest']; //here 0
// changed the above two statements

include 'closedb.php';

?>[/code]

Ken

[prima]

Thanks ,  :D  i see it now.