C API: Storing is easy; How do you retrieve?

2005-05-01 Thread Matthew Boehm
Hey guys, (Why is there no C API specific list?) I want to write a C application that can take some audio file, store it in MySQL, then at a later date/time (upon request) pull from db and write to temporary file to be streamed. I've got the storing portion of the code down. The problem I have i

Best way to access field name in C

2004-10-11 Thread Matthew Boehm
What is the best way to access a specific field in C? Its really easy in PHP... PHP --- $res = mysql_real_query($mysql,"SELECT col1, col2 FROM table"); while($row = mysql_fetch_row($res)) { print $row['col1']; print $row['col2']; } Is the only way/best way to do the above in C by usin

How Do I Determine the Server's Version on Old Server?

2004-10-08 Thread Matthew Boehm
So, how do I find the server's version that I am connected to if the function I need to use won't work on pre 4.1 and the VERSION_ID check won't work for different client-server versions? Thanks, Matthew -- -------- Matt