Embedded C Efficincy In Redhat Linux
 

Guys,

I am 2 days old with my knowledge of C,LINUX and MYSQL. A couple of days ago, I went to computer fair and bought a 2nd hand PC with 128Meg and 2.1 Gig disk, bought a book and then installed Redhat Linux 7.3 and MYSQL.

(I am a 'professional' programmer on mini/mainframes using 'obsolete' languages, SQL and knowledge of HTML).

I want to try my hand at a test game using the MYSQL dbase. I want it to be multi-user and accessed via a browser.

Am I correct in saying that a good and efficient setup would be :

(1) Embedded MYSQL commands within a C (GCC) application program. I believe I need to link with libmysqld.a and configure mysql with --with-embedded-server option.
(2) Make this program some sort of persistent running module that is always running. Any idea of a key word I can use to read up about this ? I'm hoping this is purely a couple of lines of Linux code.
(3) Somehow get my C program to produce/interface with HTML client. Any ideas on this ? Do I need to use HTML on client browser ->PHP script on server -> C application object on server ? Good idea, bad idea ?

My books give me the syntax, but not really a feel for putting it all together.

All help gratefully received.