[PHP-DB] MS SQL date time strangeness

I have Apache 1.3 and PHP 4 running on Windows 98 connecting to a local MS SQL 7.0 server. MS SQL has the date as 2004-01-09 (-MM-DD), when I print the date to a webpage with this PHP code: printf("Date Picked Up: %s\nDate", date("Y/j/n",$row[0]); I get this output: 1969/12/31 What is wr

Re: [PHP-DB] MS SQL date time strangeness

return it using ISO format set mssql.datetimeconvert to "On" in the php.ini file, or use the following command: ini_set('mssql.datetimeconvert' , 1 ); -- bob On Mon, 26 Jan 2004, Steve wrote: I have Apache 1.3 and PHP 4 running on Windows 98 connecting to a local MS SQL

[PHP-DB] Windows XP and PHP

I installed Apache/Perl/PHP onto a Windows XP machine today and ran into this problem when I tried to access the MS SQL Server via PHP: "can't load dynamic library php_mssql.dll" The dll is in the extensions directory. Apache is running fine. Any ideas, on what might be wrong? -- PHP Databas

Re: [PHP-DB] Windows XP and PHP

Duane Lakoduk wrote: I installed Apache/Perl/PHP onto a Windows XP machine today and ran into this problem when I tried to access the MS SQL Server via PHP: "can't load dynamic library php_mssql.dll" The dll is in the extensions directory. Apache is running fine. Any ideas, on what might be

[PHP-DB] PHP and php_mssql.dll

I have the php_mssql.dll in the extension directory but when I execute a PHP page, I am told that the dll does not exist. This is on Windows XP Professional. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP and php_mssql.dll

Frank M. Kromann wrote: You need to install the MSSQL Client Tools or alt least copy ntwdblib.dll from the SQL Server (this will allow connections but not configuration). - Frank I have the php_mssql.dll in the extension directory but when I execute a PHP page, I am told that the dll does not

[PHP-DB] Bad date external representation

I am running into a "Bad date external representation" when I try to insert some data from one of my pages. This is the SQL statement: $sql="insert into Vehicle_List (Date_PU,Date_Called,Company,Stock_Number,VIN,Veh_Year,Veh_Make,Veh_Model,Veh_Color, PU_LOC,Recd_Orig_Title,Sent_Title,Recd_Title

[PHP-DB] Re: Inserting into Access

Try adding single quotes to the user and date fields George Pitcher wrote: > > Hi all, > > I'm having a problem inserting some php stuff into an Access table. > > This is what is being sent to Access: > > INSERT INTO ActivityLog (User, Docid, Date, ClientIP, Time, CourseRef) > VALUES >

[PHP-DB] Re: Date Question

One way you can do that is create a local variable and have that variable referenced in your form in either a hidden field or a text field. EXAMPLE $date = date("l F d, Y") (outputted that would be say Thursday April 4, 2002) then your field would look something like this depending how you wri

Re: [PHP-DB] Modify Query, or sift through results?

Couldn't you use"SELECT DISTINCT" for this? http://www.mysql.com/doc/S/E/SELECT.html - Original Message - From: "Joseph Koenig" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 27, 2001 8:54 AM Subject: [PHP-DB] Modify Query, or sift through results? > I'

Re: [PHP-DB] Linux/PHP/Interbase

if this is a stock out of the box red hat install, you will need to find the rpm that contains apxs (i forget which one) and install it. For some reason this is not installed by default. Seems like you can do a search on php.net for apxs and come up with the proper rpm name. - Original Messa

Re: [PHP-DB] Linux/PHP/Interbase

which will put apxs in the right spot with the right parameters inside." hope that helps. Steve - Original Message - From: "Todd Cary" <[EMAIL PROTECTED]> To: "Steve" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Se

[PHP-DB] Oracle TNS no listener

nction.oci-connect]: ORA-12541: TNS:no listener in ... Webserver is IIS on my local box. PHP is running on my local box. I've got TNS_ADMIN set as an env variable Any help gratefully received :-) Cheers Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: htt

Re: [PHP-DB] OCI8 and Listener

Stefan, can you connect with oracles SQL*Plus tool? Steve Farmer At 8:05 AM +0100 15/1/01, Stefan Fokuhl wrote: >Hi, > >i've compiled my php modul with oci8.But I can't connect to my db. It >tells me the error ORA-12162. In the documentation there is no such >error m

[PHP-DB] Message Boards

to post news items TIA Steve Farmer -- --- "I disagree completely with what you are saying, but I will defend to the death your right to say it" - Voltaire Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pt

Fwd: [PHP-DB] InterScan NT Alert

>Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm >list-help: >list-unsubscribe: >list-post: >Delivered-To: mailing list [EMAIL PROTECTED] >Date: Tue, 30 Jan 2001 10:34:49 +0100 (W. Europe Standard Time) >From: [

Re: [PHP-DB] Oracle TNS problems with PHP4?

Hi Mark, I run Oracle 8i with apache and PHP 4 on about 6 different machines , all connect to a remote DB and i have no problems @ all. Regards Steve Farmer At 8:29 AM -0600 2/2/01, Mark Farver wrote: >I am running Oracle 8.0.5 Net8 drivers on a Win95 system using Apache >and PHP4.04pl

Re: [PHP-DB] Remote Oracle Connection

endif; $query= "alter session set NLS_DATE_FORMAT = 'DD-MON-'"; $curs = ociparse($conn,$query) or die( "Unable to parse query" ); ociexecute($curs) or die( "Unable to execute query" ); HTH Steve At 11:49 PM -0600 4/2/01, Doug Schasteen wrote: >

[PHP-DB] sessions vars problem ....

$x<2004; $x++) { print "\t$x\n"; } echo ' '; echo ''; echo ''; --- sorry abouyt the log paste ... ok. this is what happens. when the user clicks today the date is set to todays. this works. when they choose a day, month or year t

Re: [PHP-DB] PHP4/Apache on Win95 to remote Oracle

ces in it Otherwise it must be something to do with the way php has been compiled ... if you do a phpinfo() do all the environment variables look OK and is OCI8 support complied ? I have connected remotely from linux/apahe to a variety of oracle DB's on a variety of remote platforms HTH

[PHP-DB] my sql text query

the table when the table was already populated and when try to read it i get errors saying the index is not defined ... if i change it to varchar(255) there is no problem ? can anyone help ? Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confidential information may be co

Re: [PHP-DB] PHP/Oracle/mod_ssl/Apache

le of parameters .. 1) no of connections allowed in apache. (this could explain why SSL id different to NON-SSL connections) 2) no of sessions an oracle user is allowed to create. 3) How many connections we provide in the oracle listener connection pool. Regards Steve Farmer At 1:41 PM -0600 9

FW: [PHP-DB] Using selected fields

-Original Message- From: Steve Brett Sent: 12 March 2001 11:40 To: '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] Using selected fields I have a similar security setup in the app i'm working on at the moment, but attack from a slightly different angle. i have two tables,

RE: [PHP-DB] PHP Bug or configuration error?

e php installer makes (or should make) to the config. HTH Steve -Original Message- From: Pierre Jochem [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 12:09 To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP Bug or configuration error? Hallo listmembers, i have a misterious error with php4.0.4

RE: [PHP-DB] Using text files instead of a DB

so ... Virtual Web Site Hosting* 250 MB - $199.99/year & one time setup fee. if i divide 199 by 12 i get 5 -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 14:39 To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Using text files ins

RE: [PHP-DB] Using text files instead of a DB

ah ... apologies i was confused by the 'i want to pay by check' on an otherwise blank page. following the link does indeed give the offers you suggested. shame i'm in the uk ... once again, apologies abound. Steve -Original Message- From: Rick Emery [mailto:[

[PHP-DB] File Optimisation

? Thanks in advance, Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confidential information may be contained in this message. If you are not the original addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver

RE: [PHP-DB] what is connection id?

AFAIK the connection id is a used by the server to identify the correct connection. if it reset itself there would be duplicate connections. e.g. user 1 connects and gets connection 1. user 2 connects and gets connection 2. then disconnects. if the connection index was reset user 2 would get c

RE: [PHP-DB] File Optimisation

g. 2. Creating javascript functions for even the smallest inline feature such as mouseovers. Regards Mark > -Original Message- > From: Steve Brett [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 14, 2001 4:02 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] File Optimisat

RE: [PHP-DB] File Optimisation

next few weeks. :-) -Original Message- From: Mal McKay [mailto:[EMAIL PROTECTED]] Sent: 14 March 2001 17:12 To: Steve Brett Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] File Optimisation I wouldn't know about flushing the buffer. Another approach would be changing to ADO. This being an intra

RE: [PHP-DB] Login System with access levels

didn't pick this up until after the weekend. but i completely agree. i use plain text passwords in the stuff i use at work (just intranet sheared calendars) but i wouls also argue if they (hackers) have access to your db, to get at your passwords, then your system is gone anyway. i have a table

RE: [PHP-DB] Strings

$row[Primaryexpertise] //not like this $row['Primaryexpertise'] //like this $row["Primaryexpertise"] //or like this >i always user double quotes with postgrtesql and it works like a treat. > the difference seems to be with mysql. Also, even though simple variable references are expanded within

RE: [PHP-DB] Expires Pages

this should work ... in the top of the page, before any other headers are sent > -Original Message- > From: Marcelo Pereira [mailto:[EMAIL PROTECTED]] > Sent: 20 March 2001 12:32 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Expires Pages > > > Hello, > > I'd like the user of my site t

RE: [PHP-DB] problems configuring php and postgres - "call to undefined function"

/postgresql/ and not /usr/local/pgsql php needs to see the source code not the install dir. Steve > -Original Message- > From: Gary Huntress [mailto:[EMAIL PROTECTED]] > Sent: 20 March 2001 12:39 > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] problems configuring php and p

RE: [PHP-DB] problems configuring php and postgres - "call to und efined function"

DIR. this did not work when i compiled. pointing at the source did. i tried pointing php at both dirs to no avail. > -Original Message- > From: Rasmus Lerdorf [mailto:[EMAIL PROTECTED]] > Sent: 20 March 2001 16:09 > To: Steve Brett > Subject: RE: [PHP-DB] problems conf

RE: [PHP-DB] problems configuring php and postgres - "call to und efined function"

from phpinfo() './configure' '--with-mysql=no' '--with-apache=/usr/src/apache_1.3.14/' '--with-pgsql=/usr/src/postgresql-7.0.3/' '--with-xml' '--enable-track-vars' '--enable-trans-sid' '--with-gd' Steve >

RE: [PHP-DB] Yet more strings

if there were extra chars at the front and end of primaryexpertise Steve > -Original Message- > From: Johannes Janson [mailto:[EMAIL PROTECTED]] > Sent: 21 March 2001 12:00 > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Yet more strings > > > Hi, > > I

RE: [PHP-DB] Select where date is in period

"); you also had 2 WHERE clauses. there can be only one. like the highlander. so if $checkdate was 2001-03-22 then the query would look like this to the db: select * from plant.eqpt where date_online <='2001-03-22' AND date_offline =>'2001-03-22' order by type,size

RE: [PHP-DB] Select where date is in period

i think i also used >= to indicate 'equal or greater to than' instead of => like you have ... Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confidential information may be contained in this message. If you are not the original addressee indicate

[PHP-DB] classes and sessions

er pages and scripts ? Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confidential information may be contained in this message. If you are not the original addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy o

Re: [PHP-DB] classes and sessions

created via the constructor using new. what you've suggested makes perfect sense. thanks again. Steve ""Cal Evans"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Yes. > > You can create your class, instantiate

Re: [PHP-DB] Indexing help

replies below: ""M. Verheijen"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Dear reader, A newbie mysql/php-question here! I've filled a mysql-database with about 1600 records. All these records contain items which are on sale on a website. Every row contain

RE: [PHP-DB] get_browser()

i use get_env("HTTP_USER_AGENT") to log browser types and it works fine. to be hones i didn't know about the get_browser function ... user agent suplies loads of info though about browser, platform etc. Steve Brett Internal Development EMIS Ltd. "Privileged and /or Conf

RE: [PHP-DB] Editing DB entries via form

use isset($checkbox) where $checkbox is the name of the check box on the page that processes the form. Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confidential information may be contained in this message. If you are not the original addressee indicated in this messag

Re: [PHP-DB] Update query problem (Oracle)

Hi Francesco, Probably the easiest way is to load the records from table 2 into an array and then lopp through updatign table 1 HTH Steve At 9:37 AM +0200 28/3/01, Francesco D'Inzeo wrote: >Hi everyone. > >The scenario: > >Table1 Table2 >Field_01,

[PHP-DB] Re: Record Numbering - was SELECT MAX(ID) PLUS 1

Table - record_numbers RECNUM_PKEY (Primary Key) (this holds the Table ID or Key eg "L1", "L2" etc) RECNUM_VALUE (holds the next record number) you could easily write a php function to get the next record number for any table.. This ma

Re: [PHP-DB] Oracle8i, PHP4, Apache

his in you init.ora file i beleive HTH Steve At 7:02 PM +0200 31/3/01, Martin Lustig wrote: >Hi all, > >i have a trouble with settiong of environment for apache web server with php >and oracle8i database. >My connection to the database from php script thru OCI functions working but

RE: [PHP-DB] ecommerce - storing as an array or temporary record

there is an excellent tutorial with a coded example of a shopping cart using sessions. http://www.phpbuilder.com/columns/evert2816.php3 only takes small mods to extend it so you can delete from cart as well. Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confide

Re: [PHP-DB] Passing the value of a variable from PHP to JavaScript.

ott but should work steve } Prabu Subroto wrote: Dear my friends... I have my code like this : == function tes(){ document.write('<p>JavaScript</p>'); window.location.replace('<a href="http://192.168.23.1/coba/coba.php?vtes=$vtes">http://19

Re: [PHP-DB] Using results for next query

else you need to do ... } hth steve Shannon wrote: Hi People, Am needing a little help on the following scenario. Selecting user_id from one table for all entries that match the required criteria. Now I want to use the user_id's that are returned by the previous query

[PHP-DB] session_start

php.ini-recommended and php.ini-dist. **What am I doing wrong?** Thanks, Steve [EMAIL PROTECTED] --- Find My Favorite Movie http://localhost/practice/moviesite.php?favmovie=$myfavmovie'>"; echo "Click here to see info about my favorite movie.";

Re: [PHP-DB] LAMP

Almost all major Linux distros. come with Apache and PHP. I know that redhat 9 even had php/mysql. Fedora core has it too, however none of them have php 5 that i know of. Steve Gavin Amm wrote: I'd really like to find a Linux distro that is a LAMP system right out of the box. (Linux, A

[PHP-DB] oop?

my current scripts, which use classes all go in under 1 second, and thats when the server is under strain. Any explanation would be appreciated. Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] LAMP

Hi Gav SuSE will work outta the box. Just make sure you've selected the components and Yast will configure more or less everything to work together before installing cheers Steve Gavin Amm wrote: I'd really like to find a Linux distro that is a LAMP system right out of the box. (Lin

Re: [PHP-DB] Please help

What's contained in $sql and $sql_ext ??? Stuart Felenstein wrote: I'm using a product called dbqwiksite pro. PHP generator for PHP - MySQL The code seems to be working fine except in my search page where I receive an "invalid query" $result = mysql_query($sql . " " . $sql_ext . " limit 0,1") or

[PHP-DB] replacing dynamic variable in preg_replace

x27;m setting off variables with a --, so if variables $title, is in the mysql, the above example would be --title-- instead. When i do the above i would just get like $title as an output. I think its due to how mysql is storing the information, but a stripslashes didnt work. If anyone can help i

[PHP-DB] php_mysql.dll (5.0.2) and libmysql.dll (4.0.20a) incompatibilities

but in the meantime will attempt to 'fix' the problems with a recompile (which could take me some time as I need to install a compiler, the source, make the edits and test). I'll post my results. Thanks, Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] "The" Debacle

Hi, I have a similar system.. only problem is a band called "The The" :) we manually entered and corrected the artists http://www.musicexperts.com/ steve At 11:16 PM + 24/2/02, Peter Lovatt wrote: >When you add the data > >//does it begin with 'The '? >$n

Re: [PHP-DB] PHP + Oracle + Redhat Linux Stupid Question Maybe? Sorry

Hi Jason, You need the Oracle client installed and working rgds Steve At 11:39 AM -0500 1/3/02, Jason Lehman wrote: >This may be a stupid question but I am stuck. Do I have to have the Oracle >Linux Client to connet to a remote Oracle Database or can I just have the >php --with-oci8

Re: [PHP-DB] help php4.0.6&Oracle9i !

a_logon, you need to use the OCI functions !! HTH steve At 11:56 AM +0100 12/3/02, varin valery wrote: > I was successful in compiling php with the options --with-oracle >and --with-oci8. > but when i tried to connect to the database with the instruction >Ora_logon(

Re: [PHP-DB] SQL statement - PHP/mySQL - brain fart

AND s1.site_id=s2.site_id It worked like a charm! Thanks to all who replied! Steve > You may wanna do: > > CREATE TEMPORARY TABLE tmp1 SELECT * FROM site_category WHERE > category_id=$category_id_1; > > ok this will give us the records that matches $category_id_1

Re: [PHP-DB] elseif statement syntax

re's nothing to fail, or at least no mysql errors. -Steve On Wednesday, March 20, 2002, at 10:41 AM, Andrea Caldwell wrote: > Hi All, I'm pretty new at this, so go easy on me please ;-) > > What is wrong w/ this syntax? If the search results are 0, it just > display

[PHP-DB] Selecting Drop Down Value From DB to Edit

I have the below code that populates a drop down list. The code will correctly insert the value $StateID into another a table. The problem I am running into is that when I select the record to edit the drop-downlist has the first option as the value instead of what the corresponding StateID in the

Re: [PHP-DB] Selecting Drop Down Value From DB to Edit

;/td> </tr> <tr> <td width="10" bgcolor="#ff"> <td valign="middle" height="25" class="raceresutlstitle" bgcolor="#ff">Race

Re: [PHP-DB] Images on MySQL

I can put the images anywhere I like. I guess I could mount an image directory over NFS, but it seems easier and more consistent to use sql. Any thoughts on this? -Steve On Friday, March 29, 2002, at 05:43 AM, Jason Wong wrote: > On Thursday 28 March 2002 19:35, Clever wrote: >> Hi, >

[PHP-DB] php variables.

e a better way or am I on the right track. Thanks. Steve. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] HTML tables in PHP

. Check out the list at http://www.php.net/links.php -Steve "; while($row = mysql_fetch_array($ret)){ // note: indenting your code in loops makes it much easier to see what's going on :) $image = $row['image']; $name = $row['name'];

Re: [PHP-DB] Using include file

Just a guess: Are you doing the include from a function? If so, make sure you explicitly mark your global vars. Otherwise, what's the error message? -Steve On Friday, April 12, 2002, at 12:28 PM, Alex Francis wrote: > I have one site which I am having problems connecting to my

Re: [PHP-DB] Using include file

I pasted your code into a file testinclude.php (changing only the server name), then wrote another file test.php: It parses okay for me. How are you doing the include? -Steve On Friday, April 12, 2002, at 03:02 PM, Alex Francis wrote: > I get a parse error on line 2. The code is

Re: [PHP-DB] Arrays

x27;, '$eventdate[1]', '$eventdate[2]', ...)"; Otherwise, if they're all supposed to go into the same field then do something like: $eventdatestring = join("-", $eventdate); $query = "insert into ... values ( ..., '$eventdatestring', ...)";

Re: [PHP-DB] cron job and php

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

[PHP-DB] odbc versions

ggestions? And will a database driver for one work with the other or are they incompatible? Thanks. -Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Date of Birth From Form

A combination of strtotime() and date() can make this easy. date("Y-m-d", strtotime($birthday)) Or see docs and comments at http://www.php.net/manual/en/function.strtotime.php -Steve On Friday, April 19, 2002, at 01:29 PM, Brandon Paul wrote: > Hey all, > > I have a cred

[PHP-DB] indexing

are datetime fields. Should I use all these indexes or is this overkill? Thanks for any input Steve. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] THIS IS A HOAX !!! WARNING !!Re: [PHP-DB] Virus alarm!

Folks, check anti virus sites this is a hoax and will destroy your windows system !! regards Steve At 11:25 AM +0200 16/5/02, Trond Erling Hundal wrote: >Jeg fikk en mail fra en I adresseboken min om et nytt virus, som hadde >slettet hele harddisken hans! >Jeg fant da også ut at jeg ha

[PHP-DB] dba_delete() problems

ing Apache 1.3.24 and PHP 4.2.1 on Windows XP Professional. The database is accessed using the db3 handler. Thank you in advance for any replies, Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Innodb and transactions.

There's no documentation yet. I'm using php4 with mysql 3.23.49-max, and my tables are Innodb. I appologize if my lingo is somewhat confusing or just wrong but I'm pretty new to this stuff. Any input or examples would be greatly appreciated. Thanks, Steve. -- PHP Database Mailing List

RE: [PHP-DB] Innodb and transactions.

So should I be using Innodb tables or BDB tables? Thanks, Steve. -Original Message- From: Michael Bretterklieber [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 2:49 AM To: Php-Db (E-mail) Subject: Re: [PHP-DB] Innodb and transactions. Hi, you have to do something like this

RE: [PHP-DB] Innodb and transactions.

Great! thanks for your help. -Steve. -Original Message- From: Michael Bretterklieber [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 9:11 AM To: Php-Db (E-mail) Subject: Re: [PHP-DB] Innodb and transactions. Hi, use InnoDB, because InnoDB supports row-level locking, and InnoDB

Re: [PHP-DB] sql standard

Hi, In Oracle they are all UPPERCASE !! Rgds Steve At 11:15 PM -0400 23/6/02, Gerard Samuel wrote: >Hope someone can confirm this. >I was moving a mysql dump to postgresql, and I had 2 tables with >MiXeD upper/lower case letters, that >got converted to lowercase. I found a discuss

Re: [PHP-DB] what the heck? (elementary question)

an you do a "get" and a "post" at the same time? Tacking the lastname onto the url as in "action=\"name.php?lastname=%s\"" is using a get method, but your form is supposed to set lastname using the post method. Is there some reason you want your script to

[PHP-DB] Re: [PHP] Usiing FOREACH to loop through Array

_array() function. It returns both an associative array - ie, elements of the form => - and a numerically indexed array (0, 1, 2, etc.). You can alter this behaviour by the second parameter of the function: see http://www.php.net/manual/en/function.mys

[PHP-DB] Re: [PHP] Usiing FOREACH to loop through Array

rses($session[id])) { print "", $Row['C.CourseName']; } -steve -- +----+ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis

[PHP-DB] Oracle IDLE_TIME Profile Parameter & plogon

if anyone had any pointers? Regards Steve Farmer -- - "Minds are like parachutes, they work best when open" Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: [EMAIL PROTECTE

Re: [PHP-DB] Oracle IDLE_TIME Profile Parameter & plogon

problems, apache is compiled with enable-sigchild on It is only one DB that is causing me any drama ! Regards Steve > > >Le lun 08/07/2002 à 05:45, Steve Farmer a écrit : >> HI all, >> >> I was wondering if anyone had experimented with the Oracle Profile &g

[PHP-DB] OCIPLogon , maximum number of sessions apache/php <-> Oracle

Hi all, Does anyone know how many sessions can be opened by apache/php to Oracle using OCIPlogon, or what parameter setting controls this? TIA Steve -- - "Minds are like parachutes, they work best when open" Support free speech;

Re: [PHP-DB] OCIPLogon , maximum number of sessions apache/php<-> Oracle

sessions after a certain amount of time , have you any experience with this? I have open_cursors = 500 processes = 200 max_enabled_roles = 30 regards Steve At 8:24 AM +0200 9/7/02, Michael Bretterklieber wrote: >Hi, > >this depends on your settings in the init.ora in the >directory

[PHP-DB] Delete from multiple tables with php

SQL doesn't support deletes from multiple tables. TIA, Steve. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP database

Hi, I would try to convince the admin that a DB like MYSql (which is actually part of the standard install under Redhat now) is much more secure than storing data in text files !! HTH Steve At 11:02 AM +0200 15/7/02, Tomator wrote: >Hello > >I'm to have database, but server&#

Re: [PHP-DB] header function

What's on line 3 of Auth_user.php ? If you have anything outside of the tags it will start the html output. Even just an empty line. -steve On Monday, July 15, 2002, at 04:09 PM, Mohammad Forouhar-Fard wrote: > > Hi, > I have a problem with function header("Location:

Re: [PHP-DB] or statement in url

How about http://www.xyz.com/foo.php?FooID[]=1&FooID[]=2 Then FooID will be an array of the values. -Steve On Thursday, July 18, 2002, at 03:20 PM, Matthew K. Gold wrote: > can I use an OR operator in a variable that is passed through a url? > > ex. how can I combine the

RE: [PHP-DB] time field query problems.

Ya I checked and the manual said that with a version 3.23 or higher you can use + and - signs instead of the date_add subtract. Either way it just returns null. Ever tried somthing like this? Thanks, Steve. -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED]] Sent: Monday

[PHP-DB] time field query problems.

is a MySQL (ver 3.23.49-max) time field, allows nulls, default is NULL. If this cannot be done in a query, whats the best way to compare time in php? Thanks, Steve. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] time field query problems.

Thanks, I wasn't sure what kind of field to use, I'll give the timestamp a try and set 0 as default. Regards, Steve. -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 6:34 PM To: Steve Bradwell; [EMAIL PROTECTED]; Php-Db (E-mail) Subject

Re: [PHP-DB] what's wrong with this ereg?

Well, one thing is you've got mismatched parentheses. You need another another opening paren right after the "if". Also, don't you need to escape the last hyphen in your character sets? As well as the . before the third character set? -Steve On Tuesday, August 20, 2002,

[PHP-DB] Large files using phpMyAdmin

server only using myphpadmin and I have tried getting a dump using IE and Netscape to see if it was IE messing the file up! Thanks a lot, Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] advise needed for 'authorized only' site

I do pretty much the same thing but with seesion vars, I just check that the user and level session vars are the appropriate values before I display confidential material. -Steve. -Original Message- From: Rob Day [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 11:22 AM To

RE: [PHP-DB] Session understanding

If you include the other page AFTER you do this check you'll be fine. So run your if statement and then add an else...include "other.php"; HTH, Steve. -Original Message- From: Rodrigo [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 9:38 AM To: PHP Subject: [

[PHP-DB] Dates

???       Thanks,         Steve _.-..-```---._..``\--.._ ../\```-._ ``-._ _/_ o \ _.-```.``. \`-._ _>=-. _.-`\_\ \ o `.(_`.__./ / |--``-`._##.` -` \ o `. `-`` _` o \#// / \ _.._

[PHP-DB] postgres cursors

hi, i have a function that returns a cursor. how do i get at it in php? here's my function: create function test3 (INTEGER) RETURNS refcursor AS ' DECLARE cursor1 CURSOR FOR select description FROM t0040stock_item WHERE stock_number = $1; BEGIN open cursor1; return (cursor1); END; ' LANGUA

  1   2   3   4   >