[HELP] Tournament system script

[DoubleT]

Ok ill start...

im some kind a noob in PHP & SQL and i need some good programmers help...

 

My idea is to make a tournament system in my website.

 

so for first i need a page where users can add their team:

i edited the editprofile page:

 

place from editprofile where you can add team

<?
$clansql="SELECT * FROM `clan`";
  	$clanres=mysql_query($clansql);
  	$clan=mysql_fetch_object($clanres);
?>
   <p>Name:<br /><input type="text" name="clan[name]" value="<?=$clan->name;?>" /></p>
   <p>Tag:<br /><input type="text" name="clan[tag]" value="<?=$clan->tag;?>" /></p>
   <p>Country:<br /><select name="clan[valsts]"><option value="1"<?=$clan->valsts==1?' selected="selected"':'';?>>Latvia</option><option value="2"<?=$clan->valsts==2?' selected="selected"':'';?>>Estonia</option><option value="3"<?=$clan->valsts==3?' selected="selected"':'';?>>Lithuania</option></select></p>
   <input type="hidden" name="clan[kapteinis]" value="<?=$clan->kapteinis;?>">
   <input type="hidden" name="clan[kapteinis_id]" value="<?=$clan->id;?>">
   <input type="hidden" name="clan[datums]" value="<?=$clan->datums;?>">

 

and SQL part:

CREATE TABLE IF NOT EXISTS `clan` (
  `id` tinyint(1) NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  `tag` varchar(4) default NULL,
  `valsts` varchar(30) default NULL,
  `kapteinis` varchar(50) default NULL,
  `kapteinis_id` int(11) NOT NULL,
  `datums` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

 

now i need further help from you guys ;]]

 

I need to make a page tournaments.php & admin.php

 

Tournaments.php should look like this - http://cgc.lv/?q=node/2

& admin.php just simple white page where is possible to add/edit/delete tournaments

 

I thinked 3 nights but im not so good at PHP :/

 

If someone could push me in right way

 

Thanks, DoubleT

[Q695]

How much are you getting paid to do this?

[JonnoTheDev]

I would strongly recommend you going through a few tutorials before asking for help as you are a beginner. Connecting to a database, selecting, inserting and updating records is basic stuff and is covered here:

 

http://devzone.zend.com/node/view/id/627

 

Once you have aquired the skills then you should have no problem in adapting to your own website.

[DoubleT]

i got the files i need for tournament system ( clients side ) and making admin files would be not so hard ...

 

Just i i have no sql file :/

[JonnoTheDev]

Just i i have no sql file

 

What does this mean?

[Q695]

If you have no SQL file, you're going to want to create one through the PHPmyadmin (SQL browser)