Fast efficient check

CodeCharge Studio

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

Fast efficient check

Author

Message

Mitre

Posted: 11/14/2004, 8:05 PM

I would like to do a check to see if a record exists in a table (IN PHP) using codecharges existing database structures. What is the most efficient way to test of an existance of a record.\

As in check to see if record exists in table names where name = 'foo' and get the count.

Thanks

mrachow

Posts: 509

Posted: 11/15/2004, 3:51 PM

CCDLoopUp("count(*)", "[yourTable]", "name='foo'", $yourDbConnection);

Regards,
Michael
_________________
Best regards,
Michael

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login