On Saturday 26 January 2002 13:19, [EMAIL PROTECTED] wrote:
> Hello,
>
> I've been experimenting with adding decimal columns. From the mysql docs I
> got this SELECT sum(value) FROM pets;
>
> So I did this $result = mysql_query("SELECT sum(value) FROM pets",$db);
> $myrow
At 23:19 -0600 1/25/02, [EMAIL PROTECTED] wrote:
>Hello,
>
>I've been experimenting with adding decimal columns. From the mysql docs I
>got this SELECT sum(value) FROM pets;
>
>So I did this $result = mysql_query("SELECT sum(value) FROM pets",$db);
> $myrow = mysql_fetch_a
Hello,
I've been experimenting with adding decimal columns. From the mysql docs I
got this SELECT sum(value) FROM pets;
So I did this $result = mysql_query("SELECT sum(value) FROM pets",$db);
$myrow = mysql_fetch_array($result);
print "$myrow[value]";
I also trie
that I changed my mind. Gurhan Ozen>Storing images in the database is not a
good idea , just store the path of Gurhan Ozen>the images in the database
and keep your images in your hard disk... Gurhan Ozen>
Since everything is on hard-disk, I personally feel, the image can be stored
anywhere. B
There is no limit AFAIK if you are using the default 'files' handling code
for sessions, however if you're writing the session data to a database,
there will be a limit depending on the type of field you use to store the
data; i.e.: mysql text fields can store up to 64K
Hayan Al Mamoun <[EMAIL PR
Here's an article that may help:
"Dynamic generation of static webpages"
http://www.phpbuilder.com/columns/loris20010420.php3
I think what you are referring to would best be
accomplished using a macro:
You can download AutoMate 4.5 at downloads.com - it's
a simple program
olinux
--- Howard P
Hi Shelly,
It is just the old trick. You can get the time at the beginning of the page
and at the end of the page and just calculate the difference in between two.
Since the default timeout value in PHP is 30secs. it will probably be a
short timeperiod so you can probably you use time() function w
Hi Howard,
I didn't fully understand your question.. Wouldn't you rather have the
server upload the file automatically without asking the user where to save
it?
You can do it by using PHP's FTP functions.. See:
http://www.php.net/manual/en/ref.ftp.php
Gurhan
-Original Message-
From: How
Hi guys
I have a local server being used to generate page
which are then uploaded as static pages to
another server.
I would like have the script call up the Windows save as
dialog when a new page has generated so a folder on
the local unit can be selected etc.
I've been looking for an example
It's php 4.0.6 on win2k/apache.
kevin
>>> Brian Bruns <[EMAIL PROTECTED]> 01/25/02 02:19PM >>>
which library are you using to connect to SQL Server? Is this php running
on windows or are you trying from unix?
On Fri, 25 Jan 2002, Kevin Won wrote:
> I'm having a problem with varchar fields
It's php 4.0.6 on win2k/apache.
kevin
>>> Brian Bruns <[EMAIL PROTECTED]> 01/25/02 02:19PM >>>
which library are you using to connect to SQL Server? Is this php running
on windows or are you trying from unix?
On Fri, 25 Jan 2002, Kevin Won wrote:
> I'm having a problem with varchar fields
Kamil,
If getting info in your private email is making you so pleased maybe you
shoudl never post any questions here, it is contradictory to the philisophy
of the list.
I have also asked about inserting / retrieving pictures in mysql database
in past and I have received so many con replies that
Hello,
last time I asked about inserting pictures into MySQL, but how can I do it (inserting
into BLOB column, picutures) using PHP? After inserting it into table I would also
like to select and display the picutre (I inserted before) using my Internet browser.
Any suggestion how to do it usin
hi yall,
i've been searching for the command that prints back how long page took
to process. i found the command that prints @mysql_rows_affected().
but i can't seem to find how i print out how long it took for page to be
processed.
any ideas?
tx,
shelly
__
which library are you using to connect to SQL Server? Is this php running
on windows or are you trying from unix?
On Fri, 25 Jan 2002, Kevin Won wrote:
> I'm having a problem with varchar fields out of mssql which are only returning value
>lenghts < = 256 characters.
>
> I know that the ph
Jamie,
The main problem here is , you are selecting the rows that are some null
values. mysql_fetch* doesn't return any null columns. Yes, you read it
right, if you have a table with say, 5 columns and if 3 columns in a row are
null then you'll only have 2 columns that are not null .
Make sure t
> $prefilename = date("m-d-y");
>
> $filename = "$prefilename.txt";
>
> $db = mysql_connect("localhost","cloft","spring");
>
> mysql_select_db("countryloft");
>
> // get requests from table
> $result = mysql_query("SELECT * FROM catal
Michael,
Yes. Just go ahead, and echo $sql to see what you have. You can build quite
complex queries this way, dependent upon input from picklists, checkboxes,
etc., adding and dropping conditions according to whether or not they have
been selected/set.
So why not $sql = " UPDATE $fieldlist $
I think they ran out of funding - try www.sourceforge.com , search for
postgresql admin & you will find it there - plus a few others.
- Matt.
-Original Message-
From: Jancs [mailto:[EMAIL PROTECTED]]
Sent: 25 January 2002 21:15
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Off: greatbridge.org
$prefilename = date("m-d-y");
$filename = "$prefilename.txt";
$db = mysql_connect("localhost","cloft","spring");
mysql_select_db("countryloft");
// get requests from table
$result = mysql_query("SELECT * FROM catalogreq WHERE
PROCESSE
> Still when I make the changes suggested the file will not be created, yet I
> get no form of an error message.
>
> Is there something else I'm missing?
Please post your new code for review.
Daniel J. Lashua
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL P
Still when I make the changes suggested the file will not be created, yet I
get no form of an error message.
Is there something else I'm missing?
> I'm trying to take the contents of a table and write them to a file on my
> server. Everything seems to function ok (AKA no errors) but no file get
Hi there!
Does someone know what happened with this company? They had a nice php tool
for postgres database management... now all sites are down
Janis
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTE
Hello,
Björn Schotte wrote:
>
> * Stig S. Bakken wrote:
> > this effort. I don't understand why this is an issue for you, could you
> > explain?
>
> I already explained it several times.
I understand your concern of this PEAR-DB x Metabase merger may open a
precedent that will motivate others
> I'm currently writing "The PEAR Manifest", a document that clearly
> defines PEAR once and for all. I'll post the first draft on pear-dev
> here when it's done, but to answer your question, there has been talk
> about a "core" set of packages for a while. In the manifest these are
> called PFC
You don't have anything to write to the file.. mysql_query() function
returns true or false, it doesn't return the actual qurey result you'd see
in mysql monitor. You have to use some other functions such as
mysql_fetch_array(), mysql_num_rows() to retrieve the data before you can
write it into a
> I'm trying to take the contents of a table and write them to a file on my
> server. Everything seems to function ok (AKA no errors) but no file gets
> written ... I can't figure out why. Can anyone shine some light on this dark
> problem?
>
> $db = mysql_connect("localhost","cloft","s
I'm trying to take the contents of a table and write them to a file on my
server. Everything seems to function ok (AKA no errors) but no file gets
written ... I can't figure out why. Can anyone shine some light on this dark
problem?
$db = mysql_connect("localhost","cloft","spring");
If you need something that big
Use a TEXT type instead.
Dan
On Friday, January 25, 2002, at 01:35 PM, [EMAIL PROTECTED] wrote:
> thanks for your reply. It's 5000.
>
>
>
> Kevin Won
> -
> ITG Web Developer,
> Systems Administrat
Raymond,
What sort of error are you getting?
One of the most useful tools in your toolbox is the print() function.
Try doing something like this:
$sSQL = "SELECT '$car' FROM varetabell WHERE carid='$carid'";
print ($sSQL);
$sql = mysql_query($sSQL);
$myrow = mysql_fetch_array($sql);
$x = $myr
Hello!!!
What is the Length of the varchar field, in your database???
Dan
On Friday, January 25, 2002, at 01:22 PM, [EMAIL PROTECTED] wrote:
> I'm having a problem with varchar fields out of mssql which are only
> returning value lenghts < = 256 characters.
>
> I know that the php.ini sett
I'm having a problem with varchar fields out of mssql which are only returning value
lenghts < = 256 characters.
I know that the php.ini setting in mssql for textlength must be set to get more than
4096 chars, I've set this value higer and my TEXT types return correctly, but my
varchar field
My example was a litle confusing here I see.
My table have multiple price columns. something like this:
carid convertible stationvagon etc. etc
1100100100
- Original Message -
From: "Gurhan Ozen" <[EMAIL PROTECTED
Seems like it will NOT work because you are selecting $car which is already
chosen by the user (i.e. which is a known value). I don't know how you laid
out your table but shouldn't your query be something like "SELECT price from
FROM varetabell where carid=$car" ??
Gurhan
-Original Message
Hi all!
I have this form with some choices:
Enter how many cars you want:
ford
bmw
mercedes
And then I am trying to get the price out of a table in my database with
this code:
$sql = mysql_query("SELECT '$car' FROM varetabell where carid='$carid' ");
$myrow= mysql_fetch_array($sql);
$x = $
Sridhar,
Sorry, it's available at:
http://conf.php.net/pres/index.php?p=slides%2Foci&id=oci2
Good luck!
--Anthony
> From: Anthony Carlos <[EMAIL PROTECTED]>
> Date: Fri, 25 Jan 2002 09:50:26 -0500
> To: <[EMAIL PROTECTED]>
> Subject: Re: [PHP-DB] Oracle Database procedures
>
> Sridhar,
>
>
Sridhar,
Take a look at this documentation from Thies Arntzen. It's required reading
for anyone using Oracle and PHP! I hope it gets you started. If not, ask for
more help!
Good luck,
Anthony Carlos
PS: It shows how to bind PHP variables to Oracle variables...
> From: Sridhar Moparthy <[EMAIL
There's a bunch of requirements that have to be met in order for the
software installer to work. In case you're installing onto a remote machine,
do you have XWindows running on your Linux machine? Does your terminal
program support XWindows?
> From: "aiQa" <[EMAIL PROTECTED]>
> Date: Fri, 25 Jan
Hi All,
Could you please help me on how to call Oracle stored procedures from
PHP4.X. Also how to get the returned data in PHP from Oracle stored
procedure?
Thanks In advance.
Sridhar Moparthy.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For ad
Hi Hendra
An alternative would be to:-
1 LOAD DATA the table, but format each date field as a string.
2 add a date column
3 use UPDATE to convert/re-format the data from the string to date field
4 remove the string column
This solution does not require you to tackle another tool and face the ext
* Stig S. Bakken wrote:
> this effort. I don't understand why this is an issue for you, could you
> explain?
I already explained it several times.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To
Hi,
..and Has anyone installed oracle 8i client on linux? When I start
./runInstaller, It says that "it installs x.jde" and hangs.
Thanks,
aiQa
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To
On Tue, 2002-01-22 at 22:24, Björn Schotte wrote:
> * Alex Black wrote:
> > > Of course, but no one forces you to do that. I, as a developer,
> > > can choose if I want to use PEAR::Metabase in my application
> > > or PEAR::DB.
> > Yes, which is not a good idea. If you're tying to get people to us
On Tue, 2002-01-22 at 22:17, Alex Black wrote:
> > Template classes are also foundation components of modern
> > applications.
>
> They are certainly important, but they do not prevent interoperability in
> the same way that different database abstraction packages do.
>
> >> application, using A
Yeah. Without client no libraries for PHP (or other clients).
Helge
> -Original Message-
> From: aiQa [mailto:[EMAIL PROTECTED]]
> Sent: Freitag, 25. Januar 2002 09:36
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Oracle client on linux
>
>
> Hi,
> I think I have to install oracle client
hello anyone know why ooverhead happen?
some of my table are overheading where a run delete and updates queries.
---
Everton B Yoshitani
[[EMAIL PROTECTED]]
UF Communications, Inc.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional com
Hi,
I think I have to install oracle client on my RedHat7.2 to connect a Oracle8i
windows2000 server. Is it right?
aiQa
47 matches
Mail list logo