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
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
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 =
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
$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))
--