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

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

2010-12-17 Thread Steve Staples
using basic and batch files... I honestly didn't even know that the GOTO was still in existence, especially within PHP. I had 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] 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 (http://www.php.ne

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

2009-06-30 Thread Steve Fink
004, Level 16, State 1, Server {servername}, Line 1 Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier." when I use the SQL Query above. Any assistance would be greatly appreciated. Best, Steve -

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

2008-11-27 Thread Martin, Steve (MAN-Corporate)
, or you didn't code 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" Sent: Thursday, November 27, 2008 7:02 PM Subject: [PHP-DB] V

[PHP-DB] Oracle TNS no listener

2007-06-07 Thread steve
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

[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/) To

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

2007-02-08 Thread Steve McGill
"select * from users where 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

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

2007-02-07 Thread Steve McGill
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
tly 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
obal namespace and can be quite dangerous as it might overwrite other variables. (this might be whats happening with the $result variable 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

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 > > S

[PHP-DB] Updating many records at a time

2005-03-01 Thread Steve McGill
to be able to put all of this into one query. 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

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

2004-10-05 Thread Steve Olney
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

[PHP-DB] replacing dynamic variable in preg_replace

2004-09-15 Thread Steve Morgan
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

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-02 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. (Lin

[PHP-DB] oop?

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

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, A

[PHP-DB] session_start

2004-07-15 Thread Steve Butzel
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] Using results for next query

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

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

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

[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, PU_LOC,Recd_Orig_Title,Sent_Title,Recd_Title

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] PHP and php_mssql.dll

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

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

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

2004-01-27 Thread Steve
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] 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 wr

[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&quo

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&

[PHP-DB] download php headers?

2003-07-10 Thread Steve B.
I'm trying to get a php page to go into a name/password header authenticated site and it doens't work (even though the same code works on a php auth site I post online) So I'm trying to find out how to print the headers receieved from a web page so I can go from there. How do I get http headers f

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 PROTECTE

[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=123&step=x The problem is how to remove step=x from the old url string so that steps don't pile up. index.php?abc=123&step=

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 overload.

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

2003-07-02 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 sub

[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) Tha

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

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

2003-06-20 Thread Steve Cayford
mple... If /all/ your serving up is going to be handled by php, why not register php to handle your .htm files? -Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2003-06-20 Thread Steve B.
your 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 wrot

[PHP-DB] addslashes, stripslashes, htmlspecialchars

2003-06-13 Thread Steve B.
ng 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!?

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

[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_Links&l_op=MostPopular http://www.tribes2maps.com/ I've seen PHP nuke templates and am thinking th

[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 Y",

[PHP-DB] Way to update field thx Digital

2003-06-09 Thread Steve B.
mpt 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]>

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. >

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

2003-06-09 Thread Steve B.
> www.becomingdigital.com > > > - Original Message - > 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 upda

[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).

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

2003-06-08 Thread Steve B.
't know what to search for - mostly tried 'dynamic forms' in google... Any help making update page iterate form contents and update db? I'd like to know a way to do it without an update statement- by opening that record, setting the fields then updating it. Do you

[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
m1 + 20); echo $lim1; } Regards Steve Dodkins _ IMPORTANT NOTICE This email (including any attachments) is meant only for the intended recipient. It may also contain confidential and privileged information. If you are not the intended recipient, any reliance on, use, disclosure, distributio

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

[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'];

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

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, bu

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 (my

[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 it is

[PHP-DB] Windows vs Linux variable passing

2002-12-10 Thread Steve Stephens
ytable WHERE myrow REGEXP \"$con\"",$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 ech

[PHP-DB] right join

2002-11-21 Thread Steve Dodkins
rd_no 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.

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
into PH_PHOTO (PHOTO_PATH) VALUES ('" . $path . "')"; -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
ay 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 of its contents

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

[PHP-DB] sql select

2002-11-12 Thread Steve Dodkins
o 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

[PHP-DB] Variables

2002-11-08 Thread Steve Dodkins
works_orders_part_no"]."".$myrow["works _orders_qty"]."".$myrow["labor_qty"]."".$myrow["labor_time"] ."".$myrow["timea"]; Regards Steve Dodkins IMPORTANT NOTICE The information in this e-mail is confidential and shou

[PHP-DB] ROugh idea of speed

2002-11-08 Thread Steve Vernon
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

Re: [PHP-DB] MySQL password protection?

2002-11-06 Thread Steve Cayford
user 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-sourcecod

[PHP-DB] select statement

2002-10-25 Thread Steve Dodkins
ult = mysql_query("SELECT * FROM labor, works_orders, parts where labor_ord_no = works_orders_ord_no AND works_order_part_no = parts_parts_no",$link); echo ""; echo"Works OrderPart NumberOrder QtyMade QtyOptions"; while($myrow = mysql_fetch_array($result)) Regards St

Re: [PHP-DB] Millions of records in MySQL

2002-10-25 Thread Steve Vernon
Which is the MySQL list you are talking about please? Thanks, Steve > On Friday 25 October 2002 16:10, Steve Vernon wrote: > > Hiya, > > I remember ages ago that mysql does not properly handle upwards of 10 > > million records in a table? > > > > Any d

[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 it is

[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) { echo"your cookie is" $_COOKIE["cookiename"]""; } Regards Steve Dodkins IMPORTANT NOTICE The informat

[PHP-DB] Set Cookies

2002-10-15 Thread Steve Dodkins
isting19.1.php on line 4 3 6 7 8 Listing 19.1 9 10 11 hello again your chosen veg is $vegetable"; 14 15 else print "hello your 1st visit ?"; 16 17 ?> 18 19 20 Regards Steve Dodkins IMPORTA

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] Birthdays!

2002-10-14 Thread Steve Vernon
birthdays.Suppose its simple to work out manually, but then have to mess around with days a month etc. Thanks, Steve XX

[PHP-DB] MS Access Connectivity

2002-10-09 Thread Steve Dodkins
d path sql state S1009 in sqlConnect ... 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

[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; ' LANGUA

[PHP-DB] Dates

2002-09-27 Thread Steve Vernon
???       Thanks,         Steve _.-..-```---._..``\--.._ ../\```-._ ``-._ _/_ 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: [

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 To

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

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-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
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] or statement in url

2002-07-18 Thread Steve Cayford
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] header function

2002-07-15 Thread Steve Cayford
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] 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&#

[PHP-DB] Delete from multiple tables with php

2002-07-09 Thread Steve Bradwell
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] 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 init.ora in the >directory

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

2002-07-08 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;

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

2002-07-08 Thread Steve Farmer
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] 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 PROTECTE

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

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

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

2002-06-29 Thread Steve Edberg
_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

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

2002-06-24 Thread Steve Cayford
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

  1   2   3   4   >