fenway

I suppose it is possible... but you'll still need to get the "horizontal" pagination working first.

Huh?

DISTINCT is not what you want....

It's not hopeless... why not "massage" the data in script?

I'm sorry I don't follow... you need to count how many goals each person scored on each team?

And how can you mark this as "solved" without posting a solution?

Sorry, I don't follow.

Well, since it's easy to figure out what IP range is covered by the CIDR, assuming you stored IPv4 as UNSIGNED INT, this should be trivial with a BETWEEN.

Lots of things... but the important one is that PASSWORD() isn't for "external" use... it's only mean for the users table in the mysql database.

What does that mean??? And the code wasn't necessary...really.

Perhaps because you specified a non-left-join'ed field in COUNT()? If you provided sql statements to generate the tables & rows, I could test some other ideas on my end.

Then you want to group by the "date' part of the datetime field only, right? Try "GROUP BY DATE(date)" instead.

Don't know how you came up with "NATURAL JOIN"... Definitely *NOT* what you want. Try (with table prefixes, please!): SELECT r.referral_id, r.lname, r.fname, r.date, l.location FROM tbl_referral_info AS r INNER JOIN tbl_location AS l USING ( location_id ) order by r.lname;

Moving this to the PHP Help board...

Schema? Sample data? And * and GROUP BY are like oil & water.

PASSWORD() isn't meant to be used by anyone other than mysql... and I hope there's a salt.

probably because you're mixing CURDATE() and a TIME-based INTERVAL -- use NOW() instead.

Just insert into the user table. I really hope you mean using the appropriate commands, and not modifying the mysql tables directly...

Huh?

that's a big schema... any particular aspect you want input on?

There are countless tutorials on this subject -- and many such posts/topics here as well.

I don't understand what you mean.

You should use INT UNSIGNED -- twice the values, same price -- and the "length" field does nothing.

This is barely a mysql issue... it's php syntax.

use code tags next time... and what's the mysql question, exactly?