mysqldump dbname.tablename > filename.txt
Cheers, Andy
"Raymond Lilleodegard" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi!
>
> I would like to make a txt file our from some db output, is this possible?
> Couldn't find anything about it in the fun
May I use this dump method with a query too? Or is this only for making a
hole table into a txt file?
Because I'm trying to get a website into a txt file and save it into a
directory on the server to get a order sendt by fax. Or is this a "long way"
to go?
Regards Raymond
"Andy" <[EMAIL PROTEC
On Saturday 06 April 2002 23:18, Raymond Lilleodegard wrote:
> May I use this dump method with a query too? Or is this only for making a
> hole table into a txt file?
I think it's only for a whole table.
> Because I'm trying to get a website into a txt file and save it into a
> directory on the
Hi all ;)
usually i just use mysql with php, but this time i will need to access
an oracle database, knowing oracle is not a problem, but i'm searching
for a DB abstraction layer that is tested and working.
as i never used this before, just mysql_query () type things or ora type
querys for instanc
Hi there,
I did just do a procedure anlyse to my table and figured out that the best
type would be enum.
I tryed:
ALTER TABLE `test` CHANGE `field` `field` ENUM
but I am getting an error: You have an error at your sql sytax at ""
Is this column type even possible, because I have over 2million
On Saturday 06 April 2002 19:34, Pedro M.S. Oliveira wrote:
> Hi all ;)
> usually i just use mysql with php, but this time i will need to access
> an oracle database, knowing oracle is not a problem, but i'm searching
> for a DB abstraction layer that is tested and working.
> as i never used this
Hi All
I have a dynamic drop down list that work perfectly.
But what I would like to do is when a user selects where to got
That the selection is shown on the next page as the selected item.
And if they change this selection that it is then shown as the selected
item.
Any pointers of id
On Saturday 06 April 2002 20:17, Jason Wong wrote:
> Or look in:
>
> http://www.phpclasses.com
Sorry, that should be
http://www.phpclasses.org
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intra
mysql_error returns the resultant error (if any) of the most recent sql
call on a particular db connection. In other words, if 2 users are
querying the db at the same time, mysql_error returns the most recent
error generated in their _respective_ connections.
Carl
--
PHP Database Mailing List
I recently posted a question regarding connecting to a TNS service from PHP.
I had been getting the error TNS operation timed out from PHP while
connecting via sqlplus worked perfectly fine.
If I was not using a TNS alias from PHP but a real connect string such as
(DESCRIPTION=(ADDRESS=(PROTOCOL=
It is. You can override it in the conf file however.
Later,
Bob
- Original Message -
From: "Florian Clever" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 06, 2002 5:33 PM
Subject: [PHP-DB] tnsnames.ora + Apache & symbolic links
> I recently posted a question regard
Hi all,
This code is working greate except for one minor bug.
If I have 2 or 3 items at different prices buy.php is updating the points of
the user at the last priced item.
In other words if
item 1 costs 1965
item 2 costs 564
item 3 costs 25
and item 1 is clicked it only takes away 25 points i
On 4/6/02 4:12 PM, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
> From: "Raymond Lilleodegard" <[EMAIL PROTECTED]>
> Date: Sat, 6 Apr 2002 17:18:07 +0200
> To: [EMAIL PROTECTED]
> Subject: Re: Making a txt file from db data, is it possible?
>
> May I use this dump method with a query too? Or i
Hi All,
I'm just starting on a database to track IP addresses. I'm thinking about
how best to store the IP address - 4 tinyints, varchar or char; as one big
varchar or 4 chunks?
We will eventually want to look at things by net or subnet and being able to
search on the various parts of the addre
On Sunday 07 April 2002 12:01, Jennifer Downey wrote:
> Hi all,
>
> This code is working greate except for one minor bug.
>
> If I have 2 or 3 items at different prices buy.php is updating the points
> of the user at the last priced item.
>
> In other words if
> item 1 costs 1965
> item 2 costs 56
I am trying to write a simple login script, and I am new to PHP. Here is
what I have so far:
Basically I have an HTML form that links to this page where a user enters
their social security number and this script compares it to a database. If
its there, redirect to a new page, if not present a
On Sunday 07 April 2002 13:41, Pusta wrote:
> I am trying to write a simple login script, and I am new to PHP. Here is
> what I have so far:
>
>
> $stmt = $HTTP_POST_VARS['ssn'];
> $oerr = OCIError();
> $dbconn = OCILogon("user", "pass", "database");
> $search = ociparse($dbconn, "select GURMAIL
What is the syntax to input a field from a form into an oracle using PHP?
Can anyone help?
Pusta
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I cannot check the ssn against the database. ociparse returns true if the
query was successful and ociexecute does the same. What do I have to check
the true value of I guess is my main question.
Pusta
"Jason Wong" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> On Sunday 07 A
On Sunday 07 April 2002 15:20, Pusta wrote:
> I cannot check the ssn against the database. ociparse returns true if the
> query was successful and ociexecute does the same. What do I have to check
> the true value of I guess is my main question.
I've never used the Oracle functions before but t
It's late and I'm getting groggy.
I have a table called mail_list. There are four possible list_names.
I want to be able to either delete an email associated with a particular
list or all matching email.
Deleting WHERE email AND list match works fine. The problem is when I want
to delete an a
21 matches
Mail list logo