PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
switch($season)
{
case 1:
$result = mysql_query("SELECT id, name, koodi FROM one ORDER BY name");
break;
case 2:
$result = mysql_query("SELECT id, name, koodi FROM two ORDER BY name");
break;
case 3:
$result = mysql_query("SELECT id, name, koodi FROM three ORDER BY name");
break;
case 4:
$result = mysql_query("SELECT id, name, koodi FROM four ORDER BY name");
break;
case 5:
$result = mysql_query("SELECT id, name, koodi FROM five ORDER BY name");
break;
case 6:
$result = mysql_query("SELECT id, name, koodi FROM six ORDER BY name");
break;
case 7:
$result = mysql_query("SELECT id, name, koodi FROM seven ORDER BY name");
break;
case 8:
$result = mysql_query("SELECT id, name, koodi FROM eight ORDER BY name");
break;
case 9:
$result = mysql_query("SELECT id, name, koodi FROM nine ORDER BY name");
break;
case 10:
$result = mysql_query("SELECT id, name, koodi FROM ten ORDER BY name");
break;
case 11:
$result = mysql_query("SELECT id, name, koodi FROM eleven ORDER BY name");
break;
case 12:
$result = mysql_query("SELECT id, name, koodi FROM twelve ORDER BY name");
break;
case 13:
$result = mysql_query("SELECT id, name, koodi FROM thirteen ORDER BY name");
break;
case 14:
$result = mysql_query("SELECT id, name, koodi FROM fourteen ORDER BY name");
break;
case 15:
$result = mysql_query("SELECT id, name, koodi FROM fifteen ORDER BY name");
break;
case 16:
$result = mysql_query("SELECT id, name, koodi FROM sixteen ORDER BY name");
break;
case 17:
$result = mysql_query("SELECT id, name, koodi FROM seventeen ORDER BY name");
break;
case 18:
$result = mysql_query("SELECT id, name, koodi FROM eightteen ORDER BY name");
break;
case 19:
$result = mysql_query("SELECT id, name, koodi FROM nineteen ORDER BY name");
break;
case 20:
$result = mysql_query("SELECT id, name, koodi FROM twelve ORDER BY name");
break;
}
instead of actually performing your query within your switch, just set a string variable equal to your query then run your query at the end. Doing it this way will allow you to echo your query to determine that it really is what you think it is.
switch($season)
{
case 1:
$qry = "SELECT `id`, `name`, `koodi` FROM `one` ORDER BY `name`";
break;
case 2:
$qry = "SELECT `id`, `name`, `koodi` FROM `two` ORDER BY `name`";
break;
// ... etc
}
echo $qry;
$result = mysql_query($qry)
or die(mysql_error());
You have 19 or 20 structural identical tables and you use them for the same purpose? Why not adding a field to one table and store all the data in there?
anyway, at least reduce the redundancy in your code.
Heh, I know exactly where this code is from, i was looking at it the other day... the code should work as is... i noticed the massive duplication of the queries, but since the purpose of the code is technically illegal (see ....) i wasn't about to fix it...
Burrito: If the content is illegal, then there's no reason to post a link to it. I removed the link.
Edit: Sorry about that... The content of the site i linked to was removed due to a request from FOX, so I assumed it would be okay, but I should know what happens when you assume...