[PHP-DB] about create index in interbase

2001-05-12 Thread Pan Gang

 I create a table in PHP and next to create the index for it . But the
create index statment can't work in PHP. It can work in ISQL . It's a bug in
PHP?
 The program like that:
$sql = "CREATE TABLE $table_name (id integer ,name char(20))";
$ibase_query($conn,$sql);

$sql = "CREATE INDEX $table_index_name on $table_name (id)";
$ibase_query($conn,$sql);

the first part can work , but the second can't.



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




RE: [PHP-DB] variable vaule lost

2001-05-12 Thread David Balatero

So what's the problem? I'm kind of lost here..

-- David Balatero

-Original Message-
From: Sharmad Naik [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, May 10, 2001 1:26 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] variable vaule lost

pls look at the attachment
-- 
The secret of the universe is @*&í!'ñ^#+ NO CARRIER
___  _  _  _
|_|_||_||_||\/||_|| \
_|| || || \|  || ||_/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP-DB] variable vaule lost

2001-05-12 Thread Sharmad Naik

pls look at the attachment
-- 
The secret of the universe is @*&í!'ñ^#+ NO CARRIER
___  _  _  _
|_|_||_||_||\/||_|| \
_|| || || \|  || ||_/


");
$i=10;
for ($j=0;$j<3;$j++){
echo $j;
echo("");
}
echo("");
echo("");
?>
 how The variable being passed will be seen in the next form? 



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]


[PHP-DB] Date display problem

2001-05-12 Thread vipin chandran

Hi,
How do I display the time and date on my message board depending on
the time of the place from where the data is entered.Everytime the
date that is displayed is not what it was when the message was posted.

thanx,

vipin chandran
[EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] True and Flase in mysql !!

2001-05-12 Thread Tomás García Ferrari

Hello,

What about this:

MyColumn enum('true','false') default 'false'

>> hi all ..
>> What is the best way to create True\Flase field in mysql ??

Regards,
Tomas Garcia Ferrari

Bigital
http://bigital.com


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP-DB] ASE serversRe: [PHP-DB] php4 and sybase-ct seg fault

2001-05-12 Thread Alain DESEINE



Paul Kozlenko wrote:
> 
> Reporting errors to the web page I get;
> Warning: Sybase: Server message: Changed database context to 'pcs1prod'.
> (severity 10, procedure N/A) in /pcs/pk.php on line 10
> (where line 10 is actually the first line shown here - "sybase_connect")
> 
> Data does come back however after a long period.
> Does anybody have any clues I might look for?
> 
> I appreciate any help here from anybody.

The problem is that the standard install of php set the
"sybct.min_server_severity" to 10, and 10 is definitively not the first
level of error reporting for SYBASE servers. For example when you issue
a "use mydatabase" SQL statement, you got a message of severity 10 to
tell you that the database switching is ok ... 

The first real level of warning for a SYBASE server is 11 so you'll have
to edit your php.ini file and set the correct value to this parametters
!

Here is my own configuration :

sybase.min_server_severity  =   11  ; minimum server message
severity to display
sybase.min_client_severity  =   11  ; minimum client message
severity to display

Attention apparently these values doni't do anything with PHP4, or there
are here for compatibility from older version of PHP :

sybase.min_error_severity   =   11  ; minimum error severity
to display
sybase.min_message_severity =   11  ; minimum message
severity to display


Hope this will help you !

Alain.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] Cookie effect

2001-05-12 Thread Jason Brooke

> David
>
> > problem is, the cookie only comes into effect after I've clicked thru to
> > another page from login.php...any ideas on this?

Sure - it's because of the way the http protocol works.
If you've just set a value in a cookie, why do you need to read the cookie back
in order to check the value? You already have the value since you only just put
it into the cookie in the first place.




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] Cookie effect

2001-05-12 Thread Geoff Caplan

David

> problem is, the cookie only comes into effect after I've clicked thru to
> another page from login.php...any ideas on this?

You don't explain why you need to access the cookie immediately.

If you just want to check it has been accepted, the usual approach is to use
headers to do a redirect back to the same script. Then you can check if the
cookie is there. You need to use a POST or GET variable to indicate whether
you are in cookie writing or cookie checking state.

If this is a public site, be aware that some search engine bots don't like
fast redirects and will not index anything below this script on the site.

You can also do this with JavaScript I believe - not very reliable on the
open web though as it may be missing/turned off in the target browser. If
you look at the archives for the general mailing list you will find some
sample code.

Hope this is useful

Geoff Caplan


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]