select count(*) value *resolved*

PHP Code:

---

$countquery="SELECT COUNT(*) FROM guestbook";

$pagecount=mysql_query($countquery); 


---

Now that the query has been executed, how can I access the value of the number returned by the countquery?

I do an echo $pagecount, and it returns to me:

Quote:

---

Resource id #3

---

I'm not sure, but I do know another way to do it:

Code:

---

$countquery="SELECT * FROM guestbook";

$pagecount=mysql_num_rows(mysql_query($countquery));

---

I just gave this a try, and it works:

Code:

---

$countquery="SELECT COUNT(*) FROM guestbook";
$pagecount=mysql_query($countquery);

$count = mysql_fetch_row($pagecount);

echo $count[0];

---

most of the time when you do count(*) you do it like so

PHP Code:

---

$countquery="select count(*) AS total from guestbook

$pagecount=mysql_query($countquery);
$result = mysql_fetch_array($pagecount);

echo $result["total"]; 


---

that will echo out the total rows. but in your situation you can't echo out the query becasue you haven't fetched anything yet.

echo mysql_query("SELECT * FROM guestbook");

that will do the samething you have in the first post. it will return resource ID#

Hi, thanks for the responses. They did work, but I was playing around and I used this:

$somethingelse=mysql_result($pagecount,0);


Is this acceptable as well?

not really. mysql_reuslts() is slower then anything else and deprecated.