yes, of course you're right-- gotta stop working so late... the use of
the while statement where it wasn't needed threw me off, I guess.
Paul DuBois wrote:
>> Take out the while statement--
>> i.e. simply use:
>>
>> $row = mysql_fetch_array($result);
>>
>> the way you have things constructed
if you just echo() the results/messages as you come across them, the page
should "incrementally" load.
in my experience (IE5?) if there is data being "added" to the page, then the
browser will display what it can, and keep adding to it until the stream
breaks or it finishes. one thing to note is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello php-db,
We have a RedHat 7.1 server with a stock install. I recompiled PHP from
the source RPM in order to add oracle support.
It mostly works, but we are having a problem where it apparently
randomly loses the connection to the database. It
>Take out the while statement--
>i.e. simply use:
>
>$row = mysql_fetch_array($result);
>
>the way you have things constructed now, the while statement
>evaluates true on the first iteration and $row equals the result row
>from the query. Because the while returned true, it is evaluated a
>seco
At 4:08 PM +0100 11/22/01, Andy wrote:
>Hi there,
>
>I am trying to do a combination of SQL statements like described in a SQL
>bÛok. Is it possible, that mysql does not allow this syntax?
According to the MySQL Reference Manual, subselects are not supported.
>
>Thanx Andy
>
>Error:
>
>Occured d
Hi,
I am working with PHP and Oracle, with the functions of library OCI,
and I need to handle the transaccionalidad in PHP, not at level of
Stored procedures.
Somebody knows if exists the equivalence (or the form to make this
equivalence), of the function ora_commitoff($conn)? (in OCI)
Leo Kuiper
"Building a map in order to find what's not lost but left behind."
- Beth Orton
- Original Message -
From: koelwebdesign <[EMAIL PROTECTED]>
To: Neil Lathwood <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, November 22, 2001 7:47 PM
Subject: Re: [PHP-DB] Flushing
Hi Folks,
What I am trying to accomplish is:
I want to have a web page access a number of DB's, this will start with one
but on a monthly basis increment by one. So within 12 months their will be
12 DB's. The web page will access each one in turn starting with the newest
DB and search through th
Something similar is available using a FROM clause instead of a SELECT
clause, but it is only available in mysql 4.0.
Fred
Andy <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi there,
>
> I am trying to do a combination of SQL statements like described in a
Matt,
I've never worked with mandrake. Does it have rpm? if yes try this, in a
redhat I have php with mysql support I get this output:
# rpm -qa | grep php
php-4.0.4pl1-9
php-manual-4.0.4pl1-9
php-mysql-4.0.4pl1-9
probably there is a packet manager in mandrake, try it.
I think this is getting
please do yourself a big favor and look at the mysql website.
www.mysql.com
there you'll find how to do it and much more.
btw. the manual comes with mysql when you download it.
read it and you'll soon be addicted.
or something like (on win98)
cd mysql\bin
mysqladmin -u root create binary_data
m
> 2 options:
> - compile php with mssql support (might be ./configure --with-mssql ...)
or
> - if you installed from packet (rpm for example) you can install the
packet
> for mssql (it should be something like php_mssql.version.rpm)
Okey, on http://www.php.net/manual/en/function.mssql-connect.php
Bruno,
I installed mandrake and the PHP support was built in so I guess that it's
a recompile. How do I do that ?
Matt
Bruno Gimenes Pereti wrote:
> Hi matthew,Bruno Gimenes Pereti wrote:
> Hi matthew,
>
> you probably don't have the file php_mssql.so in your extension dir, do
> you?
>
>
Hi matthew,
you probably don't have the file php_mssql.so in your extension dir, do you?
2 options:
- compile php with mssql support (might be ./configure --with-mssql ...) or
- if you installed from packet (rpm for example) you can install the packet
for mssql (it should be something like php_m
I'm trying to get my linux server to connect to an MS SQL server via php.
If I run the same script on my windows laptop there is no problem but on
the Linux server I get the message :
Fatal error: Call to undefined function: mssql_connect() in
/var/www/html/stationary/index.php on line 49
I
Many Thanks for that! It was very informative.
However, I'm also looking for the code for the MySQL database! I'm not sure
how to do it properly! I basicaly need a table with two rows - one for the
date and the other for the text in the news item.
Cheers
Oli Wilkinson
"George" <[EMAIL PROTECTED
Oli,
You may wish to visit www.udzone.com and have a look through a
few of the tutorials on how to set up UD with PHP and the Phakt server model.
George
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-m
As far as I know sub-selects are not supported in mysql.
You have to make a list of item ids first and then use that list in your
delete statement.
ie: WHERE userid IN (list_goes_here)
Matt Friedman
Web Applications Developer
www.SpryNewMedia.com
Email: [EMAIL PROTECTED]
-Original Messa
My MySQL database is set up locally FYI.
Many Thanks
"Oli Wilkinson" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello all,
>
> I'm new to this database stuff - I'm looking to create a simple database
in
> MySQL for a news page.
>
> Just want the date of
never tried this before, but do you need some single quote's around the
whole "(select user_id.)"?
then of course there'd need to be some escape character for the single
quotes in the "user_name = 'herbert01'" bit...
let me know if that is the problem, as this is just a guess!
cheers,
Matt
Hi there,
I am trying to do a combination of SQL statements like described in a SQL
bóok. Is it possible, that mysql does not allow this syntax?
Thanx Andy
Error:
Occured during executing DELETE FROM test_user_interests WHERE user_id =
(SELECT user_id FROM test_user WHERE user_name = 'herbert0
You can create a odbc source for both and copy the data that way.
/Fredrik
"Daniel Berwig" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Is it possible to migrate data into a table in MS Excel to MySQL?
>
> Thanks in advance.
>
> Daniel Berwig
>
>
--
PHP
i'd advise not using something like ultradev until you can write some nice
little scripts in notepad! it's always easier to debug if you start learning
the code properly, then move onto something like ultradev just to speed it
up a bit when you're competent.
firstly, the actual extraction of code
Hello all,
I'm new to this database stuff - I'm looking to create a simple database in
MySQL for a news page.
Just want the date of the input and the text for each entry!
Not too hard! But I'm a complete novice!!!
I am using Dreamweaver UltraDev (and the PHP extension).
Many Thanks
Oli Wilk
I don't know much about javascript, but I would do the following:
1. Figure out what javascript data structure you are going to use to hold
the data.
2. Figure out exactly how it should be coded.
3. Simply write your PHP script to output your javascript as in 2.
The hard part of the matter (whi
Hi there!
I'm baffled!!!
The extension code for mssql support resides on ext/mssql/php_mssql.*
The file EXTENSIONS states that it's working for both Unix and Windows 32.
There is no "--with-mssql" option on configure.
How am I suposed to get this working on Linux ???
Is it included in some other
Hi *,
Running apache1.3.22+php4.0.5+Oracle8.0.5 Client on W2K works fine.
However, running the same configuration with php4.0.6 doesn't work.
One errormessage mentioned a failed functioncall to OCILobOpen.
It seems that PHP4.0.6 expects a different OCI.DLL.
Do I need to install a newer Oracle
Hi, out there
Has anybody found a way to pass variables between javascript and php?
Here's what I want to achieve:
1. I want to display a mysql_query result record-by-record
(first/prev/next/last buttons) without re-querying.
2. I want to use a static html-form and plug the data into
28 matches
Mail list logo
