[PHP-DB] Re: Get ID of ROW when using aggregate functions

At 03:00 09/04/2009, you wrote: Message-ID: To: php-db@lists.php.net Reply-To: "Ondrej Kulaty" From: "Ondrej Kulaty" Date: Wed, 8 Apr 2009 10:54:55 +0200 Subject: Get ID of ROW when using aggregate functions INSERT INTO `test` (`id`, `name`, `company`, `sallary`) VALUES (1, 'Jane', 'Microsoft

[PHP-DB] Re: Subject: php date/time zone

At 04:57 19/03/2009, you wrote: Message-ID: <49c1d0c8.30...@silverbackasp.com> Date: Thu, 19 Mar 2009 12:57:44 +0800 From: Ron Subject: php date/time zone Hi All, I have a form where in a user will enter a time and choose a timezone. based on those, i need to insert to db the time as the actu

[PHP-DB] Re : Problem with PDO exceptions

Message-ID: <49b2ce8f.1090...@theingots.org> Date: Sat, 07 Mar 2009 20:44:15 +0100 From: Daniel Carrera Hello, I have MySQL 5.1 and PHP 5.2. For some reason PDO is not throwing exceptions when I give it a broken SQL query. For example: try { $stmt = $db->prepare("SELECT * FROM foob

[PHP-DB] Re: Subject: PDO buffered query problem

At 13:40 24/02/2009, you wrote: Message-ID: To: php-db@lists.php.net,php-gene...@lists.php.net Date: Mon, 23 Feb 2009 18:16:01 + From: Stewart Duncan MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Subject: PDO buffered query problem

[PHP-DB] Re: New Table Creation with PHP Variables

At 12:43 29/12/2008, you wrote: Message-ID: <008b1179ce594ebea03cb06480182...@dragon> From: "Keith Spiller" To: "php_db" Date: Sun, 28 Dec 2008 17:39:08 -0700 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Tra

Re: Re: [PHP-DB] Building WHERE SQL clauses

At 03:46 16/09/2008, you wrote: Message-ID: <[EMAIL PROTECTED]> Date: Mon, 15 Sep 2008 18:33:04 +0100 From: "Stephen Wellington" <[EMAIL PROTECTED]> To: "Mike Sullivan" <[EMAIL PROTECTED]>, php-db@lists.php.net MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7

[PHP-DB] Re: Building WHERE SQL clauses

Message-ID: <[EMAIL PROTECTED]> To: php-db@lists.php.net Reply-To: "Mike Sullivan" <[EMAIL PROTECTED]> From: "Mike Sullivan" <[EMAIL PROTECTED]> Date: Mon, 15 Sep 2008 11:06:30 -0400 Subject: Building WHERE SQL clauses Hello all. I'm using PHP to build a query for a database that consists of m

[PHP-DB] Re: Sqlite 3 pdo update query problem

At 09:15 20/08/2008, you wrote: Message-Id: <[EMAIL PROTECTED]> From: Amy Gibbs <[EMAIL PROTECTED]> Date: Wed, 20 Aug 2008 09:08:42 +0100 I've managed to connect to my database, and run a select query, but now I need to run an UPDATE query and it just doesn't seem to take effect. Things I'd

[PHP-DB] RE : Subject: Formatting output with json_encode

From: Ron Piggott <[EMAIL PROTECTED]> Date: Mon, 14 Jul 2008 02:21:23 -0400 Message-Id: <[EMAIL PROTECTED]> Subject: Formatting output with json_encode I am using json_encode to output the results of a mySQL query which is part of a jquery & ajax. $result = json_encode($array); echo $result;

[PHP-DB] Re: Query Across DBMS Boundaries (Linked Database Servers?)

At 14:12 21/03/2008, you wrote: Message-ID: <[EMAIL PROTECTED]> Date: Thu, 20 Mar 2008 11:05:22 -0500 From: "Dee Ayy" <[EMAIL PROTECTED]> To: php-db@lists.php.net MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Subject: Re: Query Across DBMS Boundari

[PHP-DB] Re: Subject: ini_set ...

At 14:12 21/03/2008, you wrote: MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Date: Fri, 21 Mar 2008 10:11:58 -0400 Message-ID: <[EMAIL PROTECTED]> From: "VanBuskirk, Patricia" <[EMAIL PROTECTED]> To: Subject: ini_set ... I have the line "ini_set('display_errors', 'on')

[PHP-DB] RE: ordering date in varchar

Message-ID: <[EMAIL PROTECTED]> Date: Thu, 13 Mar 2008 14:05:39 +0530 From: "Vaibhav Informatics" <[EMAIL PROTECTED]> We have a problem. We have given the dates as date.month.year eg 27.12.2007 The field is named as varchar. We have to arrange ths list of dates in ascending order. Can anyone he

[PHP-DB] Re:Multiple values in SELECT query

At 19:34 09/03/2008, you wrote: From: Ron Piggott <[EMAIL PROTECTED]> Date: Sun, 09 Mar 2008 15:34:05 -0400 Message-Id: <[EMAIL PROTECTED]> What is the correct syntax for where the results may be 1 or 2? What have I done wrong? SELECT * FROM table WHERE name LIKE "ABC" AND listing_type = 1 or

[PHP-DB] Re: Subject: Ordering a varchar field in mysql

At 09:44 04/12/2007, you wrote: Message-ID: <[EMAIL PROTECTED]> Date: Tue, 4 Dec 2007 11:12:40 +0530 From: "Vaibhav Informatics" <[EMAIL PROTECTED]> *Questions on PHP* On PHP, OK sure In one of our tables, one of the field is acc_no, we had given the data type as varchar, since it could

[PHP-DB] Re: Subject: Accessing last inserted record in a PSQL Database table

At 23:50 26/11/2007, you wrote: Date: Mon, 26 Nov 2007 18:19:07 -0600 Reply-to: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Message-ID: <[EMAIL PROTECTED]> I need to access the last inserted record in a postgresql database table from php. I connect to the db using pg_connect I construct the query st

Re: [PHP-DB] Re: backup of database record before update

At 09:46 01/11/2007, you wrote: Message-ID: <[EMAIL PROTECTED]> Date: Thu, 1 Nov 2007 10:45:57 +0100 "Leo G. Divinagracia III" wrote: Stephen Sunderlin wrote: Neil, Have you had success with triggers. I couldn't get one to work and then saw discussion ... ...snip... ... on a 5.0.20nt box.

[PHP-DB] Re: backup of database record before update

At 06:57 28/10/2007, you wrote: Message-ID: <[EMAIL PROTECTED]> Date: Sun, 28 Oct 2007 14:56:12 +0800 From: Ronald Wiplinger <[EMAIL PROTECTED]> I need some hints how to do that. Maybe there is a template or an easy function available. I have a MySQL database with some tables. Everytime a tabl

[PHP-DB] Re: Dealing with Namespace/Colon in SimpleXML

At 06:57 28/10/2007, you wrote: Message-ID: <[EMAIL PROTECTED]> From: "Andrew Darby" <[EMAIL PROTECTED]> Hello, all. I'm trying to use SimpleXML to loop through an .xml file, but when I try to do the following, it chokes on the colon: foreach ($xml_data->dc:title as $item) { [do whatever here

[PHP-DB] Re: Subject: union/select statement & number of columns

At 19:31 19/10/2007, you wrote: Message-ID: <[EMAIL PROTECTED]> Date: Fri, 19 Oct 2007 09:24:38 -0600 Subject: union/select statement & number of columns Hello all, I receive an error of the following: The used SELECT statements have a different number of columns. Any help, pointers, tutorials a

[PHP-DB] [Correction] Re: [PHP-DB] PHP + PostgreSQL: invalid byte sequence for encoding

The solution is pretty simple once you hit it, and works in both MySQL and PGSQL because it's standard SQL-92 : $query="SET NAMES 'UTF-8'"; Sorry - I meant $query="SET NAMES 'UTF8'"; As you pointed out, it's UTF8 not UTF-8 ;-) Cheers - Neil -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] PHP + PostgreSQL: invalid byte sequence for encoding

At 01:18 23/07/2007, you wrote: Message-ID: <[EMAIL PROTECTED]> From: aldnin <[EMAIL PROTECTED]> Subject: Re: [PHP-DB] PHP + PostgreSQL: invalid byte sequence for encoding > This indicates that PHP not using UTF-8. That output is typical of > UTF-8 output as Latin characters. > I had similar p

[PHP-DB] Subject: sql statement - complex order by

At 20:36 02/07/2007, you wrote: Message-ID: <[EMAIL PROTECTED]> To: php-db@lists.php.net Date: Mon, 02 Jul 2007 14:34:35 -0500 From: Bryan <[EMAIL PROTECTED]> SELECT * FROM productgroup WHERE groupid = $productid AND label = 'Cats' ORDER BY title SELECT * FROM productgroup WHERE groupid = $pro

[PHP-DB] Re: Subject: auto_increment

At 03:04 14/04/2007, you wrote: From: Ron Piggott <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: PHP DB <[EMAIL PROTECTED]> Content-Type: multipart/alternative; boundary="=-xK5L7HjLIUaeMS/bzYQr" Date: Fri, 13 Apr 2007 22:03:59 -0400 Message-Id: <[EMAIL PROTECTED]> Mime-Version: 1.0 Subject:

[PHP-DB] Re: ORDERing two UNION queries

At 03:04 14/04/2007, you wrote: Message-ID: <[EMAIL PROTECTED]> Date: Fri, 13 Apr 2007 17:48:11 +0100 From: ioannes <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] MIME-Version: 1.0 To: [EMAIL PROTECTED] Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bi

[PHP-DB] Syntax Problem (Was : Date problem)

At 16:26 21/01/2007, you wrote: I have a date field in mysql called event_end . I want to run a query to find all records where the event_and is greater than today's date. I have written the following code. It does not work. Please point out the mistake. $today = getdate(); $sql="select * fro

[PHP-DB] Re: user directory from a form

Message-ID: <[EMAIL PROTECTED]> Date: Sun, 01 Oct 2006 17:45:03 +0200 From: Neil Jackson <[EMAIL PROTECTED]> MIME-Version: 1.0 To: php-db@lists.php.net Content-Type: multipart/mixed; boundary="000308070500010902000303" Subject: user directory from a form I apologise for using thi

[PHP-DB] Re: Subject: Using MAX with COUNT?

Message-ID: <[EMAIL PROTECTED]> Date: Sat, 22 Jul 2006 13:48:43 -0600 From: Skip Evans <[EMAIL PROTECTED]> MIME-Version: 1.0 To: Php-Db Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: Using MAX with COUNT? Hey all, I have a table like this:

[PHP-DB] Re: Subject: making an array from data in textfile

Message-ID: <[EMAIL PROTECTED]> Date: Sat, 22 Jul 2006 21:31:35 -0400 From: "Dave W" <[EMAIL PROTECTED]> To: Php-Db MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_Part_157142_2227727.1153618295222" Subject: making an array from data in textfile OK, so I have th

[PHP-DB] Re: Subject: Parse Problem

At 10:04 09/05/2006, you wrote: Message-ID: <[EMAIL PROTECTED]> From: "Andy Rolls-Drew" <[EMAIL PROTECTED]> To: Date: Tue, 9 May 2006 10:03:54 +0100 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_NextPart_000_0038_01C6734F.E1250C30" Subject: Parse P

[PHP-DB] Subject: Where did my Hard Returns go?

At 14:00 01/03/2006, you wrote: Message-ID: <[EMAIL PROTECTED]> From: "Jeff Broomall" <[EMAIL PROTECTED]> To: Date: Wed, 1 Mar 2006 09:00:03 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_NextPart_000_0014_01C63D0E.87271600" Subject: Where did my Hard Return

Re: [PHP-DB] Query select value on MAX Date

At 08:47 25/02/2006, you wrote: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_=_NextPart_001_01C63997.1A6B1B7D" Date: Sat, 25 Feb 2006 08:07:36 +0900 Message-ID: <[EMAIL PROTECTED]> From: <[EMAIL PROTECTED]> To: <'php-db@lists.php.net'> Subject: FW: [PHP-DB] Query

[PHP-DB] Re: Sessions help needed !!!

At 22:19 17/02/2006, you wrote: From: "Chris Payne" <[EMAIL PROTECTED]> To: Date: Fri, 17 Feb 2006 17:18:57 -0500 Message-ID: <[EMAIL PROTECTED]> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_NextPart_000_000F_01C633E6.3C6626A0" Subject: Sessions help needed !!!

[PHP-DB] Re: Subject: screen resolution!

At 08:41 05/02/2006, you wrote: Message-ID: <[EMAIL PROTECTED]> Date: Sun, 5 Feb 2006 02:44:19 +1100 (EST) From: JeRRy <[EMAIL PROTECTED]> To: php-db@lists.php.net MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-733704850-1139067859=:48594" Content-Transfer-Encoding: 8bit Subje

[PHP-DB] Freelancers, UK ?

Any UK based freelancers out there ? A contact at our sister company EPC Direct in Bristol is looking for somebody to tackle a couple of ECom sites. Need advanced PHP/MySQL, also expected skills in XML and XSLT - I don't have full details here of the brief. Duration likely to be one month ove

RE: [PHP-DB] Storing Credit Cards, Passwords, Securely, two-way encryption

From: "Dwight Altman" <[EMAIL PROTECTED]> To: "'Peter Beckman'" <[EMAIL PROTECTED]>, "'Neil Smith [MVP, Digital media]'" <[EMAIL PROTECTED]> Cc: Date: Mon, 9 Jan 2006 09:24:05 -0600 Message-ID: <[EMAIL PROTECTED]

Re: [PHP-DB] Storing Credit Cards, Passwords, Securely, two-way encryption

At 03:48 06/01/2006, you wrote: Date: Thu, 5 Jan 2006 22:48:24 -0500 (EST) From: Peter Beckman <[EMAIL PROTECTED]> To: John Meyer <[EMAIL PROTECTED]> cc: php-db@lists.php.net Message-ID: <[EMAIL PROTECTED]> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Subject: Re: [

[PHP-DB] Re: Cannot connect to a MySQL DB using a Class

At 00:46 05/01/2006, you wrote: Message-ID: <[EMAIL PROTECTED]> To: php-db@lists.php.net Date: Wed, 04 Jan 2006 16:45:54 -0800 From: Todd Cary <[EMAIL PROTECTED]> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: CAnnot connect

[PHP-DB] Re : Subject: using fsockopen to handle redirections

Date: Fri, 23 Dec 2005 10:04:16 + From: Yemi Obembe <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: using fsockopen to handle redirections Any way i can use fsockopen to detect url redirections? for example if ds: www.ex1.com redirects to www.ex2.com and i'm using: $fp = fsockopen(ww

[PHP-DB] Re: Subject: Scrolling News

At 20:39 22/12/2005, you wrote: Date: Thu, 22 Dec 2005 20:38:58 + From: Alex Major <[EMAIL PROTECTED]> To: Message-ID: <[EMAIL PROTECTED]> Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit Subject: Scrolling News Hi there. I'm trying to m

[PHP-DB] Re: CLOSE button or link

At 07:18 22/12/2005, you wrote: From: "Ron Piggott (PHP)" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: PHP DB Content-Type: text/plain Date: Thu, 22 Dec 2005 02:22:00 -0500 Message-Id: <[EMAIL PROTECTED]> Mime-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: CLOSE button or link W

[PHP-DB] Re: Date Formatting Question

Apart from anything, you need to supply an option value for each of those options, not just rely on the browser which will default to passing the option *text* back from the form, if you specify no value. So your option elements should read January Notwithstanding that, RE below - you guys a

[PHP-DB] Subject: GROUP BY [Was: SELECT]

From: "Ron Piggott (PHP)" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: PHP DB Content-Type: text/plain Date: Sat, 10 Dec 2005 20:04:28 -0500 Message-Id: <[EMAIL PROTECTED]> Mime-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: SELECT I am trying to put together a SELECT syntax. I

[PHP-DB] Re : [PHP-DB] MySQL Update Quandry

Message-ID: <[EMAIL PROTECTED]> Date: Sun, 27 Nov 2005 12:49:17 -0500 From: Glenn Deschênes <[EMAIL PROTECTED]> To: php-db@lists.php.net MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_Part_11492_6161784.1133113757293" Subject: Re: [PHP-DB] MySQL Update Quandry Th

[PHP-DB] Re: Subject: Login Auth help?

NO ! The headers have to be sent *after* you check the values of $_SERVER["PHP_AUTH_USER"] , which you changed inexplicably to $PHP_AUTH_USER (which is no longer a global variable in recent versions of PHP > 4.1). If they are not global variables within PHP then it'll treat them as local vari

[PHP-DB] Re:Login Auth help?

At 15:21 10/11/2005, you wrote: Message-ID: <[EMAIL PROTECTED]> Date: Thu, 10 Nov 2005 11:24:09 +1100 (EST) From: JeRRy <[EMAIL PROTECTED]> To: php-db@lists.php.net MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1489996746-1131582249=:37621" Content-Transfer-Encoding: 8bit Sub

[PHP-DB] Re: Subject: Specific order by MySQL statement

At 09:37 08/11/2005, you wrote: Message-ID: <[EMAIL PROTECTED]> Date: Mon, 07 Nov 2005 11:47:32 + From: Adrian Bruce <[EMAIL PROTECTED]> MIME-Version: 1.0 To: php-db@lists.php.net Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: Specific ord

[PHP-DB] Re: Complex Left Join

At 20:28 31/10/2005, [EMAIL PROTECTED] wrote: Message-ID: <[EMAIL PROTECTED]> From: "Keith Spiller" <[EMAIL PROTECTED]> To: "[PHP-DB]" Date: Mon, 31 Oct 2005 13:29:18 -0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_NextPart_000_0159_01C5DE1F.184D51C0" Subject

[PHP-DB] Re: Subject: Searching remote web sites for content

At 06:26 23/10/2005, you wrote: Message-ID: <[EMAIL PROTECTED]> Date: Sat, 22 Oct 2005 13:21:26 -0400 From: Joseph Crawford <[EMAIL PROTECTED]> To: "[PHP-DB] Mailing List" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_Part_33359_9054580.1130001686839" Subject: Re

[PHP-DB] Re: Subject: Searching remote web sites for content

At 16:17 22/10/2005, you wrote: Message-ID: <[EMAIL PROTECTED]> From: "ioannes" <[EMAIL PROTECTED]> To: Date: Sat, 22 Oct 2005 16:17:22 +0100 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7b

[PHP-DB] RE : Subject: com and retrieve text from word

Message-ID: <[EMAIL PROTECTED]> Date: Wed, 31 Aug 2005 12:54:42 +0900 From: Yui Hiroaki <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] MIME-Version: 1.0 To: php-db@lists.php.net Content-Type: text/plain; charset=ISO-2022-JP Content-Transfer-Encoding: 7bit Subject: com and retrieve text from wor

RE: [PHP-DB] Re: HTML layout and arrays (WAS : Brain not working, helpneeded :-). .

Date: Mon, 29 Aug 2005 07:46:52 -0500 Message-ID: <[EMAIL PROTECTED]> From: "Norland, Martin" <[EMAIL PROTECTED]> To: Reply-To: Subject: RE: [PHP-DB] Re: HTML layout and arrays (WAS : Brain not working, helpneeded :-).. >-Original Message- >Fr

[PHP-DB] Re: HTML layout and arrays (WAS : Brain not working, help needed :-)

At 03:46 29/08/2005 +, you wrote: Message-Id: <[EMAIL PROTECTED]> From: "Chris Payne" <[EMAIL PROTECTED]> To: Date: Sun, 28 Aug 2005 23:45:59 -0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_NextPart_000__01C5AC2A.A4CF7370" Subject: Brain not working,

[PHP-DB] RE : HTML Layout (WAS : DB formatting question)

Message-Id: <[EMAIL PROTECTED]> From: "Chris Payne" <[EMAIL PROTECTED]> To: Date: Sat, 27 Aug 2005 02:31:13 -0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_NextPart_000__01C5AAAF.64FE18E0" Subject: DB formatting question Hi there everyone, I'm converti

[PHP-DB] Re : Subject: floats

Message-ID: <[EMAIL PROTECTED]> Date: Tue, 19 Jul 2005 15:16:47 -0400 From: blackwater dev <[EMAIL PROTECTED]> Reply-To: blackwater dev <[EMAIL PROTECTED]> To: php-db@lists.php.net Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Subject: floats I am running a query on MySQL: sel

[PHP-DB] Subject: RE: [FIX YOUR SUBJECT !] php-db Digest 20 Jun 2005 23:54:37 -0000 Issue 2992

Hi - Suggestions : 1) Turn on error_reporting in your PHP script : 2) Load page, and go to browser's View->Source menu, to see if you actually got malformed HTML or anything at all. Cheers - Neil From: Cosman CUSCHIERI <[EMAIL PROTECTED]> To: Date: Wed, 22 Jun 2005 15:29:47 +0200 Messag

[PHP-DB] RE : Subject: Com 1

From: Nandar <[EMAIL PROTECTED]> To: php-db@lists.php.net Message-ID: <[EMAIL PROTECTED]> Date: Tue, 14 Jun 2005 10:01:59 +0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_NextPart_000_0007_01C570C8.1A876C60" Subject: Com 1 Hi,. any one to know, how to send a

[PHP-DB] Re: Subject: Creating an Associative Array

At 21:04 08/06/2005 +, you wrote: To: MIME-Version: 1.0 Message-ID: <[EMAIL PROTECTED]> From: [EMAIL PROTECTED] Date: Wed, 8 Jun 2005 16:04:33 -0500 Content-Type: multipart/alternative; boundary="=_alternative 0073C60C8625701A_=" Subject: Creating an Associative Array This question will

[PHP-DB] Re: Subject: how do i fetch some text

At 04:51 29/05/2005 +, you wrote: Message-ID: <[EMAIL PROTECTED]> To: php-db@lists.php.net Date: Sun, 29 May 2005 09:54:50 +0530 From: chintan <[EMAIL PROTECTED]> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: how do i fe

[PHP-DB] Re: Subject: How many rows for 100 questions?

At 04:51 29/05/2005 +, you wrote: Message-ID: <[EMAIL PROTECTED]> To: php-db@lists.php.net From: "...helmut" <[EMAIL PROTECTED]> Date: Sat, 28 May 2005 12:19:02 -0500 Subject: How many rows for 100 questions? I have a questionary that has 100 questions, Should I create 2 tables 1 with the u

[PHP-DB] RE : Subject: Letters loop

for ($i=1; $i<=26; $i++) { print(chr(64+$i)); } chr() prints the ASCII character corresponding to that number. Upper case A-Z starts at 64 : http://www.lookuptables.com Cheers - Neil Date: Wed, 25 May 2005 20:37:47 -0700 From: MIGUEL ANTONIO GUIRAO AGUILAR <[EMAIL PROTECTED]> To: php-d

[PHP-DB] RE: Subject: Form information

Message-Id: <[EMAIL PROTECTED]> From: "Chris Payne" <[EMAIL PROTECTED]> To: Date: Wed, 25 May 2005 00:53:59 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_NextPart_000__01C560C4.3CC5A710" Subject: Form information Hi there everyone, I'm pulling data f

[PHP-DB] Re : How to I get to a next entry

At 22:28 19/05/2005 +, you wrote: Message-Id: <[EMAIL PROTECTED]> From: "John R. Sims, Jr." <[EMAIL PROTECTED]> To: , Date: Thu, 19 May 2005 12:20:24 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_NextPart_000_0015_01C55C6D.22CC6B60" Subject: More problems

[PHP-DB] Fwd: Subject: URL question

Easy enough, using Mod Rewrite on apache (you didn't say which server you use, so I'm afraid you'll have to upgrade if using IIS) : Create a file in a text editor. Save it as .htaccess (dot-htaccess as the filename) in the http://www.blablah.com/examples/ directory - not in the root folder or y

Re: [PHP-DB] php3 and oracle9i client libraries doesn't compile..

libvppdc.so xsqlserializers.jar libgslsg9.a libocijdbcst9.alibvpxdba.so xsu111.jar libgslssb9.a libodm9.so libvpxeap.so xsu12.jar >From: Christopher Jones <[EMAIL PROTECTED]> >To: neil smith <[EMAIL PROTECTED]> >CC: php-db@l

Re: [PHP-DB] php3 and oracle9i client libraries doesn't compile..

a - thanks for that!! would that be part of an oracle library? thanks, neil >From: Martin Norland <[EMAIL PROTECTED]> >Reply-To: php-db@lists.php.net >To: php-db@lists.php.net >Subject: Re: [PHP-DB] php3 and oracle9i client libraries doesn't compile.. >Date: Thu, 28 Apr 200

[PHP-DB] php3 and oracle9i client libraries doesn't compile

hello people, I'm using this command to configure php3 ./configure --with-apxs=/usr/local/apache/bin/apxs --with-config-file-path=/usr/local/lib --enable-versioning --enable-track-vars --with-oci8=/u01/app/oracle/product/9.2.0.4 --with-oracle=/u01/app/oracle/product/9.2.0.4 --enable-sigchild t

Re: [PHP-DB] php4 can't find tnsnames.ora oracle9 but can connectif description

; ie the full description of the database alias within tnsnames.ora However this is not good, so if you have any other idea please let me know. I'm flumuxed. thanks, neil >From: Christopher Jones <[EMAIL PROTECTED]> >To: neil smith <[EMAIL PROTECTED]> >CC: php-db@lis

[PHP-DB] Subject: Help wanted, Writing to the LPT Port.

Actually, php-db is a list for (wait for it!) PHP used with DB (databases) so you've got the wrong list, you meant to send it to PHP-general. Anyway to answer your question, you can send an 8 bit printer port a series of ASCII characters (0-255) which correspond to your values, so say chr(35) =

[PHP-DB] php4 can't find tnsnames.ora oracle9 but can connect if description hardcoded

Hello, I have test script that can connect to the oracle database. It doesn't require tnsnames.ora because I define the database alias in the script itself. It looks like this: echo "TWO_TASK=".getenv("TWO_TASK").""; echo "LD_LIBRARY_PATH=".getenv("LD_LIBRARY_PATH").""; echo "ORACLE_BASE=".getenv(

[PHP-DB] Subject: Web Printing

At 10:27 31/03/2005 +, you wrote: Message-ID: <[EMAIL PROTECTED]> From: "Ng Hwee Hwee" <[EMAIL PROTECTED]> To: "PHP DB List" Date: Thu, 31 Mar 2005 18:24:41 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_NextPart_000_00CD_01C5361E.E80297D0" Subject: Web Pr

Re: [PHP-DB] Forms...

At 07:52 10/03/2005 +, you wrote: Message-ID: <[EMAIL PROTECTED]> Date: Wed, 09 Mar 2005 20:37:36 +0100 From: Jochem Maas <[EMAIL PROTECTED]> if your into XHTML: Actually that's invalid XHTML (it won't validate) due to a typo I guess. Each XML (aka XHTML) DOM element can only have a ~single~ a

Re: [PHP-DB] Re:data grabbing and mathematics!

At 09:48 08/03/2005 +, you wrote: Message-ID: <[EMAIL PROTECTED]> Date: Mon, 07 Mar 2005 13:01:45 -0600 From: Martin Norland <[EMAIL PROTECTED]> Reply-To: php-db@lists.php.net MIME-Version: 1.0 To: php-db@lists.php.net Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer

[PHP-DB] Re:data grabbing and mathematics!

At 17:15 07/03/2005 +, you wrote: JeRRy wrote: Hi, I have 23 tables, well I have more but these 23 tables are the main agenda regarding this question. In each of the table is a column titled "score" and a column titled "nickname" ... These are the two columns we need for this. well - two option

[PHP-DB] Subject: mysql_real_escape_string for HTML ???

You actually need (it's in the manual) nl2br for this. It converts newline (nl) to (2) break (br) so this text (\n indicates a newline character or 'enter' as you've called it) This\n is\n a\n test\n Would become This\n is\n a\n test\n Make sure you strip those if you intend to put the content b

Re: [PHP-DB] timestamp

Balwant - according to http://php.planetmirror.com/manual/en/ref.datetime.php shouldn't you be using strtotime rather than strftime for this ? strftime needs input of a timestamp a large Int32 Unix Timestamp), where

RE: [PHP-DB] Re: Subject: mysql - image storing

At 09:48 19/01/2005 +, mel list_php wrote: Ok Neil, I'll try this as well.I thought a readfile would be also forbidden by the htaccess, No, .htaccess affects public viewing of the web root and child folders. PHP operates on the web server's file system (in as far as your host/ISP permits tha

[PHP-DB] Re: Subject: mysql - image storing

No, really really , don't do this. Store the path to the image. You then load the path into PHP and use header("Content-type: image/jpeg"); readfile($path_from_database); exit; Then .htaccess the *actual directory* you store the images in so it's hidden from browsing. Only allow authorised people

[PHP-DB] RE: How to process a query form with >>CHECKBOX<< RADIO not checkbox !

At 01:23 28/12/2004 +, you wrote: Date: Mon, 27 Dec 2004 17:22:49 -0800 (PST) From: S Kumar <[EMAIL PROTECTED]> To: php-db@lists.php.net, php-general@lists.php.net MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Subject: How to process a query form with CHECKBOX Please help Age gro

[PHP-DB] Re: Subject: [PHP-DB] KEYBOARD

It's all client-side Javascript. I'll send you by email (off-list) an example I wrote this week for touchscreen number data entry so you can see how to do it. Then you're on your own ! This is *not* a PHP *or* a DB question, please keep general web-development questions to a more appropriate ne

[PHP-DB] RE : Subject: Excel - merging cells with PHP

Sure, you'd output to the Excel XML spreadsheet format, which allows you to do colspans and such, although with a different syntax to HTML. (I posted this answer to the microsoft.public.xsl list the other day ;-) The documentation is here : http://msdn.microsoft.com/library/default.asp?url=/libr

[PHP-DB] Re: Subject: Javascript Question (Was PHP / Javascript question)

That if (df[i].checked=true) { should of course read if (df[i].checked==true) { Cheers - Neil function validate_form() { valid=true; df=document.forms["myform"]; var regex="del\[\d+\]"; for (i=0; i

[PHP-DB] Re: Subject: Javascript Question (Was PHP / Javascript question)

Yes it can be a bit tricky first time. You'll be using numeric indexes (it's the easiest) so probably like this : Iterate through the form's elements array, check if each one is a [checkbox / radio / other] and then check the name for the element against a regex. If it matches then you need to u

[PHP-DB] Re: php-db Digest 13 Nov 2004 11:54:41 -0000 Issue 2681

Brilliant, nice one. You've just given me the opportunity to run my counter-spam signup script. I wa swaiting for a good opportunity like this, as it's a little difficult to test on myself !You have now been automatically subscribed to 14,500 newsletter distribution lists and opt-out mailings.

[PHP-DB] Re: MySQL Data Not Returned

My guess (and it will be correct) is that you've got a not visible character on the end of your email address in the database. Such a character could be a space, newline, tab or other similar character. Make sure you use trim($email_address) to create the field to insert into the database ! Ch

[PHP-DB] Re:Subject: Finding the highest number in a column?

Surely some monday morning light headedness Chris ! SELECT MAX(column_name) AS max_number FROM table Make sure the column's indexed if you do it often ! Cheers - Neil At 03:32 28/10/2004 +, you wrote: Message-Id: <[EMAIL PROTECTED]> From: "Chris Payne" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]

[PHP-DB] Re: Subject: Form Processing

Sure you can Ron : Just give each submit button the same name, but a different ID in the html eg When the user presses one of the buttons, look into the $_POST array and check if the value is set, for example switch ($_POST["submit"])) { case 'Delete' : // Delete actions he

[PHP-DB] Re: Subject: Print

This is NOT a PHP question, or even a Javascript question - it's basic HTML and CSS. You must read here http://www.dillonsoftware.com/essays/printing.jsp point #3 And here on A ListApart : http://www.alistapart.com/discuss/goingtoprint/6/ But please do not post basic HTML questions to the PHP lis

Re: [PHP-DB] functions via event handlers

Or you could use XMLHTTP on the browser side (supported by IE and Mozilla variants) You'd send a GET request to the page, it would return - often - an XML record set, or you can return text, and indeed you can even query page status codes from the client side. The point is, you no longer need

[PHP-DB] Re: php Form Validation help

At 11:09 07/09/2004 +, you wrote: From: "Vincent Jordan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Date: Mon, 6 Sep 2004 19:20:16 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_NextPart_000_0004_01C49446.8C688C60" Subject: php Form Validation help have a

[PHP-DB] Re Displaying Text From A Data File

It's actually very simple : Just use SELECT * FROM tbl_name ORDER BY RAND() LIMIT 1 Cheers - Neil At 17:35 04/09/2004 +, you wrote: Message-ID: <[EMAIL PROTECTED]> From: "Ron Piggott" <[EMAIL PROTECTED]> To: "PHP DB" <[EMAIL PROTECTED]> Date: Sat, 4 Sep 2004 14:00:56 -0400 MIME-Version: 1.0 Con

[PHP-DB] Re: Subject: LOAD DATA LOCAL INFILE

I often had trouble getting the syntaxt just right with PHP, it's easy to end up with the wrong number of slashes around the -lines terminated by "'"- parts of this. When you ran your query, what did mysql_error() say about it ? That would be a line you add directly after the line mysql_query($l

[PHP-DB] Re: Subject: Enabling LDAP support

> "I have copied the two required .dlls (libeay32 & ssleay32) into the system folder." No, you need to copy the dll's to \winnt\system32, not \winnt\system > "thinking that that might make it work... but it didn't" *How* didn't it work ? What did you try ? If it didn't connect, are you letting TC

Re: [PHP-DB] Mysql and rollbacks

Yeah sure ... UK Linux.net do PostGreSQL as well as MySQL on their servers. http://www.uklinux.net The postgres support has transactions as somebody mentioned although theres no reason why you can't use both databases depending on your requirements, lets say if the transaction requirement is s

[PHP-DB] RE: Subject OUTER JOIN ( WAS Subject: Multiple SELECT)

This answer is quite involved, see below. Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="ISO-8859-1" MIME-Version: 1.0 To: [EMAIL PROTECTED] Date: Sun, 11 Jul 2004 19:31:21 -0700 From: "Marcjon" <[EMAIL PROTECTED]> Message-Id: <[EMAIL PROTECTED]> I know this issue comes up alot,

Re: [PHP-DB] Image Resize

Kenny - you will find there are no native PHP handlers for TIFF. If you're on a unix system you'll be able to use the imagemagick function 'convert' at a command line to do this. Something like this I developed for a client will work, you'll need to look up the passthru function in the PHP manua

[PHP-DB] RE : validate 2 password fields

].value==df['password2'].value) { // Passwords matched, clear password2, allow form to submit df['password2'].value=''; return true; else { alert('Passwords did not match'); return false; } }</pre><br> <pre style="margin: 0em;">

[PHP-DB] Subject: Re: Javascript forms [2]

At 22:20 28/06/2004 +, you wrote: From: "Vincent Jordan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Date: Sun, 27 Jun 2004 20:35:52 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Subject: Re: Php form & row delete problems I have

[PHP-DB] RE : validate 2 password fields

Attach onsubmit="return checkpasswords()" to your form tag. function checkpasswords() { df=document.forms["DisplayUser"]; if (df["password1"].value==df["password2"].value) { // Passwords matched, clear password2, allow form to submit df["password2"].value=""

Re: [PHP-DB] Date help needed

No, it's actually very easy to do the autocomplete once you get the hang of it. Actually the way I've done it is to populate a multi-select box but you could also use a DIV and write out the values Dump the email addresses as an XML file (generate this dynamically) then use XSLT to read out mat

[PHP-DB] Re: Subject: Update data problem

Is there any obvious reason why you're not doing this in one query $query = "UPDATE media SET A='$A', B='$B', C='$C', G=E*'$C'"; Or have I missed something here ? Cheers - Neil At 10:07 24/06/2004 +, you wrote: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_=_Next

  1   2   >