hallo guys ,first i want to say that i`m fairly new to Php and Mysql .My problem is,i`m making a site for soccer predictions , and i want to show table standings of the leagues .First i want to ask you how i can do it to upgreade dinamycilly the tables .I created 2 tables ,one with the standing and the other with with result , i will show you the code
$sql=mysql_query('SELECT * FROM res WHERE match_id=10');

$s=mysql_query('UPDATE ')
this is not finished ,but you get the idea i will update the standing table with a lot of ifs ,the question is can i do it more simple ?
My other question is because i never uploaded site in internet ,will i have acces to my tables in mysql so i can upgrade them all the time ?