Man2u2uk

Hi All,

It's been a while since I have posted on this forum, but I thought I would see what reviews I get the for the following site that I made for my partner the other week. (I know its going to be hard to review as WordPress provided the platform and half the hard work is already done.)

http://www.rouge-mua.co.uk/blog/

I've made the above blog using WordPress and then installed a few plugins to customise every part of it down to the register/logon pages. I have also tried to apply SEO as best as I could using the yoast plugin making sure that all the page titles, alt/title tags, content, meta descriptions and tags were as appropriate as possible.

Looks like good old IE is being too strict again!
 
Your JS is telling the browser to look for the looking for value of the inputs but you haven't set any in your options lists. All the other browsers are smart enough to realise that and pick up the text instead but IE won't.
 
You'll either need to change all your options to this format:

<option value="1903">1903</option>
 
Or change the JS to pick up the text instead of the value.

Hi All,
 
I have a database containing all the places you can fly fish around the UK.
 
How can i display how many records each county has next to its name...
 
http://www.ukfishersonline.com/fly-fishery-directory.html (at the moment i just list all the countys, i would like to also display how many records i have for each county)
 
for example:
 
Hampshire (12)
Kent (15)
Bedfordshire (0)
 
Many Thanks

Thanks for replying..
 
I am using a SQL database on a linux server..
 
I am coding in PHP
 
 
I was thinking of using "count" but i thought it was depreciated

Thanks, i will give this ago when i get home....
 
I guess i then have to "echo" next to each county

Ok,
 
I managed to get the correct SQL
 

$sql = SELECT `fishery_county`, COUNT(*) FROM fishery_tbl GROUP BY `fishery_county`;
 
Which gives me exactly what i want
 
http://www.ukfishersonline.com/test.html
 
But how can i display it in two columns like so:
 
http://www.ukfishersonline.com/fly-fishery-directory.html
 
Thanks

Anyone?
 
Would i use modulus to half the rows? and make it into two columns?

At the moment on "http://www.ukfishersonline.com/fly-fishery-directory.html" i am just manually listing them in a two column table that i have customised with CSS.
 
I guess what your saying is i should have two divs. with one floating left and the other floating right, then when echoing the countys out. use an if statement to echo 10 in the 1st div and 10 in the 2nd div?
 
Thanks

What database and server-side language(s) are you using?
 
In MySQL you could use COUNT, like (not tested):
 
 

SELECT county, COUNT(*) FROM directory WHERE fly_fishing = '1' GROUP BY county;
 
It might help if you provide more specific information

as said use the count method ... e.g.
 

"SELECT row_name, COUNT(name) FROM products GROUP BY type"