I have very limited knowledge in php and MySQL, but I want to implement some stuff on a website I'm making. Could anyone with knowledge in php and MySQL just check if I'm going about this in the correct way, or if I'm making it way too complicated?
What I want to do is to make an event list for a band. I want them to have a private html on their site that contains a simple form. In this form you input name of the venue, link to the venue, location (town), location (country), date of the gig and time of the gig.
Here comes the php/MySQL part. I want the format displayed on the main site to be:
<Date>, <Time>
<NAME OF VENUE>, <Town>, <Country>
<Link to website of venue> (presented in "click here" format)
So the way I was thinking of doing it would be:
Create 6 different tables in a database called xxxx_events, one for every entry.
Then just call them from the main site, something like this:
Would this work?
What I want to do is to make an event list for a band. I want them to have a private html on their site that contains a simple form. In this form you input name of the venue, link to the venue, location (town), location (country), date of the gig and time of the gig.
Here comes the php/MySQL part. I want the format displayed on the main site to be:
<Date>, <Time>
<NAME OF VENUE>, <Town>, <Country>
<Link to website of venue> (presented in "click here" format)
So the way I was thinking of doing it would be:
Create 6 different tables in a database called xxxx_events, one for every entry.
Then just call them from the main site, something like this:
Code:
echo('<div class="events">
<p><b>'.$date.', '.$time.'</b></p>
<p><b>'.$venue.', '.$town.', '.$country.'</b></p>
<p><a href="'.$link.'">Click here for directions and information</a></p>
</div>');
Would this work?