Show number of user records in table

[bruceholt]

I have been trying to show the number of records in a users table but seem to be getting nowhere! If I use:

Code: Select all

<?php echo sqlValue("select count(1) from animals"); ?>

it shows the total number of records in the table but I need to only show the number of records in the table for the logged in user.

I have tried:

Code: Select all

<?php echo sqlvalue("select count(1) from animals left join membership_userrecords on pkValue=animals.id WHERE memberID='".getLoggedMemberID()."'"); ?>

but that isn't correct either>

[jsetzer]

Code: Select all

$tn = "TABLENAME";
$count = sqlValue("SELECT count(*) FROM " . get_sql_from($tn, false, true));

[bruceholt]

Thanks Jan, How do I place that in the php echo statement?

[jsetzer]

Code: Select all

<?php
$tn = "TABLENAME";
$count = sqlValue("SELECT count(*) FROM " . get_sql_from($tn, false, true));
echo $count;
?>

or

Code: Select all

<?php echo sqlValue("SELECT count(*) FROM " . get_sql_from('TABLENAME', false, true)); ?>

[bruceholt]

Terrific! Thanks Jan. Worked perfectly.

[jsetzer]

Great, thanks for the feedback!

[bruceholt]

Hi Jan,

Sorry to bother you again. Wondering how to expand that a bit so that it can show records based on whether a field is NULL or NOT NULL.

I have tried a few different ways but it keeps throwing errors!

[jsetzer]

Code: Select all

<?php
$tn = "TABLENAME";
$count = sqlValue("SELECT count(*) FROM " . get_sql_from($tn, false, true) . " AND `field1` IS NULL AND `field2` IS NOT NULL");
echo $count;
?>

[bruceholt]

You've done it again! Works great. I really appreciate your help.
Probably helpful for others as well.

[jsetzer]

No prob, have a nice day!
Regards,
Jan