hello! I am new to the list and new to PHP, so please bear with me.
I have installed PHP and SYBASE, use phpinfo() I can see SYBASE module. I use
sybase_pconnect(servername,username,password) to connect to SYBASE,it was false, the
error: Message returned from server is invalid.
Please help me !
Can anyone recommend a good FAQ, Q&A or Knowledge Base script written in PHP?
Preferably one with an administration section and a queue for questions to be answered.
Larentium
> This seems to be a common problem, I dont know why PHP doesnt make a note of
> this on their website under the Oracle documenation.
Use the [Add Note] button.
-Rasmus
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail
This seems to be a common problem, I dont know why PHP doesnt make a note of
this on their website under the Oracle documenation.
The problem is that PHP/Apache needs to know these variables upon server
startup, not when it loads the specific PHP page.
So what you need to do is set these variabl
OK, I've now figured out how to activate the oracle commands and get php4 to
recognize them, but I cannot get the connection to connect. This is under
windows 2000: I've putenv oracle_home, oracle_sid and tns_admin and
ora_logon with the same name@tns and password that work under sqlplus - and
G'day!
A1: $ran3 is a random number/letter combination I'm using to identify a user.
It sets that random value in the database when they log in using their
username/password. All pages contained within check that number against the
database. Not the most secure of methods, but I'm only using ph
I running php4/apache under windows 2000.
What do I need installed on the computer to access my oracle server? (I
notice it refers to oracle_home, so I obviously need to install some of the
oracle client software on my machine).
Dr. John Coonrod, Vice President, [EMAIL PROTEC
> How about creating a separate table for each user and a column in the
> main table pointing to these user preference tables
I missed the first part of this thread, so forgive me if I'm missing
something, but that seems like a very bad idea.
What if 10,000 people sign up (for whatever this se
Szii
I suggest you test it. You will discover that the opposite is usually true.
Also, you may have discovered other reasons why Unified ODBC does not
fulfill the value of ODBC.
Best regards,
Andrew
Andrew Hill
Director Technology Evangelism
Hi!
Is there a way to eliminate a given difference in time settings?
I.e. the webserver runs at GMT+1, Oracle runs at GMT. I am using sysdate to
produce timestamps. But the time seems to be wrong, when viewed in the
webserver context.
Adjusting the time on the DB server is not an option. Any hi
How about creating a separate table for each user and a column in the main
table pointing to these user preference tables
kancha.
On Thu, 18 Jan 2001 21:53:55 -0700 (MST), John Starkey wrote:
> Can anyone tell me how to create child tables in MySQL? I'm creating User
> Prefs and need to store
Hi Sharif!
try...
$date1 = "2001-07-01";
$date2 = "2001-07-31";
$query = "SELECT * FROM table WHERE birthdays BETWEEN $date1 AND
$date2";
regards
Marcelo Gulin
Sharif Islam escribió:
>
> This is a simple mysql question i am having problme with.
> I have a table with name and birth d
Since you want your totaling calculation to be done on the client side, you
would need to use a client side scripting language like Javascript to do
this for you. PHP is server side and can't do the dynamic form updates that
you are referring to.
HTH
Sam Masiello
Systems Analyst
Chek.Com
(716)
I have a form with several text variable fields (30) in which the client is
asked to select and assign a weight to each variables that influenced their
decision to do something. The total weight of all selected variables must
total 100. I have a field "total weight" that I want the sum of the
a
Yeah, I'm using the Unified ODBC. The abstraction layer over DB2's CLI
is faster than "real" ODBC.
-Szii
At 08:57 AM 1/19/01 -0500, Andrew Hill wrote:
>Regarding the wrapper - I assume you are using the built-in unified-odbc...
>which isn't really ODBC.
>As I understand it unified-odbc is just
Hello Chad,
Chad Day wrote:
>
> I need some help selecting the last row in my database, and then moving
> backwards.. I can't just get mysql_num_rows and go back by 1, as some of the
> records are missing.. the ID field might have #'s like 1950, 1948, 1947,
> 1944, etc, and I don't want it to br
select * from BIRTHDAYS where substr(Date,5,2) = '07';
-Original Message-
From: Sharif Islam [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 19, 2001 11:56 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Date function.
This is a simple mysql question i am having problme with.
I have a tabl
This is a simple mysql question i am having problme with.
I have a table with name and birth date;
Joe | 1964-07-21
Mary | 1978-05-22
--
I want to get the name with birthdays in the month of July.
thanks
--
PHP Database Mailing List (http://www.php.net/)
To u
Hello everyone:
I am using PHP4 on MySQL 3.22.32
I wish to take multiple values from an html multiple select form
element, Where they will be compared to the content of a MySQL table
field containing multiple entries.
For Example: One field named 'sport' contains: soccer, basketball, golf
(s
newer versions of mysql allow for database replication. However the
client (php in this case) needs to be aware that all read requests can
go to slaves or masters. However all write request must go to the
master. is there a way to set this up in PHP?
thanks
nate
--
PHP Database Mailing List (ht
Hi
Thanks for your mail. But this is okay if I have only one variable, in
this case as per the manual it is: $i , but what'll happen if I have more
than two, and now I have three variables in my form to be checked and can it
be done in the Switch method ?. If yes, then pls. tell me how.
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] ("Noodles Grizzly") wrote:
> I'm using the setcookie function with the follwing.
>
> setcookie("randint", "$ran3", time()+9000);
>
> It sets the cookie, but refuses to use the variable contained within.
> I can't find any reference to it in th
Hi,
I´m using PHP 4.0.4pl1 with extension php_oracle.dll, Oracle client 7.3 with
the following products installed:
-
Call Interface 7.3.4.0.0
Objects for OLE 2.2.1.0.0
32 bit ODBC 2.5.3.1.0B
Support files 7.3.4.0.0
SQL*Net Client 2.3.4.0.0
... and others
--
cool, that's what I think I need (the data seek bit).. I'm not displaying
them all on one page, it's like display a row, go to the next page, display
the next row, repeat. I'll try it out, thanks a lot.
Chad
-Original Message-
From: Andrew Rush [mailto:[EMAIL PROTECTED]]
Sent: Friday, J
On Friday, January 19, 2001, at 10:15 AM, Chad Day wrote:
> I need some help selecting the last row in my database, and then moving
> backwards.. I can't just get mysql_num_rows and go back by 1, as some of the
> records are missing.. the ID field might have #'s like 1950, 1948, 1947,
> 1944,
> -Original Message-
> From: Chad Day [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 19, 2001 9:15 AM
> To: '[EMAIL PROTECTED]'
> Subject: [PHP-DB] Getting last row, moving backwards..
>
>
> I need some help selecting the last row in my database, and then
> moving backwards.. I can't j
I need some help selecting the last row in my database, and then moving
backwards.. I can't just get mysql_num_rows and go back by 1, as some of the
records are missing.. the ID field might have #'s like 1950, 1948, 1947,
1944, etc, and I don't want it to break by mistakingly trying to grab 1949.
Regarding the wrapper - I assume you are using the built-in unified-odbc...
which isn't really ODBC.
As I understand it unified-odbc is just a common function set as a minimal
abstraction to several databases whose syntax calls are fairly similar.
Have you tried a 'real' ODBC layer? e.g. compile
maybe I'm over simplifying... my apologies if I am but it looks like you're
testing each variable as a boolean value i.e. if(TRUE) so why not use a
switch/case statement... easier to write and saved on extraneous curly
syntax... look here
http://www.php.net/manual/en/control-structures.switch.php
Hi all
I have written the following code, but I dont' think it's a good way to
write like this. Is there some other way to do good programming for this ?!
**
if ($f)
{
$SQL .= " (FIRST_NAME
This could be one of several things.
The user you have (or havn't) set up doesn't have the right permissions
to query your database. So set one up using
mysql>GRANT ,SELECT,INSERT,UPDATE
mysql>ON 'database name'
mysql>TO username@host
mysql>IDENTIFIED BY PASSWORD 'your password'
mysql>FLUSH PR
Hi,
While I try to connect to remote MySQL server i recieve "Can't connect to
'host' (10060).
Where I can get description of retrieved error ?
Thanks,
Rosen Marinov
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:
Hello, "Ronnie Esguerra"!
You wrote:
> How can a port my memo fields in a dbf file to a Postgres
> table?
>
Use ODBC to retrieve memo field from .DBF
--
Piloteers do it on the road
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
Hello, "Wade Halsey"!
You wrote:
> sqlExecute( "select * from client where persal in "'
> (Select accno from
> BadClient where SkyTraceStatus = "''uploaded onto
> web''")"'");
>
Try
"select * from client where persal in (Select accno from
BadClient where SkyTraceStatus = 'uploaded onto web
use GROUP BY in your sql query. see books on SQL for details.
kancha.
On Fri, 19 Jan 2001 09:11:47 +0530, sarahana wrote:
> Hello,
> I was wondering if it would be possible to select values from a column
(lets say the column "year") so that each value gets retrieved only once...
for example,
35 matches
Mail list logo
