Using COUNT in a JavaScript equation - help please

[melting_dog]

Hi.

 

I need to use the total count of items from a table in an equation in javascript.

 

This is as close as I have gotten:

 

$sql =  "SELECT COUNT(mailingID) FROM mailinglist";

$result = mysql_query($sql);

var sum=  "<?= $result ?>";

 

var sum returns the correct number but preceded by Resource id# (i.e. Resource id #5) and I cannot use this for equations. Any one got any ideas on how to just get the number?

 

Cheers

 

[bh]

Hi,

 

try this:

var sum=  "<?= mysql_num_rows($result); ?>";

[Mchl]

Hi,

 

try this:

var sum=  "<?= mysql_num_rows($result); ?>";

That will always return 1 however...

 

Try this instead:

 

<?php
$sql =  "SELECT COUNT(mailingID) AS cnt FROM mailinglist";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
?>

var sum=  "<?= $row['cnt'] ?>";

[bh]

Yeah i was careless. i didnt see COUNT(...

 

[melting_dog]

Thanks!

 

This worked:

<?php

$sql =  "SELECT COUNT(mailingID) AS cnt FROM mailinglist";

$result = mysql_query($sql);

$row = mysql_fetch_assoc($result);

?>

 

var sum=  parseInt  ("<?= $row['cnt'] ?>");

 

with the parseInt

 

Thanks for your help