fenway

Why are you storing arrays in the mysql field?

well, you aliased the table,and then you're not using the alias....

I don't get it... how many IP addresses will you ever be showing to the user?

what's in the links table? how is the related to the categories?

The code you have couldn't possibly be more inefficient -- you're getting back ALL rows just to query the field names! At the very least, use SHOW COLUMNS and parse the output, if you don't/can't use the I_S tables. Once you have this output, it should be trivial to push onto an array and build the query for your very strange table.

oh, i never even knew you could do it that way....

Anything is possible... you'll have to roll your own scoring.

Yes, you'd need IN, not =.

where are the commas

There is a sticky on this board that talks about this....

Great question... have you read this?

Since you know the current DAYOFWEEK() and the DAYOFWEEK() value for sunday, it's pretty easy use modulus to substract the correct number of days.

This is getting very far away from mysql...

Post a few lines from the .csv file.

Ugh... use code blocks next time. This seems like a php issue... please confirm, and I'll move it.

Did you read up on the correct syntax?

Wait a minute... why project_types? Plural? What are you storing in there? Tell me it's not an array....

Stop right now... echo $sql. We're going in circles.

Why store both? Just use INET_NTOA() to get the "printable" version... don't store IPv4 as VARCHAR.

Agreed.

You've getting funny results because you're including non-group by columns in your select list..that's a no-no.

Not sure what you mean... but it sounds lke you want a trigger.

Huh? Give an example... and the table structure.

No idea what you mean... but you can use ROUND() in mysql too.

Interesting... COALESCE() simply returns the first NON-NULL value... but IFNULL() should have always given you a NON-NULL value... werid.