[PHP-DB] PHP+MySQL PROBLEM: mysql_fetch_fields mess?

2001-05-11 Thread Davor Pleskina
Hi Everyone, Is it just me, or something is BADLY wrong with some MySQL functions? Is there some rule in which order to call mysql functions? I made following routine: "); return 0; }; if(mysql_affected_rows()==0) { echo('No data.');

Re: [PHP-DB] Cookie effect

2001-05-11 Thread Jesse Scott
I believe that this is the default and only possible behavior. The browser won't return the cookie value until another page is loaded. But since you set the cookie on that page, you should still have access to the variables you used to set the cookie right? From the manual: "Cookies will n

Re: [PHP-DB] Cookie effect

2001-05-11 Thread Ashley M. Kirchner
On Fri, 11 May 2001, David Balatero wrote: > I have a login script that sets a cookie on your hard drive...the only > problem is, the cookie only comes into effect after I've clicked thru to > another page from login.php...any ideas on this? My (abridged) code is > currently: > > header("Set-Coo

[PHP-DB] Cookie effect

2001-05-11 Thread David Balatero
I have a login script that sets a cookie on your hard drive...the only problem is, the cookie only comes into effect after I've clicked thru to another page from login.php...any ideas on this? My (abridged) code is currently: If anyone could help me on this one, that would be great! Thanks, Da

[PHP-DB] mssql connect problem from php4 on linux

2001-05-11 Thread Peter Wilson
Hi everyone I am trying to set up php4, apache on linux redhat 7 to connect to Microsoft SQL server version 7 or 2000. I have downloaded the sybase open client libraries and installed the common rpm and the openclient rpm. When i try a mssql_connect("...","user","pass"); I get: Warning: Sybas

[PHP-DB] How do you make MySQL users so they can only view there database and not others while using php4

2001-05-11 Thread Dave Torres
I have some what of a security issue that I can't seem to solve. I run php4 and MySQL on a FreeBSD server with Apache 1.3 as the webserver and have users that I allow access to there personal database. (example: user johndoe uses database johndoe). I can configure "johndoe" so he can only have a

Re: [PHP-DB] Backup Database

2001-05-11 Thread Jason Stechschulte
On Fri, May 11, 2001 at 10:02:41AM +0800, Jennifer Arcino Demeterio wrote: > what will i do to have a realtime backup of my database? It would help to know which database you are using. -- Jason Stechschulte [EMAIL PROTECTED] -- Your csh still thinks true is false. Write to your vendor today a

Re: [PHP-DB] Checking abuses

2001-05-11 Thread Kelvin
Hi Vipin, Don't want to explain to much , I have my code here , you can look at it and put it into your coding. P.S don't worry, the code is working fine. --- Post Board ---

[PHP-DB] Checking abuses

2001-05-11 Thread vipin chandran
Hi, I am presently develepong a message board system. Can anyone tell me how to prevent abuses in the messages posted in the message board, from getting displayed?. thanx, vipin. vipin chandran [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAI

Re: [PHP-DB] Autoincrement Question

2001-05-11 Thread Angie Tollerson
hmmm, that's interesting...I believe you are right about the version glitch. I went to another database we have running on another server, it has 3.22.32 as you do. When I delete the last record and then add one it DID NOT reuse the number, but incrememented! However, v.33 IS NOT reusing num

Re: [PHP-DB] Autoincrement Question

2001-05-11 Thread Miles Thompson
Angie, Is there a bug here? How do you "re-add" a fourth record? Is 3.22.33 a development or a stable version? With MySQL 3.22.32, and table type of MyISAM I did not get re-use of the auto_increment keys , no matter where the records were deleted or inserted. Miles At 03:24 PM 5/10/01 -0500, An

[PHP-DB] Date formats from Postgres

2001-05-11 Thread Steve Brett
use $date=("d/m/Y",strtotime(value_from_db)); strtotime will convert a string value to a timestamp. Steve > -Original Message- > From: Sean Weissensee [mailto:[EMAIL PROTECTED]] > Sent: 10 May 2001 11:13 > To: PHPDB > Subject: [PHP-DB] Date formats from Postgres > > > > I am reading

RE: [PHP-DB] Date formats from Postgres

2001-05-11 Thread Steve Brett
use $date=("d/m/Y",strtotime(value_from_db)); strtotime will convert a string value to a timestamp. Steve > -Original Message- > From: Sean Weissensee [mailto:[EMAIL PROTECTED]] > Sent: 10 May 2001 11:13 > To: PHPDB > Subject: [PHP-DB] Date formats from Postgres > > > > I am reading

RE: [PHP-DB] No MySQL-Link resource supplied

2001-05-11 Thread Steve Brett
the link will be the link you set up to connect to mysql, or the resource id as php refers to it (i think) you'll have something like $link=mysql_connect(...) as below [example from manual] Steve > -Original Message- > From: Rankin, Randy [mailto:[EMAIL PROTECTED]] > Sent: 10 May

RE: RE: [PHP-DB] exit code generation, php shell script/standalone

2001-05-11 Thread Dave VanAuken
Hmmm, I woudl suspect that even embedding the perl in the PHP would still result in the PHP script getting the perl exit code, and not the program calling the PHP (or its parent) script... however, you provide an interesting train of thought... header("Location: local/or/absolute/path/t

RE: [PHP-DB] Odd - Even Results in a Table - Newbie question

2001-05-11 Thread Rubanowicz, Lisa
Thank you both for your replies All the Best Lisa -Original Message- From: Samuel Torton [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 12:34 PM To: Samuel Torton Cc: Rubanowicz, Lisa; '[EMAIL PROTECTED]' Subject: Re: [PHP-DB] Odd - Even Results in a Table - Newbie question sorry

[PHP-DB] php4 and sybase-ct seg fault

2001-05-11 Thread Paul Kozlenko
To All, Could anybody help me with my problem related to php4 with Sybase? The system concerned is running SuSE 7.1 Professional The installed package of SuSE with apache and php4 works fantastic. The SuSE version of php4 includes many of the goodies (more than I need except one). Using the sou

Re: [PHP-DB] Odd - Even Results in a Table - Newbie question

2001-05-11 Thread Samuel Torton
sorry, i made a mistake. correct with this : -- $j = 0 ; $k = 0 ; for ($i=0;$ihttp://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] Odd - Even Results in a Table - Newbie question

2001-05-11 Thread Samuel Torton
Hi, I think you could add the following portion of code inside your request in order to get two result arrays : odd[] and even[] -- $j = 0 ; $k = 0 ; for ($i=0;$i: > HI all, > I am just a beginner at this stuff but I can't get my head around the > logic > of get

[PHP-DB] Odd - Even Results in a Table - Newbie question

2001-05-11 Thread Rubanowicz, Lisa
HI all, I am just a beginner at this stuff but I can't get my head around the logic of getting Row 1 in the left hand side of a two column table and Row 2 data in the right hand side. Something like this ___ | Data from Row 1 in MySQL| Dat

Re: [PHP-DB] MySq lType and PHP??

2001-05-11 Thread Johannes Janson
Hi, > I'm trying to get MySql type of a field (as string) into a php script. sometime the answer is easier as you think: mysql_field_type(link_identifier); Johannes -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

[PHP-DB] Where I can find php_oci.dll ??

2001-05-11 Thread Sheeta
Dear, I am trying to connect Oracle 8i database with PHP 4.0 through IIS 5.0. I readed through the previous mail posted by others. It requires psp_oci.dll. I wonder where I can find it. Thanks a lot!!! Sheeta -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

Re: RE: [PHP-DB] exit code generation, php shell script/standalone

2001-05-11 Thread Russ Michell
Could you not use : or(header("Location: local/or/absolute/path/to/exit_script.php")); In the exit_script.php do [embed] some perl stuff - (Soz a bit vague, but you get the idea) Hope that is of help - if not, then feel free to call me 'dumbass' ;-) Cheers. Russ On Thu, 10 May 2001 18:27:33

[PHP-DB] RE: MySQL: CRITICAL problem

2001-05-11 Thread Simon R Jones
> The connection has already been established, and some data read from > database without problem. The connection was not closed, rather > left alive. > Now... > Why this happens when I try to execute additional query? Help, anyone! the connection variable is not global, so the function your MySQ