RE: [PHP-DB] Table to BIG to dump, how ? (PROBLEM AGAIN)

2001-12-18 Thread Beau Lebens
just use the mysql console to dump out to a file (check manual for "OUTFILE" or something like that) /beau // -Original Message- // From: Nagasea [mailto:[EMAIL PROTECTED]] // Sent: Wednesday, 19 December 2001 10:11 AM // To: Thomas Lamy; [EMAIL PROTECTED] // Subject: [PHP-DB] Table to

[PHP-DB] Table to BIG to dump, how ? (PROBLEM AGAIN)

2001-12-18 Thread Nagasea
I forgot to mention that I'm using the PhpMyAdmin for dumping the table. Is there any way to make a php script to manually dump the table ? Because It's not working if I'm using phpMyAdmin. -Naga --- Thomas Lamy <[EMAIL PROTECTED]> wrote: >Hi, > >If it's a php script dumping the data, have a loo

[PHP-DB] Re: Table to BIG to dump, how ?

2001-12-18 Thread Yasuo Ohgaki
Nagasea wrote: > I always got this error message when I tried to dump my structure and data table to >a file. > I think it's because the file table size it BIG (almost 10mb). > Is there anyway to dump that table to file without getting browser time out ? > > Please help me here.. > It sounds

[PHP-DB] InterBase 5.x

2001-12-18 Thread -=MikeP=-
This is a forwarded message From: -=MikeP=- <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Date: Wednesday, December 19, 2001, 12:46:47 AM Subject: ===8<==Original message text=== Hello all, Can anybody help me... I need to manage InterBase 5.6 using PHP... I'm a newcomer a

AW: [PHP-DB] Re: Table to BIG to dump, how ?

2001-12-18 Thread Thomas Lamy
Hi, If it's a php script dumping the data, have a look at the "max_execution_time" config variable. IIRC the default is 30 seconds, which you can override from within the running script with ini_set ("max_execution_time", 10); Hope this helps. Thomas > -Ursprüngliche Nachricht- > V

[PHP-DB] Re: while...if statements???

2001-12-18 Thread Chris Lee
because the while() statement works like this - do something while x is true. if x is not true dont do anything. - do something while conent is in the db. if there is no conent in the db dont do anything. your if() statement is never run if there is no content. $return = mysql_fetch_row($result

RE: [PHP-DB] while...if statements???

2001-12-18 Thread Leotta, Natalie (NCI/IMS)
Have you tried printing out $pet_picture to make sure that it really equals "" when there's no pet? -Natalie > -Original Message- > From: Jay Fitzgerald [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, December 18, 2001 3:09 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; > [EMAIL PROTECTED] >

[PHP-DB] while...if statements???

2001-12-18 Thread Jay Fitzgerald
Does anyone know why this isn't working?? What I am trying to do is display photos from a database based on each month. This part works fine when I set it to the current month of December (today) as that is when I uploaded the photos. However, when I manually set the date to a month that has n

[PHP-DB] cannot connect to sybase, but no (undefined)errors

2001-12-18 Thread Peter Sands
Hi, I am tying to connect to sybase 11.9.2 from php 4.1.0 on aix. I have successfully installed php as a CGI (apache). The phpinfo() function tells me that sybase client is supported. But when I try to connect I get a failure $connection=sybase_connect("SYB_SRV", "sa", "pizza"); http://www.Te

[PHP-DB] Re: Database query

2001-12-18 Thread Fred
You are getting this result because you have all of those ORs in your statement. If any of them are true it will execute the query. If location finds a match ('$location' = location) it will execute the query regardless of whether discipline was empty or simply did not match. It is generally a

Re: [PHP-DB] Getting Oracle to work

2001-12-18 Thread Anthony Carlos
Chuck, Did you compile PHP with Oracle support? Also, make sure that you compiled the correct oracle functions. The function you quote is part of the older oracle functions. There are newer OCI8 functions available. -Anthony Carlos > From: Chuck Lidderdale <[EMAIL PROTECTED]> > Date: Tue, 18 De

[PHP-DB] Getting Oracle to work

2001-12-18 Thread Chuck Lidderdale
I'm missing - I guess - a library - I need to do a remote connect to an Oracle DB - I've copied examples but get the following when I run it Fatal error: Call to undefined function: ora_logon() in /var/www/html/bg.php I'm guessing something like orasql.so - but I can't find anything like that.

[PHP-DB] Search engine

2001-12-18 Thread Sharmad Naik
Hi, I wanted to develop a good and fast search engine (robost too) can anyone help me with some ideas. -TIA Sharmad -- Feel free to contact me (flames about my english and the useless of this driver will be redirected to /dev/null, oh no, it's full...). (Michael Beck, desc

Re: [PHP-DB] Database query

2001-12-18 Thread Jon Farmer
Sorry the second elseif statement should have ended with : not ; -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send email with subject: Send PGP Key - Original Message - From: "Jon Farmer" <[EMAIL PROTECTED]> To: <[EMAIL PROTE

Re: [PHP-DB] Database query

2001-12-18 Thread Jon Farmer
Ok you need to use PHP to decide what they have selected and construct a sql statement based on that. for instance if ($location != "" && $discipline != "") : //construct variable with sql statement elseif ($location == "" && $discipline != ""): //construct variable with sql

[PHP-DB] Database query

2001-12-18 Thread Bzdpltd
Hi group, I am still getting to grips with PHP and MySQL and have a question that hopefully someone can easily answer: I have a search page which consists of two drop down menus, the user has 3 ways of finding information. The first is by selecting a location and a discipline which would look

[PHP-DB] Persistent connection to Oracle with OCI

2001-12-18 Thread Berlina
Hi again to everybody, first sorry for my poor english. im trying to use persistents connections to an Oracle Database through PHP, for manageing transactions, and have some problems. My Schema: * Web Server: Apache 1.3.20 on a Linux RedHat 7.0 * PHP: 4.0.6 compiled with oracle module function

Re: [PHP-DB] duplicated entry for key #

2001-12-18 Thread Russ Michell
> >'Duplicate entry 'username' for key 1. This means that you do have a duplicate entry in a row of your DB. Try setting a column as "Auto increment": ALTER TABLE id smallint(10) DEFAULT '0' NOT NULL auto_increment (or something like that) This means each set of data you put into the DB will