[PHP-DB] Re: Accessing Foxpro free tables using ODBC

2002-09-30 Thread John Lim
Hi Yue Teng, Right click on the directory in Explorer and change the NTFS permissions as appropriate. If you are not sure, set it to read/write Everyone. Best of luck-lah! John Yue Teng [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi John, It could be a

[PHP-DB] Re: Accessing Foxpro free tables using ODBC

2002-09-30 Thread Yue Teng
Hi John, Finally got it to work. Guess what - my .dbf files were copied from an encrypted folder and so the .dbf files remained encrypted. Decrypted the files and now the script runs fine. Now it makes sense - whoever access the web shouldn't have access to encrypted files! Thanks a million

[PHP-DB] php

2002-09-30 Thread Ramesh PAtel
Hi every one i have problem in web project use PHP I want to open commport in web project. How to read data from commport in php base web project please help me sir Bye Ramesh Patel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Problem in commport

2002-09-30 Thread Ramesh PAtel
Hi every one i have problem in web project use PHP I want to open commport in web project. How to read data from commport in php base web project please help me sir Bye Ramesh Patel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] big sessions problem - page refusing to load, but will if I skip the logonpage

2002-09-30 Thread chip . wiegand
I have a logon screen that starts a session for several other pages and it has been working great, over the weekend something happened. I checked the site from home and after login the main page would not load, just a white screen and view source showed absolutely nothing. Now I'm in the

[PHP-DB] convert 2 dates to number of hours

2002-09-30 Thread José Moreira
Hello, how can i calculate the number of hours between 2 dates, and better yet , the work hours ( example from 8.30am to 6pm excluding weekends) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] convert 2 dates to number of hours

2002-09-30 Thread Chris Boget
Hello, how can i calculate the number of hours between 2 dates, ( $unixDateTimeTo - $unixDateTimeFrom ) * 60 * 60 and better yet , the work hours ( example from 8.30am to 6pm excluding weekends) This would be more involved. Are you trying to find out how many work hours there were between

Re: [PHP-DB] convert 2 dates to number of hours

2002-09-30 Thread José Moreira
thank you for your help, i figured this out : SELECT id, to_days(t1.closedate) - to_days(t1.date) FROM tracking AS t1 ... yes i am .. whe are using the IRM http://irm.schoenefeld.org/ for internal help desk and im creating event reports ... it only makes sense to include in the

[PHP-DB] Help MySQL server has gone away

2002-09-30 Thread Anthony
ok, I have a script that takes files from a HTTP post and loads them into a mySQL database. Whenever I try to load a file greater than a meg ot two, I get mySQL error #2006, MySQL server has gone away. I checked upload_max_filesize in php.ini and that's not the problem, also MAX_FILE_SIZE

[PHP-DB] error_reporting()

2002-09-30 Thread Ryan Jameson (USA)
I do the following ?PHP error_reporting(E_ALL); echo error_reporting(); ? and it says 2047 and still reports no errors. What overrides my setting? Thanks... Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

AW: [PHP-DB] error_reporting()

2002-09-30 Thread Thomas Lamy
Do you have display_errors = On in your php.ini ? Ryan Jameson (USA) wrote: I do the following ?PHP error_reporting(E_ALL); echo error_reporting(); ? and it says 2047 and still reports no errors. What overrides my setting? Thanks... Ryan -- PHP Database Mailing List

RE: [PHP-DB] error_reporting()

2002-09-30 Thread Ryan Jameson (USA)
That looks like it's the problem. I expected the directive to override the setting, but it must work the other way around. :-\ Thanks! Ryan -Original Message- From: Hutchins, Richard [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 1:30 PM To: Ryan Jameson (USA) Subject:

[PHP-DB] Re: Mysql vs postgresql

2002-09-30 Thread gabi munteanu
I would go for postgresql. Reasons? triggers,procedures,a speed almost equal to mysql. they say mysql is faster. In my experience, only the simplest sites take advantage of this great speed. Once, in a web-page I had 2 sql queries to a Postgresql engine and I had to re-write the code for Mysql:

[PHP-DB] Re: php and fonts

2002-09-30 Thread gabi munteanu
You have to use IExplorer 4 or later and instead of a textarea where the user pastes the news you will provide him a span id=news editable=true/span or div ... or td... and in a input type=hidden name=news_text you will set the value before he submits the form: news_text.value=news.innerHTML;

Re: [PHP-DB] Flush database

2002-09-30 Thread wade
Could anyone help me to figure out how to write a piece of code that says if the time now time( ) is greater than 1 hour of the time( )then do something. I have a script that gets the time as of now and I also have the time of (lets say then) stored in a database. how would I write the code to

Re: [PHP-DB] Register Globals Question

2002-09-30 Thread Rasmus Lerdorf
Whoever told you that was wrong. It will not be deprecated, the default php.ini setting was merely changed. If you have a php.ini file and you upgrade you won't notice any change whatsoever. -Rasmus On Mon, 30 Sep 2002, Ryan Jameson (USA) wrote: I was recently told this: register_globals

RE: [PHP-DB] Register Globals Question

2002-09-30 Thread Ryan Jameson (USA)
Thank you sir. Ryan -Original Message- From: Rasmus Lerdorf [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 4:38 PM To: Ryan Jameson (USA) Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Register Globals Question Whoever told you that was wrong. It will not be deprecated, the

RE: [PHP-DB] Register Globals Question

2002-09-30 Thread MET
It is deprecated as it creates a massive security hole. However, all you have to do is change the setting in your php.ini file. Set register_globals=On. That's all. However, for all code you write from now on you should use $_POST, $_GET and the like. Read this article.

[PHP-DB] Register Globals Question

2002-09-30 Thread Ryan Jameson (USA)
I was recently told this: register_globals is a deprecated function due to security problems. It will NOT be available in the next version of PHP. As a result, the recommended way to access is with $_REQUEST[HTTP_USER_AGENT] instead. This is a joke right? I've got thousands of lines of code

[PHP-DB] Compare time functions

2002-09-30 Thread wade
Could anyone help me to figure out how to write a piece of code that says if the time now time( ) is greater than 1 hour of the time( time stored in the database) do something. I have a script that gets the time as of now and I also have the time of (lets say then) stored in a database. how

[PHP-DB] Changing colors in table?

2002-09-30 Thread Blue Tiger
Okay. Disclaimer: I am very much the newbie, so please bear with me. I have a piece of code that displays an array from a MySQL table. One field in the table is blank (and is displayed as an empty column of cells) at the moment. I want to have the blank cells display an image, value, or

[PHP-DB] Next N Interface

2002-09-30 Thread Lucas Novæ Matrix
Hello, I am trying to create a next n interface through php4, using results from a mysql query. I did this in the past easily with ColdFusion, but this time it's a bit more complicated. What I need to do basicaly is to have only 5 results per page. The first page displays the 5 results and Next

Re: [PHP-DB] Next N Interface

2002-09-30 Thread Brad Bonkoski
I did something like this with a photo gallery I made. The approach I took is the execute a query, get the number of rows, and divide that number by how ever many records I wanted on that page. Then that would give me the number of total pages I would have for my navigational links at the

RE: [PHP-DB] Changing colors in table?

2002-09-30 Thread Blue Tiger
The blank table column comes from a blank MySQL database field...(I was initially going to blob images from there to show status change). If you know of a way to eliminate the database field and still show the status of the values in a web table, please point me in the right direction. I am one

Re: [PHP-DB] Next N Interface

2002-09-30 Thread Mark Lee
How about appending LIMIT _GET[startrow],5 to the end of your query. The first parameter to LIMIT is the start position and the second is the number of rows to return. Does this help, or am I misunderstanding your question? Mark Lucas Novæ Matrix wrote: Hello, I am trying to create a

Re: [PHP-DB] Next N Interface

2002-09-30 Thread Brad Bonkoski
That would actually work for just getting a certain number of records from a query, but you would have to execute another query to figure out the navigational links he said he wants on the bottom...like google has, 1 2 3 4 5 . So, when I attacked it I figured one query is better then two even

RE: [PHP-DB] Next N Interface

2002-09-30 Thread John W. Holmes
That would actually work for just getting a certain number of records from a query, but you would have to execute another query to figure out the navigational links he said he wants on the bottom...like google has, 1 2 3 4 5 . So, when I attacked it I figured one query is better then two

Re: [PHP-DB] Changing colors in table?

2002-09-30 Thread boclair
- Original Message - From: Blue Tiger [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 10:13 AM Subject: RE: [PHP-DB] Changing colors in table? : The blank table column comes from a blank MySQL database field...(I was : initially going to blob images from there

RE: [PHP-DB] Compare time functions

2002-09-30 Thread John W. Holmes
Could anyone help me to figure out how to write a piece of code that says if the time now time( ) is greater than 1 hour of the time( time stored in the database) do something. I have a script that gets the time as of now and I also have the time of (lets say then) stored in a database.

[PHP-DB] session_destroy() problem.

2002-09-30 Thread Ryan Neudorf
Ok. What is the best way to destroy a session. I have a logout page which is supposed to destroy the session but it doesn't seem to be working. After the user logs out they are take back to the log in page, which is all fine and good. But if the user tries to go to a restricted page they are let