(*)Count ??

[Anon]

Can anyone help me with this ()Count function. It does not work ??<?

$db = mysql_connect(\\"localhost\\",\\"user\\",\\"pass\\");
mysql_select_db(\\"database\\",$db);

$result=mysql_query(\\"select count(*) AS names from companys\\");
list($count=mysql_fetch_row($result));
print $count;

?>

Thanks

[Anon]

What's with all the \? You don't need them... They're probably what's making life difficult for you.

As a general rule, I've found that \ are only necessary when trying to write something out IE: the resulting HTML or something.

-Ben

[Anon]

its just the way I copied pasted it in. Ignore all the slashes. Its not on the site..

Here it is again

<?

$db = mysql_connect("host","username","password");
mysql_select_db("database",$db);

$result=mysql_query("select count(*) AS names from companys");
list($count=mysql_fetch_row($result));
print $count;

?>

Please :-)

[Anon]

Hi there,

Could you explain exactly what you're trying to accomplish? There could be another way to do what you're trying to do.

[Anon]

Actually, forget I asked that question. I'm not overly familiar with the DB functionality in php, but after playing around and setting up a test database I came up with this:

<?

$db = mysql_connect("hostname","username");
mysql_select_db("dbname",$db);

$result=mysql_query("select count(*) AS column_name from table_name");
list($bleah) = mysql_fetch_row($result);
print $bleah;

?>
(I originally substituted "bleah" for "count" to make sure that it wasn't a reserved word or something like that)

That returns the number of rows, is that what you were after? It was just a simple syntax thing. Check out http://au.php.net:81/manual/function.list.php

Cheers

[Anon]

Yea

That worked thankyou :-)