[PHP-DB] Re: Date Manipulation

2004-03-21 Thread Jimmy Brock
$days = 35; $day = $day + $days; //calculate the new date $calcDate = date($output, mktime (0,0,0,$month,$day,$year)); No need for a 2nd query...jus' insert the variable $calcDate into a column in your table Hope this helps, Jimmy Brock "Shannon Doyle" <[EMAIL PROTECTED]

[PHP-DB] Re: escape characters

2004-03-22 Thread Jimmy Brock
Matt, love your show! Use the addslahses function to escape ' " \ characters. See http://php.net/addslashes for details. Jimmy Brock "Matthew Perry" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I am trying to allow my users to enter quotes in t

[PHP-DB] db query problem

2004-04-24 Thread Jimmy Brock
I'm using MS SQL Server 2000 and I have a table called tasks with the following schema: id= int identity 1 1 not null standardId= varchar(15) not null userId= varchar(15) not null status= varchar(15) not null beginDt= datetime endDate=datetime active=char(1) // flag 1=display 0=do not display I n

[PHP-DB] Re: Hi I am new

2004-04-24 Thread Jimmy Brock
Since you didn't mention what database you are using I'm assuming MySQL. Here's a good place to start: http://dev.mysql.com/tech-resources/articles/ddws/ "Water_foul" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I am new to databases and php and I was wondering if any one would p

[PHP-DB] Re: Anyone Subscibed to PHP-GTK-General?

2004-04-24 Thread Jimmy Brock
In looking at the lists available on news.php.net it seems the links to the rss and rdf are missing for php-gtk So it may not be available. <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Warning: This is OT. > > Just wondering if anyone receives emails from > [EMAIL PROTECTED] I'v

[PHP-DB] Re: Anyone Subscibed to PHP-GTK-General?

2004-04-24 Thread Jimmy Brock
Also, the last post was on 27 August 2003...so this group is probally not active. You might want to contact someone at gtk.php.net to see what going on with this newsgroup. The last I heard they were planning on a new release for gtk for php 5. <[EMAIL PROTECTED]> wrote in message news:[EMAIL PRO

[PHP-DB] Re: Using $_SESSION array for large number of variables. Any recommendations?

2004-04-25 Thread Jimmy Brock
I would recommend cookies, not session. Cookies are stored on the users machine, whereas session data is stored on the server. If you have a power failure or have to reboot the server session data will be lost -- since session data is stored in memory. "Ross Honniball" <[EMAIL PROTECTED]> wrote i