[PHP-DB] RE: [PHP] Problems w/ goto

2010-12-17 Thread Steve Staples
to show the people in my office, and we all got a chuckle from teh XKCD comic in the PHP documentation for GOTO http://ca2.php.net/goto Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [PHP] Problems w/ goto

2010-12-17 Thread Steve Staples
On Fri, 2010-12-17 at 12:22 -0500, Robert Cummings wrote: On 10-12-17 12:08 PM, Steve Staples wrote: On Fri, 2010-12-17 at 10:50 -0600, Jay Blanchard wrote: [snip] Thank you with your excellent help in the past. Here is another puzzler I am trying to write a program that can have

[PHP-DB] EZPDO Replacement

2009-12-14 Thread Steve Weintraut
One of our programmers had done a fair amount of coding using the EZPDO ORM library and it is no longer supported, Does anyone have any experience migrating from EZPDO to another ORM library. Any recommendations?, Thanks in advance for your help. -- PHP Database Mailing List

[PHP-DB] PHP won't return any records

2009-06-30 Thread Steve Fink
appreciated. Best, Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Value of $_POST['submit']

2008-11-27 Thread Martin, Steve (MAN-Corporate)
your button as type=submit (?) Just suggestions - since I can't see the code. Steve - Original Message - From: Ron Piggott [EMAIL PROTECTED] To: PHP DB php-db@lists.php.net Sent: Thursday, November 27, 2008 7:02 PM Subject: [PHP-DB] Value of $_POST['submit'] I am working

[PHP-DB] Oracle TNS no listener

2007-06-07 Thread steve
-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: http://www.php.net

[PHP-DB] Is there any I can do to copy data from a mysql database to access database?

2007-04-23 Thread Steve Smith
I have a mysql database and would like to be able to copy the data from that to my access database. If there something that is freeware to do this? Or maybe someone has some code that might do this for me? Thanks in advanced. Steve -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Searching many-to-many map tables

2007-02-08 Thread Steve McGill
group_id_1=1 and group_id_2=2 into a map-table query in a better way than I've done already. Steve Chris [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Steve McGill wrote: Hello, I am trying to find out how to search a many-to-many map table efficiently. I have an example

[PHP-DB] Searching many-to-many map tables

2007-02-07 Thread Steve McGill
that they are all found for a user It works quite reliably I think but it's such a rubbish query that I was hoping that somebody could teach me some syntax that is better. Many thanks in advance, Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Undefined pg_prepare() in 5.6.1

2006-10-31 Thread Steve Mathias
be greatly appreciated. -Steve -- ( Stephen L. Mathias, Ph.D. ( s m a t h i a s ( ) Division of Biocomputing) @ p o b l a n o ) ( UNM School of Medicine ( . h e a l t h . ( ) ) u n m . e d u ) ( http://poblano.health.unm.edu

[PHP-DB] Copying a set of database records

2005-03-04 Thread Steve McGill
queries. Is there any way I can do this in one SQL query, somehow using a combination of insert and select? Thanks in advance! Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Problem with mysql_fetch_array after first loop...

2005-03-03 Thread Steve McGill
for example. also, how does extract() behave when trying to convert the [0] [1] [2] variables? you might be better off using mysql_fetch_assoc() Best wishes, Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Updating many records at a time

2005-03-01 Thread Steve McGill
. Is there some way I can combine this with IN() ? UPDATE products set sort_order= WHERE id IN('5','2','32'); Many thanks in advance for any help / advice. Best wishes, Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Updating many records at a time

2005-03-01 Thread Steve McGill
Steve McGill wrote: I have a situation where I am doing lots of complex sorting on records that already exist in a MySQL table. The table has a 'sort_order' field which means I can do a simple ORDER BY sort_order to keep it nice and quick on SELECT, it's only UPDATE which is slow

[PHP-DB] replacing dynamic variable in preg_replace

2004-09-15 Thread Steve Morgan
, is in the mysql, the above example would be h1--title--/h1 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 it'd be much appreciated. Steve Mo'gan -- PHP Database

Re: [PHP-DB] Please help

2004-09-08 Thread Steve Davies
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

Re: [PHP-DB] LAMP

2004-08-03 Thread Steve Davies
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. (Linux, Apache

Re: [PHP-DB] LAMP

2004-08-02 Thread Steve Morgan
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, Apache

[PHP-DB] oop?

2004-08-02 Thread Steve Morgan
, 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

[PHP-DB] session_start

2004-07-15 Thread Steve Butzel
this in php.ini-recommended and php.ini-dist. **What am I doing wrong?** Thanks, Steve [EMAIL PROTECTED] --- ?php session_start(); $_SESSION['username']=Joe12345; $_SESSION['authuser']=1; ? html head titleFind My Favorite Movie/title /head body ?php $myfavmovie=urlencode(Long Live

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

2004-02-27 Thread Steve Davies
be a bit ott but should work steve } Prabu Subroto wrote: Dear my friends... I have my code like this : == ?php echo html script language='JavaScript' function tes(){ document.write('pJavaScript/p'); window.location.replace('http://192.168.23.1/coba/coba.php?vtes=$vtes'); } /script body

[PHP-DB] Bad date external representation

2004-02-22 Thread Steve
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,

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

2004-02-16 Thread Steve
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] Windows XP and PHP

2004-02-07 Thread Steve
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 Database

Re: [PHP-DB] Windows XP and PHP

2004-02-07 Thread Steve
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

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

2004-01-27 Thread Steve
. To 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 7.0 server. MS SQL

[PHP-DB] MS SQL date time strangeness

2004-01-26 Thread Steve
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

[PHP-DB] Apache 2

2003-11-03 Thread Steve Vernon
it's ok! Thanks, Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL Query not working via PHP

2003-10-18 Thread Steve Davies
remove the comma after cadet.photo, ie select cadet.relation2,cadet.photo FROM HTH steve Matthew Moldvan, Jr. wrote: I would say try single quotes instead of double quotes ... let me know if that works ... Regards, Matt. - Original Message - From: Sean Smitz [EMAIL

Re: [PHP-DB] parse error.

2003-09-25 Thread Steve Davies
Hi Micella You need to either slash-escape your insert query or use single quotes: $query=insert into dene (day,start_time) values (\2003.09.25\,\22:30\) ; or $query=insert into dene (day,start_time) values ('2003.09.25','22:30') ; steve M|cella Erdem Efe wrote: I am a new programmer

Re: [PHP-DB] Re: How to get PHP to download web contents

2003-07-07 Thread Steve B.
be in headers. Is there any header info todo with authentication which come from the client which are not set by doing the url name and pw? Thanks, Steve --- Ognyan Bankov [EMAIL PROTECTED] wrote: Steve B. [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi Nadim, It works

[PHP-DB] stripping a get variable out of url string

2003-07-05 Thread Steve B.
I have an online tutorial build into a web page. It has button next step. If you are on page index.php?abc=123 for instance the code is smart enough to make it index.php?abc=123step=x The problem is how to remove step=x from the old url string so that steps don't pile up.

[PHP-DB] How to get PHP to download web contents

2003-07-03 Thread Steve B.
How would you get PHP to download a file such as a web page and put it in a string? What keywords would relate to this (besides php download) I need a user to be able to put in a name and pass and have PHP go to a cetain site. The site can take the user/pass in the url so I do not need a form

Re: [PHP-DB] Re: How to get PHP to download web contents

2003-07-03 Thread Steve B.
Hi Nadim, It works but not for sites with password window that pops up. It is not the html based password but the browser window kind. Do you know what this kind is called? I've been searching 'php get html password' etc... Thanks Just a note the other example posted causes my computer to

[PHP-DB] add source code from form to DB - quote error- tried addslashes..

2003-06-26 Thread Steve B.
Hi I spent my 6+ hours trying yesterday to get a form to submit source code to the db. The data gets in the db fine if it is just plain ascii. The server has Magic Quotes on and this is bad according to most but should not stop it from working- in fact it should just work. Short Source is here

[PHP-DB] php admin text edit then crash question

2003-06-26 Thread Steve B.
I can post some source code by form to db and it all looks good in the db. When using phpadmin and adding wow to the end of the source phpadmin gets a quote error. The db field holding this is text. Why would it get a quote error from that? Is this a server issue or my fault? (its hosted)

Re: [PHP-DB] Renaming all pages to .php

2003-06-20 Thread Steve B.
problem below and knowing this would make my PHP driven site appear to be a collection of html pages. Does anyone know how to do this or what it is called so I can research it? -Steve --- David Blomstrom [EMAIL PROTECTED] wrote: At 02:19 PM 6/20/2003 +0200, Thorsten Körner wrote

[PHP-DB] addslashes, stripslashes, htmlspecialchars

2003-06-13 Thread Steve B.
to make the spaces and other characters work. tried addslashes and noticed it does add them, right in the db. Is this the standard? add and remove slashes? other thing confusing me is the htmlentities which may do this better? Thanks, Steve __ Do you Yahoo!? Yahoo

[PHP-DB] simple date formatting?

2003-06-11 Thread Steve B.
Hi I'm looking to format a date but all I find is this date() function and it appears to be for current date? My variable $dbrec[ListDate] is printing: 4/30/2003 0:00:00 It needs to print 4/30/2003 Am I on the right track to try to do a (with right parameters) $formatted_date = date(M D

[PHP-DB] PHP web templates?

2003-06-11 Thread Steve B.
Hi I'm working on the site http://www.handheldwarez.com I really like these sites style of table cells and borders etc... http://tribes.sierra.com/ http://www.planetrenegades.com/modules.php?name=Web_Linksl_op=MostPopular http://www.tribes2maps.com/ I've seen PHP nuke templates and am thinking

[PHP-DB] PHP/MySQL beginner group project

2003-06-11 Thread Steve B.
Site: http://www.handheldspecs.com Benefit for helping: Better your PHP/MySQL Know what color/java/phone/game/handheld/mp3/radio/bluetooth to buy (yes Nokia-Ngage does all this) Link on front page of your choice MySQL people aren't necessarily PHP programmers. The site is in PHP so I picked

[PHP-DB] how to update field without using UPDATE query?

2003-06-09 Thread Steve B.
how to update field without using UPDATE query? I open the db at a certain ID then set $dbrec['field'] = new value How do you update the db? Thanks -steve - Do you Yahoo!? Free online calendar with sync to Outlook(TM).

Re: [PHP-DB] how to update field without using UPDATE query? you are kidding?

2003-06-09 Thread Steve B.
- From: Steve B. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, 09 June, 2003 19:29 Subject: [PHP-DB] how to update field without using UPDATE query? how to update field without using UPDATE query? I open the db at a certain ID then set $dbrec['field'] = new value How do you update

RE: [PHP-DB] how to update field without using UPDATE query? you are kidding?

2003-06-09 Thread Steve B.
It sounds like you are crying John. Perhaps you know this function? I'm trying to learn PHP holmes. Keep the insults to yourself and help out if you know the answer. --- John W. Holmes [EMAIL PROTECTED] wrote: in asp it lets me say ~get a record into dbrec which is a database object.

[PHP-DB] Way to update field thx Digital

2003-06-09 Thread Steve B.
the confusion came from. I'd like to help you. So I can attempt to do that, let's see the ASP code you're trying to convert to PHP. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Steve B. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, 09

[PHP-DB] php to make form field for each column then update page.

2003-06-08 Thread Steve B.
that record, setting the fields then updating it. Do you know example of this? Thanks -Steve __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- PHP Database Mailing List (http://www.php.net

[PHP-DB] Printing date as 04-06-03

2003-06-05 Thread Steve B.
Hi all, M-D-Y with leading 0 is how I would like to print dates at my exciting web page. I am trying DATE_FORMAT and my provider locked up?? :(= How would you print this? thx steve http://www.aifiles.com __ Do you Yahoo!? Yahoo! Calendar - Free online calendar

[PHP-DB] PHP Home 2.2.8

2003-03-31 Thread Steve Dodkins
Hi All Has anyone upgraded from PHP Home Edition 2.2.3 (from sourceforge.net) to version 2.2.8 ? and if so were there any issues? Steve Dodkins _ IMPORTANT NOTICE This email (including any attachments) is meant only for the intended recipient. It may also contain

[PHP-DB] posting variables

2003-03-28 Thread Steve Dodkins
as below? { $lim1 = ($lim1 + 10); echo $lim1; echo is set; } else { echo is not set; $lim1 = ($lim1 + 20); echo $lim1; } Regards Steve Dodkins _ IMPORTANT NOTICE This email (including any attachments) is meant only for the intended recipient. It may also contain

[PHP-DB] Oracle errors not returning w 4.30

2003-02-12 Thread Steve Farmer
Hi all, We recently upgraded to php 4.30 and now our oracle errors are not returning.. This used to work $errmsg = ocierror($err_curs); ocirollback($err_conn); $errtext = $errmsg['message']; TIA Steve

Re: [PHP-DB] Oracle errors not returning w 4.30

2003-02-12 Thread Steve Farmer
Hey Thies, Weird problem.. I have just discovered that it is not working on only some machines. does it depend on certain environment variables being set either at run time or during compile? Most likely it can't find the ora_messages I would imagine. Regards Steve At 12:41 PM +0100 12/2

Re: [PHP-DB] HTML tags in auth.php script

2003-01-10 Thread Steve Cayford
Check out the auto_prepend configuration option here: http://www.php.net/manual/en/configuration.directives.php I believe you can do this on a per-directory basis, but haven't tried it. -Steve On Friday, January 10, 2003, at 02:56 PM, [EMAIL PROTECTED] wrote: ThX John...One other

Re: [PHP-DB] SHOW PICTURE FROM DATABASE

2002-12-31 Thread Steve Cayford
On Tuesday, December 31, 2002, at 02:25 AM, nikos wrote: Steve   b. the _type is the type of the binary data. From the PHP manual read: $userfile_type - The mime type of the file if the browser provided this information. An example would be image/gif Ok, but it didn't look like you saved

Re: [PHP-DB] SHOW PICTURE FROM DATABASE

2002-12-30 Thread Steve Cayford
Some suggestions... On Monday, December 30, 2002, at 03:55 PM, Nikos Gatsis wrote: where showpict.php: $query=SELECT pict FROM pict WHERE pro_id= '$pro_id; (You're missing an end ' there, but apparently that's not the problem) $result=mysql_db_query($database, $query, $conn) or Die

[PHP-DB] Next/Prev 10 lines

2002-12-20 Thread Steve Dodkins
Has anyone got some code that will correctly display the next 10 line of a table with prev and next working? Or point me in the right direction for help? Regards Steve Dodkins IMPORTANT NOTICE The information in this e-mail is confidential and should only be read by those persons to whom

[PHP-DB] Windows vs Linux variable passing

2002-12-10 Thread Steve Stephens
\,$db) the nextpage.php will display the rows on the page but not in the header. I'm sure there is a better way to do all this but I don't know how. Any help or suggestions would be greatly appreciated. Thanks, Steve echo h1 ALIGN=\CENTER\First Page Title/h1br; $db = mysql_pconnect(server

[PHP-DB] right join

2002-11-21 Thread Steve Dodkins
ORDER BY labor_qty,$link); Regards Steve Dodkins IMPORTANT NOTICE The information in this e-mail is confidential and should only be read by those persons to whom it is addressed and is not intended to be relied upon by any person without subsequent written confirmation of its contents. ebm-ZIEHL (UK

RE: [PHP-DB] using php4 to connect to mysql (newbie question)

2002-11-20 Thread Steve Dodkins
Hi The latest PHP bible is now updated to 4.2 www.troutworks.com -Original Message- From: Snijders, Mark [mailto:[EMAIL PROTECTED]] Sent: 20 November 2002 12:18 To: 'mike karthauser'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] using php4 to connect to mysql (newbie question) read this

Re: [PHP-DB] Insert path string into Mysql

2002-11-18 Thread Steve Cayford
. '); -Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Pull Word Docs

2002-11-13 Thread Steve Dodkins
is there another way to represent the document path? Regards Steve Dodkins IMPORTANT NOTICE The information in this e-mail is confidential and should only be read by those persons to whom it is addressed and is not intended to be relied upon by any person without subsequent written confirmation

[PHP-DB] sql select

2002-11-12 Thread Steve Dodkins
AND works_orders_part_no=parts_no AND time2 = labor_wkyr ORDER BY labor_wkyr,works_orders_ord_no,$link); This works fine but if i add AND timea labor_time it fails Regards Steve Dodkins IMPORTANT NOTICE The information in this e-mail is confidential and should only be read by those persons to whom

RE: [PHP-DB] sql select

2002-11-12 Thread Steve Dodkins
Top man!! Many thanks Steve -Original Message- From: [EMAIL PROTECTED] [mailto:epeloke;echoman.com] Sent: 12 November 2002 16:02 To: Php-Db (E-mail) Subject: RE: [PHP-DB] sql select I don't think you can reference the aliased column timea in the select clause, I know sql server won't

[PHP-DB] ROugh idea of speed

2002-11-08 Thread Steve Vernon
of the speed and how many servers needed, my client wants to know how much it will cost to host the site. Anyone have any experience with holding a lot in MySQL? Any idea of speed would be great. Thanks, Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

[PHP-DB] Variables

2002-11-08 Thread Steve Dodkins
]; Regards Steve Dodkins IMPORTANT NOTICE The information in this e-mail is confidential and should only be read by those persons to whom it is addressed and is not intended to be relied upon by any person without subsequent written confirmation of its contents. ebm-ZIEHL (UK) Ltd. cannot accept any

Re: [PHP-DB] MySQL password protection?

2002-11-06 Thread Steve Cayford
the webserver is running as. -Steve On Wednesday, November 6, 2002, at 04:16 PM, 1LT John W. Holmes wrote: I was wondering if it is possible to protect my password to the MySQL-server from being in a PHP-script. Now I can't do that, so everybody who gets to see my php-sourcecode also can

[PHP-DB] Millions of records in MySQL

2002-10-25 Thread Steve Vernon
Hiya, I remember ages ago that mysql does not properly handle upwards of 10 million records in a table? Any details would be great! Thanks, Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Custom Sort Order in MySQL

2002-10-19 Thread Steve Vernon
, then A*, then A as seperate calls, but id prefer to get them all in the correct order as I belive this will be faster. Any help would be very much appreciated. Thanks! Steve

[PHP-DB] MS Access

2002-10-18 Thread Steve Dodkins
Hi Has anyone got a sample script that updates/adds and deletes records on an ms access database or can point me to a resource that will have one? Regards Steve Dodkins IMPORTANT NOTICE The information in this e-mail is confidential and should only be read by those persons to whom

[PHP-DB] Set Cookies

2002-10-15 Thread Steve Dodkins
is $vegetable/p; 14 15 else print phello your 1st visit ?/p; 16 17 ? 18 19 /body 20 /html Regards Steve Dodkins IMPORTANT NOTICE The information in this e-mail is confidential and should only be read by those persons to whom it is addressed and is not intended

[PHP-DB] echo printing a cookie

2002-10-15 Thread Steve Dodkins
Hi I'm trying to print the contents of a cookie (php 4.2.3) the syntax below is wrong but what should it be? if ($_cookie[cookiename]== TRUE) { echopyour cookie is $_COOKIE[cookiename]/p; } Regards Steve Dodkins IMPORTANT NOTICE The information in this e-mail is confidential and should only

Re: [PHP-DB] Birthdays!

2002-10-14 Thread Steve Vernon
Yeh but that does not take into account years does it? My table has there birth year, wont that mess it up and not work? I assume I need to do a function only on the months and days?? Thanks! Steve XX -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] MS Access Connectivity

2002-10-09 Thread Steve Dodkins
... If i copy the db to the local drive and amend the system dsn to map to the local drive it works, MS Excel can also connect to the db over the network. Any ideas? Regards Steve Dodkins IMPORTANT NOTICE The information in this e-mail is confidential and should only be read by those persons to whom

[PHP-DB] postgres cursors

2002-10-02 Thread steve shapero
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; '

[PHP-DB] Dates

2002-09-27 Thread Steve Vernon
, Steve _.-..-```---._..``\--.._ ../\```-._ ``-._ _/_ o \ _.-```.``. \`-._ _=-. _.-`\_\ \ o `.(_`.__./ / |--``-`._##.` -` \ o `. `-`` _` o \#// / \ _.._ \ o

RE: [PHP-DB] Session understanding

2002-09-26 Thread Steve Bradwell
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] Session

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

2002-09-23 Thread Steve Bradwell
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

[PHP-DB] Large files using phpMyAdmin

2002-09-22 Thread Steve Vernon
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] what's wrong with this ereg?

2002-08-20 Thread Steve Cayford
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, at 11:11 AM, [EMAIL

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

2002-07-30 Thread Steve Bradwell
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

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

2002-07-29 Thread Steve Bradwell
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.

2002-07-29 Thread Steve Bradwell
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] or statement in url

2002-07-18 Thread Steve Cayford
How about http://www.xyz.com/foo.php?FooID[]=1FooID[]=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 following two lines so

Re: [PHP-DB] PHP database

2002-07-15 Thread Steve Farmer
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's administrator

Re: [PHP-DB] header function

2002-07-15 Thread Steve Cayford
What's on line 3 of Auth_user.php ? If you have anything outside of the ?php ... ? 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:xy.php?var=2

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

2002-07-09 Thread Steve Farmer
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; visit http

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

2002-07-09 Thread Steve Farmer
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 initinstance.ora in the directory /opt/oracle

[PHP-DB] Delete from multiple tables with php

2002-07-09 Thread Steve Bradwell
, Steve. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2002-07-08 Thread Steve Farmer
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 parameters such as IDLE_TIME, CONNECT_TIME or SESSIONS_PER_USER in order

[PHP-DB] Oracle IDLE_TIME Profile Parameter plogon

2002-07-07 Thread Steve Farmer
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 PROTECTED] Tel: 612

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

2002-06-29 Thread Steve Edberg
-array.php -steve I'm hoping someone will spot my dumb mistake. Thanks very much for any help at all on this. Brad -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2002-06-29 Thread Steve Edberg
['C.CourseName']; } -steve -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http

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

2002-06-24 Thread Steve Cayford
to set one version of lastname and let the user type in a different version of lastname? If so try using the post method with an input type=hidden name=otherlastname value=$lastname. -Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] sql standard

2002-06-23 Thread Steve Farmer
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 discussion that sql

RE: [PHP-DB] Innodb and transactions.

2002-06-21 Thread Steve Bradwell
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

RE: [PHP-DB] Innodb and transactions.

2002-06-21 Thread Steve Bradwell
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

[PHP-DB] Innodb and transactions.

2002-06-20 Thread Steve Bradwell
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 (http://www.php.net

[PHP-DB] dba_delete() problems

2002-06-02 Thread Steve Gerhardt
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] THIS IS A HOAX !!! WARNING !!Re: [PHP-DB] Virus alarm!

2002-05-16 Thread Steve Farmer
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 hadde blitt

[PHP-DB] indexing

2002-05-03 Thread Steve Bradwell
. 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

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

2002-04-19 Thread Steve Cayford
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 credit application form

  1   2   3   >