Re: [ross] foreach query

Sat, 20 Jun 2009 16:51:28 -0700

Thanks Ross - appreciated.

Re: [isdoo] foreach query

Thu, 18 Jun 2009 14:54:21 -0700

Hi there.

Thanks for posting!

Would something like this work:

Latest News

It would just output whatever you have in that field. The only thing is that you would probably want to do a quick search and replace for the "_" to turn them into space:

Latest News

foreach query

Wed, 17 Jun 2009 12:50:44 -0700

Hi all,

Can some kind person point me in the right direction.

I have some php code...

	echo "Premier League News
";
}
elseif ($news1Record['league'] == 'United_Counties_Premier'){
	echo "United Counties League News
";
}
elseif ($news1Record['league'] == 'Wessex_Premier'){
	echo "Wessex League News
";
}
elseif ($news1Record['league'] == 'Western_Premier'){
	echo "Western League News
";
}
else{
	echo "Latest News
";
}
	 ?>

Which currently goes on for some 20 odd times.

As I wish to do something similar with clubs, I do not really wish to input 1800 odd lines of code, so would like to use a foreach query to compose the code so that I can pull in various includes of external scripts (as well as the wording above, which is stored in 'leagues' database and 'league_name' table and 'leagues' database 'league_known' table.

So say....

elseif ($news1Record['league'] == 'Western_Premier'){
echo "

Western League News

";

is

elseif ($news1Record['league'] == '$record['league_name']'){
echo "

$record['league_known'] News

";

Can some kind person point me in the right direction as to how the code is written for CMS builder so that it will go to the database and pull in the information.

If I can get the above one working in code, then hopefully I can figure out the more complicated version.

If not, I will ask for a price to code it for me (but as I do not earn from the site, would like to try and do it myself if poss).

Assuming that it is even possible.

Thanks.