Have just taken a fresh look at the site.

Outstanding!! Well done.

Taffd

When I redesigned my site I took a few days to familiarise myself with css, mostly from w3schools. I managed in those 3 days to get a basic grasp of css and was able to design my site anew....

Hi phper,
There is only one column - 'name'.

The table is called 'names'.

Research I've done suggests this cannot be done with sql and will need to be done with php - but I can't work out how...

Hi again kkeith,
I'm not sure what you mean by array but it's academic.
This'll be a 'behind the scenes' thing. To give you the full picture:-

This is a method of choosing leaders from an...

Peter_budo,
You've slightly missed the point.
I already have what you describe. One problem with the system is that I can tell who voted which way.

At an 'official' site, a vote would need to...

kkeith29,
I have 10,000 names. I wish to put them into groups of 3 names. That is 3,333 groups with 3 names in each.
There will be 1 name left over.

In the future, each group of 3 will select 1...

Hi All,
I have a table 'names' with a column 'name'.
Using a SELECT statement I've got 10,000 randomized names.

I'd like to put them into groups of 3 and have the 1 remaining name available to...

Hi,
I have a table with 10,000 names.
I'd like to group them into groups of 3 and also display the remaining 1.
Can anybody help with a suitable query please.

Taffd

Hi All,
I run a political site that contains a voting element. It's fine as it stands but would be unacceptable as an 'official' site.
I am engaged in a project with a friend, to design a...

Thanks csgal. My apologies for mentioning the site.

Regards

Taffd

I've noticed that the page rank for << url snipped >> varies considerably when using the search query 'direct democracy'.
One of my users believes the number of times he visits the site may have an...

Have a look at the democracy sections of www.myverdict.net. Is this the sort of thing you're looking to build.

Having built the site from scratch, I can tell you exactly how I went about it.
...

It's only through using dreamweaver that I was able to understand what code was doing.

With help from the folks here at daniweb, I was then able to alter it to suit my needs and do the odd bit of...

Thanks jsmall26,
Are you saying that if the country list had been in a drop-down menu, you would have been induced to join.
Did you find it so off-putting?

It was done like that for a reason - I...

My site myverdict.net (http://www.myverdict.net) has recently been redesigned and is now effectively 245 sites, under one umbrella. There's over 75,000 areas of the site to post in, on any subject...

All it does is outputs the results in a random order.
An opening page on one of my forums will show a random 30 topics. People can get a glimpse of what's available and also see various categories...

It's ok folks, I've just cracked it.
Here's the solution

SELECT username, title, COUNT(replies.comment) AS 'count'
FROM users, topics
LEFT JOIN replies
ON topics.topicid = replies.topicID...

I've created my own forum and would like to display
username - from users table
title - form topics table and
a count of comments - from replies table

I 've got the first bit sorted ok
...

Thanks Xsimulator,
That was more than I expected. The colours and background images(did those myself), came together by accident while I was experimenting and suddenly felt right to me.
The general...

myverdict.net (http://www.myverdict.net), covers every inhabited country, many down to secondary administrative level(county). Each admin division has associated news, articles and forum section,...

Hello all,
I've just finished uploading the relaunched myverdict.net (http://www.myverdict.net).
Built from scratch, it covers every inhabited country in the world, in most cases down to county...

Here's how I'd do it.
Let's call your pages 'search' and 'results'.

On your search page list the letters A|B|C|......Z.

Make each letter a link to the results page with a unique id
<a>a...

cscgal,
All valid points. I guess I'll have to try it and see what happens. Easy enough to change

I see your point people and I agree that it's content that matters. I think the 'selling links' title might have been somewhat misleading.

In the normal course of events, article input is...

I'd like to add my wish for everybody here to have a Happy and Prosperous New Year and to thank you all for your help so far.
Best Regards
Taffd

Thanks csgal for your input. I was particularly interested in what, if any harmful effect such an idea would have.
I'm not sure that I have a problem with an advertising type article, so long as it...

Josh, here's an example from that page

//sets cookie to 1200 seconds or 20 mins
session_set_cookie_params(1200);
session_start();

josh,
According to that link, if you use "session_set_cookie_params", which you have to use on every page before session_start, you can set the time, in seconds there.

I've just looked at buddylee's link and below is a paragrph taken from the page

"By default a session lasts until the user closes their browser. This can be changed in the php.ini file by change...

Actually josh, I hadn't thought about destroying sessions or about the need for doing so. I know it took me about two weeks to figure out how to use them.

As an old fogey who generally hates computer games, I have to admit that I did have a play.

I generally don't like sites that have too much going on and having clicked on a game to try out the...

The idea is great. So great, that I've already had it. I'm transforming my existing site (http://www.myverdict.net) and the new one (http://www.myverdict.net/USA/index.php) is due for launch in a...

Thanks jt,
I've just tried moving through several sites and back to mine to see if they were maintained(I'm amazed I hadn't tried it before) and you're correct.
SESSIONS are maintained until I...

Thanks MitkOK, you've done it again.
My problem arose because I only have a text area for input. Consequently I formatted the output from my database with the str_replace equivalent of nl2br....

Is SESSION info maintained when a user is diverted to paypal?

I intend to launch a site that displays, among other things, user supplied articles. At present I have validation on all input that rejects links.

After perusing other sites that host articles, it...

Excellent MitkOK, Thanks very much.

I've just been reading a solved thread with this same title. The solution was nl2br. I was unaware of this function and have been using str_replace instead.

A problem arises however, when...

I think the problem using Nav33n's query is because of the join.
You could try this alternative.

SELECT members.username, high_schools.high_school
FROM members, high_schools
WHERE...

Happy New Year everyone.
Does anybody know how I can restrict access to a page to those users coming from a specific url.

Thanks in advance
Taffd