Are there any people who know the way to display results on multiple pages
if using Oracle database (preferrably using PHP Oracle finctions and not
Oracle8 functions)?
Best Regards,
Maxim Bubnov
> "Richard Emery" <[EMAIL PROTECTED]>:
> Why don't you let mysql sort and limit the records for you?
On Wednesday 17 April 2002 05:35, Richard Emery wrote:
> Are you trying to create a table named "How Are You"? If so, can't do it.
> It MUST be a one-word name.
Not strictly true. You can surround the table name with backticks:
CREATE TABLE `How Are You` ...
However this is /not/ recommende
--with-mysql=shared/usr is listed in teh configure command.
you can see @ www.flost.net/info.php
Thank You
<><><><><><><><><><><><><><><><>
Daniel Negrón
Lotus Notes Administrator / Developer
KB Electronics, Inc.
954.346.4900x122
http://www.kbelectronics.com
<><><><><><><><><><><><><><
Hi,
Hope in the right place ? Just finished loading RH7.2 Apache 1.3.23, MySQL
3.23.49a, and PHP 4.1.2 I have gotten this to work properly on W2K, IIS4 &
5 with no problems. To start off ... all of these are working properly
individually. PHP works fine on Apache MySQL works fine by itself,
Hello,
Richard Ellerbrock wrote:
> >> I'm planning to write a database application for MySQL, and then port
> >> it
> > to
> >> PostrgeSQL.
> >> Is there any library or class that could help me to write/maintain just
> > one
> >> source code for both MySQL and PostgreSQL ?
> >
> > I think your b
Rouvas Stathis wrote:
> Hi,
>
> place appropriate NLS_LANG definitions in the Apache startup script
> (/etc/rc.d/apache ?).
As a background to this, it's essential to do this because certain
things happen when the module is initialised in PHP. Hence if you use
putenv() to alter some Oracle d
On Tue, 16 Apr 2002 23:18, Michael Kimsal did align ASCII characters thusly:
> I guess the first thing you should help us with is defining "high
> volume". :) 1/sec? 100 sec? Actually, this will probably have less
> impact on archictecture than hardware, but I'm always curious as to what
> 'hi
Hi,
place appropriate NLS_LANG definitions in the Apache startup script
(/etc/rc.d/apache ?).
-Stathis.
Miguel Carvalho wrote:
>
> Hi,
>
> First of all i have searched for this trouble on the news(
> groups.google.com); on Oracle docson phpbuilder site; in php general, php
> db mailing list'
Maybe the mistake is in the name.
You can't name a table "How Are You".
Only oneword name table allowed
:)
- Original Message -
From: "eat pasta type fasta" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 16, 2002 6:13 PM
Subject: [PHP-DB] Inserting a String Variable into
Hi,
First of all i have searched for this trouble on the news(
groups.google.com); on Oracle docson phpbuilder site; in php general, php
db mailing list's .
The problem:
Background info:
PHP version: 4.1.2
OS: Linux Suse 7
OCI version: 8
Database version: 7.x
Database OS: HP/UX
I need to do
Are you trying to create a table named "How Are You"? If so, can't do it.
It MUST be a one-word name.
You would have discovered this yourself had you typed your CREATE statement
into the mysql command line.
Second ALWAYS include an "or die("Error: ".mysql_error())" part after your
mysql_query()
I don't understand what you're saying
- Original Message -
From: James M Kupernik <[EMAIL PROTECTED]>
To: 'Richard Emery' <[EMAIL PROTECTED]>
Sent: Tuesday, April 16, 2002 4:05 PM
Subject: RE: [PHP-DB] results on multiple pages
Because if I limit the record sort, then if the record I
On 4/16/02 2:34 PM, "Lisi" <[EMAIL PROTECTED]> wrote:
> Thanks for the explanation! Very clear.
>
> How do you know how fragmented your DB is? I apologize if this is covered
> somewhere, like I said I was very confused buy this whole topic.
>
> Thanks,
>
> -Lisi
>
Oh, sorry each database is d
I am creating a string out of bunch of variables and an array and I need
it to become a query which will make me a table.
It looks like this when I echo it:
CREATE TABLE How Are You (Reply1 VARCHAR(255), Reply2 VARCHAR(255),
Reply3 VARCHAR(255), Reply4 VARCHAR(255), Reply5 VARCHAR(255), date
The tables gets fragmented as deletions, updates take place on a table. If
the DB operations get slower on a table, there is a good possibility that
the table has been fragmented.. If you are using MySQL , you can use CHECK
TABLE or myisamchk periodically to check your tables.
See: http://www.mysq
Why don't you let mysql sort and limit the records for you? That's easy
enough. Just keep track of where you are in the database and select only
the records that you need.
- Original Message -
From: James Kupernik <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 16, 2002
Thanks for the explanation! Very clear.
How do you know how fragmented your DB is? I apologize if this is covered
somewhere, like I said I was very confused buy this whole topic.
Thanks,
-Lisi
At 01:00 PM 4/16/02 -0700, Frank Flynn wrote:
>Picture a Church, full of pews. This is your emp
I am retrieve records from my MySQL table and I want to display the results
12 per page along with allow for a sort. I was just send a query to the
table with a limit each time, but it didn't sort all the records, so I need
to load all the results into a table to sort then display. Here is what I
Picture a Church, full of pews. This is your empty table. As people (your
data) come in to the church they fill the pews but unlike real life the
first person goes all the way to the left hand side of the first pew, the
second sits next to them and the third... When one pew is full they start
Hi Thies,
Thanks for the response.
I already talked to oracle support and they said they won't support PHP as
they believe its not an OCI problem.
Anyway, I will send you the C program (sample program shipped with oracle) I
was testing with.
You can also find a simple PL/SQL progragram attach
On Wednesday 17 April 2002 00:36, Jonathan Hilgeman wrote:
> #2 Does anyone know about fax servers or how to obtain one?
If using *nix then www.hylafax.org.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet &
Where is your php binary? (try "which php") The command path under
crontab is not always the same as in a login shell, so you might need to
spell it out like:
*/10 * * * * /usr/local/bin/php /home/harpreet/crontest.php
-Steve
On Tuesday, April 16, 2002, at 12:17 PM, Harpreet Kaur wrote:
> T
>>At 03:54 PM 4/16/02 +, Harpreet Kaur wrote:
>>>Can i run a php page using a crontab job. I am trying to do so but no
>>>luck. My cron job statement is :
>>>* * * * * lynx /home/harpreet/crontest.php
>>>
>>>Actually i want to run a script every 10 minutes to do some background job
>>>like we
Thanks Lisi. The use of php in front of the path made
/home/harpreet/crontest.php run one time when run from the telnet prompt.
But it still doesnt run from the crontab. I created a mycron.txt file with
the below statement. The put crontab mysql.txt to specify the cron. But it
doesnt seem to r
hi
Depends a little on what you are doing next.
I am not an htaccess expert so this is written as a 'sessions' user, but if
you use a database/session system you have a lot of flexibility, and can log
what users are up to.
If it is well programmed, with security in mind you can make it very sec
Okay, this is a new one. I'm trying to figure out the best way to send a GIF
or JPG image to a fax machine using PHP and probably some other service
(since I can't think of any PHP functions that deal with faxing).
#1 Now, does anyone know of a good service that I could use that would work
well
On Tue, Apr 16, 2002 at 06:28:19PM +0200, [EMAIL PROTECTED] wrote:
> Put this on your php page
>
>
> Putenv("ORACLE_HOME=/home/oracle/8.0.5");
> Putenv("LD_LIBRARY_PATH=/home/oracle/8.0.5/lib");
> Putenv("TWO_TASK=WAGNER_PC");
no. do not use PutEnv or SetEnv in httpd.conf!
please set _
Hi there all,
I wonder if there are any people on this list who have much experience using sessions.
We have a catalogue, and I have never used sessions before, and finding it very
difficult to complete this project.
If there is anyone who could possibly spare some time, I would most appreciat
Put this on your php page
Putenv("ORACLE_HOME=/home/oracle/8.0.5");
Putenv("LD_LIBRARY_PATH=/home/oracle/8.0.5/lib");
Putenv("TWO_TASK=WAGNER_PC");
and test it work with version 8
Pedro SERE
P.SERE
EU - COMMISSION - SG
Internal Information
--
OK just tested against Apache-1.3.23 with the same result apache seg
faults.
Apache configured as before. PHP configured as before except with
--with-apxs=
Extra information:
ldd /usr/local/apache-1.3.23/bin/httpd
libpthread.so.0 => /lib/libpthread.so.0 (0x40016000)
libm.s
Try */1 * * * * php /home/harpreet/crontest.php
or */1 * * * * php ~/crontest.php
~ means your home directory.
I think this should work, every minute.
-Lisi
At 03:54 PM 4/16/02 +, Harpreet Kaur wrote:
>Can i run a php page using a crontab job. I am trying to do so but no
>luck. My cron
Can i run a php page using a crontab job. I am trying to do so but no luck.
My cron job statement is :
* * * * * lynx /home/harpreet/crontest.php
Actually i want to run a script every 10 minutes to do some background job
like we do in sql server. How can i do it with mysql and php.
Help is app
I have been asked to do a proposal for pretty simple CMS tool that will need
to handle multiple character sets including Kanji. of course we are using
PHP and the client has Oracle.
>From what I understand the administration pieces will be in English but will
display other language content.
As I
On Tue, Apr 16, 2002 at 04:48:19PM +0100, Paul Edmondson wrote:
> Hello there,
>
> I have a problem with getting php-4.2.0 RC4 connecting to an Oracle 9i
> (9.0.1) database running locally.
>
> I am running Apache 2.0.35 on SuSE 7.3.
does it work with apache 1.3.x?
>
> The problem that I
Hello there,
I have a problem with getting php-4.2.0 RC4 connecting to an Oracle 9i
(9.0.1) database running locally.
I am running Apache 2.0.35 on SuSE 7.3.
The problem that I have is when trying to initiate a connection to the
database apache seg faults.
An example of the code that causes t
On Tue, 16 Apr 2002 15:04:25 +0200
Jeroen Timmers <[EMAIL PROTECTED]> wrote:
> hello,
>
> i have a table with a datetime field,
> now i want to view al the records
> with time 12:00:00 and the date is
> not important.
>
> Who could help me?
>
> Jeroen
>
>
Try this :
SELECT * FROM TableName
That worked like a champThanks!!!
"Michael Virnstein" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> If you want the max if HUF, KM, EURO, KUNA you should do
> $sqlquery = "SELECT MAX(HUF) as HUF,MAX(KM) as KM, MAX(EURO) as EURO,
> MAX(KUNA) as KUNA from
If you want the max if HUF, KM, EURO, KUNA you should do
$sqlquery = "SELECT MAX(HUF) as HUF,MAX(KM) as KM, MAX(EURO) as EURO,
MAX(KUNA) as KUNA from $table limit 1";
"Ron Allen" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am trying to determine how
Brad Hubbard wrote:
> Can I get some feedback on the conventional wisdom as to the best solution
> for high volume registration and authentication of users accessing a secure
> site? I have worked before with database/session based methods as well as
> htaccess. Which is preferred? Are there al
I am trying to determine how to use the MAX() function
I was thinking about this
$sqlquery = "SELECT MAX(HUF,KM,EURO,KUNA) from $table limit 1";
any suggestions
here is the code:
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable toconnect to
database");
@mysql_select_db("$DBName") or die("
hello,
i have a table with a datetime field,
now i want to view al the records
with time 12:00:00 and the date is
not important.
Who could help me?
Jeroen
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Tuesday 16 April 2002 22:30, you wrote:
> I believe what you are looking for is:
> @pg_fetch_row( $result, $i++ )
>
> But check the manual for @.
>
> =C=
>
> *
> * Cal Evans
> * Techno-Mage
> * http://www.calevans.com
> *
Thanks, I think that's it
Bob Parker
--
PHP Database Mailing List (http
I believe what you are looking for is:
@pg_fetch_row( $result, $i++ )
But check the manual for @.
=C=
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: "bob parker" <[EMAIL PROTECTED]>
To: "PHP-DB" <[EMAIL PROTECTED]>
Sent: Tuesday, April 16, 2002 7:29
In the code shown below, everything works ok but php
displays an error message when pg_fetch_row tries to
access beyond the last row. How can I turn the error display
off?
// exec query
$result = pg_exec($dbcon, $sql);
$i = 0;
while (($row = pg_fetch_row( $result
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
says...
> Are there any good tutorials for beginners on forms and inserts into
> mulit-tables ?
>
>
>
Barry - try this for starters
http://www.google.co.nz/search?q=forms+insert+php+multiple+tables&hl=en&b
tnG=Google+Search&lr=
--
David Ro
Are there any good tutorials for beginners on forms and inserts into
mulit-tables ?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
This question comes about from these two fine articles
Building Dynamic Pages With Search Engines in Mind
http://www.phpbuilder.com/columns/tim2526.php3
Search Engine-Friendly URLs
http://www.promotionbase.com/article/485
I have a database of articles with atributes region
date and id - how s
On Mon, Apr 15, 2002 at 04:31:06PM -0700, Prince wrote:
> I don't think this is the bug with oracle as I was able to do the same with
> C program having OCI calls.
could you please send me this program?
thanx,
tc
>
> John, I am aware of this work-around. But this requires some chang
Hello,
Brad Hubbard wrote:
>
> On Tue, 16 Apr 2002 14:51, Manuel Lemos did align ASCII characters thusly:
> > > > then stored in cookie. The security weakness of this method is that if
> > > > the secret key leaks, hackers may use to forge new sessions.
> > >
> > > Is this documented anywhere?
>
49 matches
Mail list logo
