newb question

I'm a super newb to MYSQL and PHP. I figured out how to input data into a table from a form, now how do I display what's in my data base live on a website. Can this question even be answered that simply?

 

This is just a basic explanation not the proper terms.

You query the DB and tell it to find a reocrd that matchs whatever you want to display and to show those result on the screen using the echo command.

I can post an example for you later in the day. I can't just write it but I can cut and paste.

 

quick and dirty:

$query = "select * from db_table";
$result = mysql_query($result);
while($row = mysql_fetch_row($result))
{
echo $row[0] . "<br/>"; // the first column in your table.
}

PHP:

That should get you outputting text pretty quickly. You'll definately want to look into some php/mysql resources though to do more.

 

I found a website that had some codes. I got it to work, but I have a lot more stuff I want to do that is way beyond my skill level. I'm attempting to build an easy to use database for online registration for a kid's camp. I'm doing it for my own personal enrichment and to hopefully help some people out when I'm all done.

 

Sounds like a nice past-time project, and one could learn quite alot as I can imagine such a project can be expanded to a much more country wide user-base...

 

Here's a tutorial you might want to read: http://www.freewebmasterhelp.com/tutorials/phpmysql/4

 

That's actually the site where I found the code that finally worked.