-
[MySQL/PHP] forms
I'm not too sure where to start but I'm trying to create a form that will input data in a MySQL database and then having the database translated into a table to be viewed on the website. I guess you could say I'm trying to create something like the rankings on many of the CMS' for games. It's for a fishing website so the members could log what their "catch of the day" was.
I need a table that shows:
Date|Name|Fish|Weight|Place
and then all the members' catches.
I need also need a form so members can input their catches.
I know my explanation is really off but if anyone can help me, thnx!
-
re: [MySQL/PHP] forms
PHP Code:
$a = mysql_query("SELECT * FROM table ORDER BY something"); // or just select * from table
while($b = mysql_fetch_assoc($a)){
echo $b['Date'];
echo $b['Name'];
echo $b['Fish'];
echo $b['Weight'];
echo $b['Place'];
}
-
Re: [MySQL/PHP] forms
[mod]Please use a more descriptive title next time.[/mod]
-
Re: [MySQL/PHP] forms