Re: [PHP-DB] How to avoid: Warning: Page has Expired

2002-04-09 Thread olinux
Using the GET method is a great solution, but sometimes you just gotta POST! I have found the best solution to be using a separate file to do the processing. For example login.php submits 'user' and 'password' to auth.php. auth.php queries the db for 'user' and 'password' and redirects [via heade

[PHP-DB] LOBS with CURSOR_SHARING=FORCE gives core dump

2002-04-09 Thread Prince
I have the following php code. If I add the parameter CURSOR_SHARING=FORCE in my init.ora and while executing the program I get the "Segmentation fault". $ /usr/local/php4/bin/php -q curshare.php Segmentation fault (core dumped) Is there any work-around for this? Is this a bug? This seems to b

[PHP-DB] Re: Mysql and memory issue

2002-04-09 Thread Yasuo Ohgaki
Trond Erling Hundal wrote: > Hi, maybe this list isn't the best place to ask for this but... This is the right place. > I keep getting "memory exhausted" errors from mysql, on a system running > as mail/mysql/apache+php server. (rh7.1) > Is it my queries that are inefficient? Is it my modelling-

Re: [PHP-DB] PHP tags in a MySQL echo

2002-04-09 Thread Joshua Stein
> Is there any way to work around this and get it to treat all the echoed rows > as PHP not just only text? Wrap the print around an eval(): print(eval($string)); -j. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PHP tags in a MySQL echo

2002-04-09 Thread Adam Alkins
Hello Everyone, I'm currently working on a simple template system, where, all the html and few php tags are called from a database so I can easily update the site content via a form, e.t.c., that works fine. However, when I echo the text, the html/php, the php tags to not process. I figure the

Re: [PHP-DB] AOL Problems

2002-04-09 Thread Dan Brunner
Hello!! So is the old value of "new location" not being passed to the next page? OR Is the new "category" variable not being passed to the next page?? Dan On Tuesday, April 9, 2002, at 12:44 PM, [EMAIL PROTECTED] wrote: > Hi group, > > I wonder if anyone can help me with some prob

[PHP-DB] Re: Join?

2002-04-09 Thread Lutz Brückner
Hi Volker, after studying your code (not so easy to find without formating and lots of html), I think what you want to do is somthing like this: $abfrage = 'SELECT A.id AS aid, A.autor AS aauthor, A.zeit,AS azeit' .' A.betreff AS abetreff, A.inhalt AS ainhalt,' .

Re: [PHP-DB] If statement for sql statement

2002-04-09 Thread Jason Wong
On Wednesday 10 April 2002 12:32, jas wrote: > Ok here is my question... I have a form that reads the contents of a > directory, places the resulting files into a select box within a form for > further processing, code is as follows: [snip] > What I need to know is if there is a way to create an

[PHP-DB] AOL Problems

2002-04-09 Thread Bzdpltd
Hi group, I wonder if anyone can help me with some problems I have just found out with a website we have just put together. Our client unfortuntately uses the AOL browser on a MAC, so he is running version 5 of AOL for the mac. Now we have a database driven website we have put together, and t

Re: [PHP-DB] Re: executing cgi

2002-04-09 Thread Jason Wong
On Tuesday 09 April 2002 10:49, David Robley wrote: > In article <000d01c1df6c$962e8e20$0300a8c0@alex>, [EMAIL PROTECTED] > says... > > > hey guys, > > > > kinda OT for the db list, but since most ppl know a lot about php can > > somehow tell me how to execute a cgi script within a php page? > > >

Re: [PHP-DB] undefined function

2002-04-09 Thread Jason Wong
On Wednesday 10 April 2002 00:12, Nick wrote: > Hi: > thank you for you e mail > I am using redhat7.2 > I am new to php and linux , do not know how to configure mysql into php Install: php-mysql-4.0.6-7.i386.rpm it's on the second disc. -- Jason Wong -> Gremlins Associates -> www.gremlins.

[PHP-DB] Mysql and memory issue

2002-04-09 Thread Trond Erling Hundal
Hi, maybe this list isn't the best place to ask for this but... I keep getting "memory exhausted" errors from mysql, on a system running as mail/mysql/apache+php server. (rh7.1) Is it my queries that are inefficient? Is it my modelling-scheme that sucks or could it be that mysql is leaking memory

[PHP-DB] If statement for sql statement

2002-04-09 Thread jas
Ok here is my question... I have a form that reads the contents of a directory, places the resulting files into a select box within a form for further processing, code is as follows: --"; while ($file_name = readdir($dir)) { if (($file_name != ".") && ($file_name !="..")) { $file_lis

RE: [PHP-DB] How to avoid: Warning: Page has Expired

2002-04-09 Thread Jonathan Hilgeman
I've addressed this problem here: http://php.sitecreative.com/faq.php - Jonathan -Original Message- From: John Hughes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 12:30 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] How to avoid: Warning: Page has Expired I have the first part

Re: [PHP-DB] undefined function

2002-04-09 Thread Nick
Hi: thank you for you e mail I am using redhat7.2 I am new to php and linux , do not know how to configure mysql into php I wrote a simple function to ask the user for two numbers and add them together and print them out, and it worked. But when I used predefined function, I get the error. where d

RE: [PHP-DB] How to avoid: Warning: Page has Expired

2002-04-09 Thread Peter Lovatt
If you change the form action to 'get' instead of 'post' this avoids the message. 'Get' data is displayed on the address line eg http://domain.com/script.php3?photoID=123&viewtype=full so it should be avoided for sensistive data like passwords or credit card numbers. This kind of data should

Re: [PHP-DB] undefined function

2002-04-09 Thread Julie Meloni
N> Fatal error: Call to undefined function: mysql_connect() in N> /var/www/html/action.php on line 13 This indicates you do not have MySQL support built into PHP. Assuming a non-Windows OS by the pathnames above, you must use --with-mysql when issuing the configure command when building PHP.

[PHP-DB] undefined function

2002-04-09 Thread Nick
Hi: in my code below, i get the error of undefined function. can anybody help please? Thanks /* Connecting, selecting database */ $link = mysql_connect("localhost", $user_name, $password) or die("Could not connect"); print "Connected successfully"; mysql_select_db($my_Database

Re: [PHP-DB] connect to filemaker via odbc

2002-04-09 Thread Joshua Hoover
I haven't tried it, but the best solution seems to be the FX.php classes for connecting to FileMaker from PHP by Chris Hansen. For more information and to download, try: http://www.iviking.org/projects/FXdownload.php I believe you'll have to turn on Web Companion on FileMaker for this to work.

[PHP-DB] connect to filemaker via odbc

2002-04-09 Thread aanding
Hi, has anybody experience with connecting to filemaker via odbc. thanx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Newbie attack...

2002-04-09 Thread Hugh Bothwell
> Everything is working great except the fact that when > I put some php code into the 'text' field, in order to run > en extra sql command in the page, it hangs and just > prints the code as if it was just text. (shrug) so far as the database is concerned, it *is* just text. If you want retur

[PHP-DB] Newbie attack...

2002-04-09 Thread Achilleas Maroulis
Hi. I'm Achilles from Greece and I have been into PHP for 3 or 4 weeks. So far I've read 2 books about it and a lot of the online manual. But now I've come onto a problem and I'm asking you for help. I've designed a site which is completely based onto PHP and mySQL. What I mean is that all the

Re: [PHP-DB] Finding highest number in auto increment

2002-04-09 Thread Adam Voigt
Oh, forget to include that if you only want that one record, use the "LIMIT 1" keyword as well. Adam Voigt [EMAIL PROTECTED] P.S.: All of this is in the MySQL manual. On Tue, 09 Apr 2002 15:48:45 +0200, Lisi <[EMAIL PROTECTED]> wrote: > Each record in my table has a unique ID number generated b

Re: [PHP-DB] Finding highest number in auto increment

2002-04-09 Thread Adam Voigt
SELECT * FROM whatever ORDER BY id DESC; Ofcourse if you want Ascending order, it would be "ASC" instead of "DESC" Adam Voigt [EMAIL PROTECTED] On Tue, 09 Apr 2002 15:48:45 +0200, Lisi <[EMAIL PROTECTED]> wrote: > Each record in my table has a unique ID number generated by auto increment > each

[PHP-DB] Finding highest number in auto increment

2002-04-09 Thread Lisi
Each record in my table has a unique ID number generated by auto increment each time a new record is added. This is stored in a field called ID. I have a page that displays records as they are selected, but I want the default to be the latest entry if none has been selected. How do I write the

[PHP-DB] Join?

2002-04-09 Thread Volker Hartmann
Hi, I've got a problem with database abstraction. There are two tables. One with articles (id,content,author,time) and one with comments on those articles (id,article_id,content,author,time). My script looks like this: function show_news($limit){ /* get db parameters and connect to db */ requir

[PHP-DB] PHP date calculations and db (slightly OT)

2002-04-09 Thread Markus Lervik
Hello list, I have a database where people can reserve our computer class. The columns are time_from, time_to, name_id, res_date, confirmed. I have a table (HTML, not db *g*) that's supposed to print out a=20 month, starting from day 1 to num_days_in_month, and print the numbers in the right sp

[PHP-DB] How to avoid: Warning: Page has Expired

2002-04-09 Thread John Hughes
I have the first part of the kids' soccer photo database site up that I mentioned in an earlier post. The site displays nine image thumbnails. You click on the thumbnails and are taken to a full size photo. Everything works as expected for the first nine images but when you go to the next page o