[PHP-DB] MySQL connects to localhost via socket reguardless

I am trying to connect to a DB on a difrent server but mysql keeps connecting to the local server via the socket. What is going on? -- code snippet-- $connection = mysql_connect(mysql.meanspc.com:3306, Removed, Removed); -- Jeffrey D. Means [EMAIL PROTECTED] Owner / CIO for MeansPC

RE: [PHP-DB] MySql and PHP question

You are probably running mysql 3.x if you move to 4.x or the beta 5.x you can use subqueries and even user functions in 5.x hope this helps... On Thu, 2005-04-07 at 08:50 +0200, Juffermans, Jos wrote: Hi, I'm afraid I can't help you with the query - I'm used to Oracle which as a bigger

Re: [PHP-DB] MySQL connects to localhost via socket reguardless

Jeffrey D. Means wrote: I am trying to connect to a DB on a difrent server but mysql keeps connecting to the local server via the socket. What is going on? -- code snippet-- $connection = mysql_connect(mysql.meanspc.com:3306, Removed, Removed); Well try some debugging : $connection =

[PHP-DB] DATETIME MySQL - using only month and date

Good day to all of you --- I have a recond in my Database that is called closing and it is a DATETIME ( -MM-DD HH:MM:SS ) I would like to be able to SELECT from the DB a range of information e.x. FROM 15/02 to 17/03 Can you please tell me how the SQL query should be constructed it if we

Re: [PHP-DB] DATETIME MySQL - using only month and date

$month_start : starting month $month_end : ending month $day_start : starting day $day_end : ending day You could add something like this in the WHERE clause: ((MONTH(closing) = $month_start AND DAY(closing) = $day_start) AND (MONTH(closing) = $month_end AND DAY(closing) = $day_end)) --