[PHP-DB] error handling with ms sql server (mssql) - insert and update unique indexes

2002-08-28 Thread Heiko Mundle
sorry for posting this mail twice, but the first one doesn't appear on the news server (posting with google, doesn't work...) Hi, when I insert a new record with a unique indexed attribute, which is already in the table, I only get some php warnings: Warning: MS SQL message: Cannot insert

[PHP-DB] htdig interface class

2002-08-28 Thread olinux
http://phpclasses.promoxy.com/browse.html/package/26.html Anyone tried this package - successfully? I have only been able to pull up No results. I spent the past 10 hours trying to find/write a wrapper for htdig that will call htsearch mutliple times with different options (specifically

[PHP-DB] scope of variables in php script

2002-08-28 Thread Smita Manohar
im accepting input using form (method post). the variables which are passed thru post method are available in the file whitch i specify for action. but i want those variables in other file. how to make them global to be accessed from any file?? thnx and regds, smita

[PHP-DB] Reload the page without losing variables

2002-08-28 Thread Achilleas Maroulis
Hi. I have a little problem concerning passing variables or reloading the page. I have a search fom page (search.php) which POSTS some variables to another page displaying the results (results.php). What I want to do is to let the users change the order of appearance in the last page. I

Re: [PHP-DB] scope of variables in php script

2002-08-28 Thread Jason Wong
On Wednesday 28 August 2002 19:23, Smita Manohar wrote: im accepting input using form (method post). the variables which are passed thru post method are available in the file whitch i specify for action. but i want those variables in other file. how to make them global to be accessed from any

[PHP-DB] MySQL Database Connection Error ?

2002-08-28 Thread R Strang
i have a simple guest book script from a book by jay greenspan i think , when i run seems oikay i fill in the form and click submit, after submitting iam getting this error ? PHP Warning: Failed opening 'dbconnect.php' for inclusion (include_path='c:\php\includes') in

RE: [PHP-DB] how to display tree structure from database??? [ NEW VERSION]

2002-08-28 Thread José Moreira
adapted to your database ... for errors and more information .. let me know ? # Simple function 2 create an indentation according to the level/depth of the tree node function PrintNode ( $level , $text) { # função para imprimir um nó e fazer o indentamento if ( $level == 0 ) {

Re: [PHP-DB] MySQL Database Connection Error ?

2002-08-28 Thread Jason Wong
On Wednesday 28 August 2002 20:48, R Strang wrote: i have a simple guest book script from a book by jay greenspan i think , when i run seems oikay i fill in the form and click submit, after submitting iam getting this error ? PHP Warning: Failed opening 'dbconnect.php' for inclusion

[PHP-DB] Can subject in mail function be set in charset=big5?

2002-08-28 Thread Ellen O'Neal
I have sent an email using mail function in which the subject and email body have charset=big5 and they are generated by mysql statement. Customers with outlook express can read the big5 chinese characters without any trouble. However, people who read their emails from Lotus Notes complain

[PHP-DB] A Doubt

2002-08-28 Thread Manoj Japher
hi, I have a question. Hoping someone may help me out. Can a PHP page say file abcd.php access a variable $xyz which is used in another file mnop.php? I mean can I refer to a variable whose value has been set in some other file. The point is that the file mnop.php after finishing its

Re: [PHP-DB] A Doubt

2002-08-28 Thread Bas Jobsen
Hi, The reason is, I need to check everytime the file abcd.php is loaded, I should be able to determine that it was loaded by mnop.php If you include abcd.php in mnop.php $_SERVER['SCRIPT_NAME'] equals /mnop.php for both scripts. So you can test in abcd.php for this. -- PHP

[PHP-DB] Date difference

2002-08-28 Thread José Moreira
hello how can i calculate the difference in days between 2 dates in SQL or PHP ?

[PHP-DB] Re: convert mysql table to Excell or Access file

2002-08-28 Thread simon
Try the 'free' PC program called MySQL-Front from http://www.anse.de/mysqlfront/index.php It has a nice function for exporting to Excel. simon Alex Shi [EMAIL PROTECTED] skrev i meddelandet [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Can MySQL table be converted to Access or Excell format?

Re: [PHP-DB] A Doubt

2002-08-28 Thread Bas Jobsen
Hi Manoj, Your reply adrress seems to be wrong: - The following addresses had permanent fatal errors - [EMAIL PROTECTED] (reason: 553 sorry, your envelope sender is in my badmailfrom list (#5.7.1)) - Transcript of session follows - ... while talking to

[PHP-DB] Re: htdig interface class

2002-08-28 Thread Manuel Lemos
Hello, On 08/28/2002 06:35 AM, Olinux wrote: http://phpclasses.promoxy.com/browse.html/package/26.html Anyone tried this package - successfully? I have only been able to pull up No results. I spent the past 10 hours trying to find/write a wrapper for htdig that will call htsearch

[PHP-DB] Re: convert mysql table to Excell or Access file

2002-08-28 Thread Manuel Lemos
Hello, On 07/12/2002 07:36 PM, Alex Shi wrote: Can MySQL table be converted to Access or Excell format? Alex You may want to try this class that can write Excell files just with PHP, so it can run under Linux/Unix too: http://www.phpclasses.org/biffwriter -- Regards, Manuel Lemos

Re: [PHP-DB] A Doubt

2002-08-28 Thread Bas Jobsen
Hi Manoj, echo SCRIPT document.location = 'include.php' /SCRIPT ; I think i could also use: header('Location: include.php'); // you shouldn't print anything else before the header Now your flag thing. I the first place you could check $_SERVER['HTTP_REFERRER'] gives you the page the

[PHP-DB] Re: htdig interface class

2002-08-28 Thread David Robley
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... http://phpclasses.promoxy.com/browse.html/package/26.html Anyone tried this package - successfully? I have only been able to pull up No results. I spent the past 10 hours trying to find/write a wrapper for htdig that will call

Re: [PHP-DB] how to display tree structure from database???

2002-08-28 Thread leo g. divinagracia iii
Pierre-Alain Joye wrote: Hello, http://membres.lycos.fr/sqlpro/Tree/SQL_tree.htm provides a good way to store trees in a DB, docs are in french, nut sqlimages are universal. hth pa run this URL through the translator at http://babel.altavista.com and you have a 90-98% accurate