So I've got a server host that runs my MySQL 5.1 db. I have a stored procedure in it, its similar to
CREATE PROCEDURE CountUsersByFirstName(IN SearchName TEXT, OUT Count INT) BEGIN SELECT COUNT(*) INTO Count FROM Users WHERE Name = SearchName; END
the syntax of that may be off as i'm typing from memory, but I've tested the function from phpMyAdmin and it seems to work fine.
I have some software with a small user pool, maybe 50-100 people, written in c++ and I want it to be able to remotely access the database to pull information for the users to view. I've searched around and found some solutions in other languages, and some things that come close, but don't quite fulfill what I'm looking for.
Anyone have a quick and dirty example of how to do this?