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:

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;$irows;$i++) { $tmp = $i % 2 ; switch ($tmp) { case 0: even[$j++] = row[$i] ; break; case 1: odd[$j++] = row[$i] ;

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] ?php $link = mysql_connect (localhost, username, secret) or die (Could not connect);

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 a data

[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 a data

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

[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:

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. --- html head titlePost Board/title /head body div

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

[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

[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: Sybase:

[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: ?php header(Set-Cookie: LoggedIn=1; path=/;); header(Set-Cookie:

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: ?php

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