Search Results

Showing results 1 to 5 of 5
Search took 0.01 seconds.
Search: Posts Made By: pty ; Forum: MySQL and child forums
Forum: MySQL Sep 2nd, 2007
Replies: 2
Views: 1,072
Posted By pty
select id,
( cast(current_timestamp as date) - cast(return_date as date) ) * 3 as fine
from books
where
return_date > current_timestamp


This is how to do the select in postgresql however...
Forum: MySQL Aug 22nd, 2006
Replies: 3
Views: 42,265
Posted By pty
select *
from table
where date >= [start date] and date <= [end date]

or (i'm not 100% sure if this works in mysql but it does in postgres!)

select *
from table
where date between [start...
Forum: MySQL Jul 24th, 2006
Replies: 7
Views: 10,556
Posted By pty
No problem. I when you said 'i have two servers' I assumed you were talking about work.

If you're starting I recommend this (http://php.about.com/od/learnphp/p/learn_php_free.htm). Also, the php...
Forum: MySQL Jul 24th, 2006
Replies: 7
Views: 10,556
Posted By pty
$connection = mysql_connect(IP_ADDRESS_OF_DATABASE_SERVER:PORT_YOU_SET_MYSQL_TO_LISTEN_ON, DB_USER, DB_PASS)
or die("Query failed : " . mysql_error());
$db = mysql_select_db(DB_NAME,...
Forum: MySQL Jul 23rd, 2006
Replies: 7
Views: 10,556
Posted By pty
Just set the host parameter of the mysql_connect function to the IP address of the other server. You'll also need to open the MySQL port (3306) on the other server if it's closed
Showing results 1 to 5 of 5

 


About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC