[PHP-DB] Subject: Re: FIle Uploading to database

2002-02-04 Thread neil smith
RE Could not execute f query : Is it possibly a typo, such that INSERT INTO Canidate should read Candidate (ie with the correct number of d's for the english speling ;-) Just a thought. Neil. At 02:13 04/02/2002 +, "Todd Williamsen" <[EMAIL PROTECTED]> wrote: $query = "INSERT INTO

[PHP-DB] RE Viewing Session Varibles

2002-02-08 Thread neil smith
your if statement executes and unsets the value for $cart[$id], which *is* a valid variable name. Could you replace $$id==0 with isset($$id) and see if you get the same results? Cheers, Neil Smith. At 20:57 07/02/2002 +, you wrote: >From: Robert Weeks [mailto:[EMAIL PROTECTED]] &

[PHP-DB] Re ModSSL Problem

2002-02-08 Thread neil smith
icro$ fault for producing flaky browser versions, apparently. PS - Isn;t this a PHP / My SQL list ? Just a thought, but Jefferey perhaps this sort of stuff is better on the Apache/ModSSL lists? Cheers, Neil Smith. At 20:57 07/02/2002 +, you wrote: >From: "Jeffrey Cleary" <

[PHP-DB] Fwd: php-db Digest 11 Feb 2002 20:12:53 -0000 Issue 1046

2002-02-12 Thread Neil Smith
(! $remote) { $remote=$REMOTE_ADDR; } And thats it. If your user has a *real* IP address you get $remote set to value of $REMOTE_ADDR, else it fishes out any forwarded address from the proxy and returns that ;-) Use gethostbyname to lookup the hostname from IP address. Cheers, Neil Smith. >-

[PHP-DB] Fwd: php-db Digest 12 Feb 2002 09:59:09 -0000 Issue 1047

2002-02-12 Thread neil smith
er_id in the global scope (assuming you have register_globals switched on in php.ini, as most ISPs do) : i.e. you know you set it rather than somebody else, and can rely on the value. Cheers, Neil Smith. >Hi there. You could avoid all of that trouble by using session variables. >Upon suc

[PHP-DB] Fwd: php-db Digest 11 Feb 2002 20:12:53 -0000 Issue 1046

2002-02-12 Thread Neil Smith
ons to other peoples problems, and provide help where possible. Very grateful for the input others have generously provided. I think though that the nature of this list is probably more for newbies than experienced MCP or open-source guru discussions, preferably for discussion of PHP and

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

2005-04-19 Thread neil smith
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(

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

2005-04-22 Thread neil smith
; 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] php3 and oracle9i client libraries doesn't compile

2005-04-28 Thread neil smith
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] php3 and oracle9i client libraries doesn't compile..

2005-04-28 Thread neil smith
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

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

2005-04-29 Thread neil smith
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

[PHP-DB] Re: Subject: Cookie problem

2004-02-07 Thread Neil Smith [MVP, Digital media]
First check that you are not sending any content before trying to set the cookie : It effectively is sending a header, and headers must be sent before any other content - even a white space before your PHP script which sets your cookie will send headers so then your cookie will not be set. You

[PHP-DB] Re: Grab and update values (Was Re: php-db Digest 8 Feb 2004)

2004-02-09 Thread Neil Smith [MVP, Digital media]
It's simple - no need for IF statements, as the SQL Select syntax does that for you ! Try UPDATE tablename SET value2=value1, value1=0 WHERE value1 > 3 You might also want to look at the REPLACE INTO syntax in the manual too, for completeness. Be aware though that this won't work i

[PHP-DB] Re: Subject: MySQL query question

2004-02-13 Thread Neil Smith [MVP, Digital media]
I think you just have to 'alias' the result count, so that ORDER BY knows what to use to do the ordering - it needs a column name, but an alias is equivalent to a column name. So : $mostcomquery = SELECT artid, COUNT(*) AS hitcount FROM comments

[PHP-DB] Re: Subject: Starters question: mysql & PHP.INI

2004-02-19 Thread Neil Smith [MVP, Digital media]
I think you have to look up session_set_save_handler() in the PHP documentation, but I thought it was usually done manual (Ie, per page) process rather than in php.ini, though you can set it there if you like : Your specified save handler functions then take care of handing off data to and from

[PHP-DB] Re: Subject: exporting data to excel

2004-03-25 Thread Neil Smith [MVP, Digital media]
You just need to export to csv using phpMyAdmin or create the csv file on the fly and send an excel or text/csv header before sending the csv data. Couldn't be easier ;-) At 01:30 25/03/2004 +, you wrote: Message-ID: <[EMAIL PROTECTED]> Date: Wed, 24 Mar 2004 19:30:09 -0600 From: matthew

[PHP-DB] Re: Subject: PHP vs. Flash

2004-04-16 Thread Neil Smith [MVP, Digital media]
Yes, it should work fine but please understand (1) Your flash movie must know how to process a query string passed to it and (2) IE does not support the EMBED syntax, you need to wrap the flash OBJECT tag around the EMBED just as you see on flashkit for it to work (that is for IE to pass the fla

[PHP-DB] Re: Subject: putting strings together with a linefeed

2004-04-16 Thread Neil Smith [MVP, Digital media]
You should appreciate there is a difference between using double quotes and single quotes around a string. So you can't say print('what up doc $mycarriagereturnvariable'); and expect it to output the value of $mycarriagereturnvariable. Next, you *can* use this construct within *double* quotes.

[PHP-DB] Re: question on

2004-05-13 Thread Neil Smith [MVP, Digital media]
** Or send XML files up and down dynamically using xmlhttp in IE and Mozilla ;-) Cheers - Neil At 04:06 13/05/2004 +, you wrote: To make a client-side solution possible, you'd have to send ALL POSSIBLE data to the page all at the same time then manipulate it with JavaScript. -- PHP Database

[PHP-DB] Re:RE: [PHP-DB] question on

2004-05-13 Thread Neil Smith [MVP, Digital media]
That *should* read : document.fcountry.newcountry.value = document.fcountry.country[document.fcountry.country.selectedIndex].value; Skip the 'options' object - I'm surprised you're not getting a javascript error, maybe you have error reporting turned off in your browser ? In any case, always '

Re: [PHP-DB] Edit with notepad

2004-05-11 Thread Neil Smith [MVP, Digital media]
Just offer them a link to the next page. Put &format=word in as the query string if they choose the 'view word document' link or no query string if they choose the plain text view as html page. Then go for if ($_GET["format"]=='word') { header("Content-type: application/vnd-ms.word"); }

[PHP-DB] RE :I thought "4" didn't equal "456456456%20%20OR%201<>2"

2004-05-10 Thread Neil Smith [MVP, Digital media]
It doesn't. What you're seeing is an SQL injection attack. If you *trust* the SQL code you allow from POST or GET requests, your SQL server will be own3d in due course. That URL actually translates to 456456456 OR 1<>2 Which is always true. So If you use this verbatim, you'll get a true result

[PHP-DB] Re: Subject: Edit with notepad

2004-05-10 Thread Neil Smith [MVP, Digital media]
Send before any content, an MS-Word header : header("Content-type: application/vnd-ms.word"); Then output your HTML. Cheers - Neil. At 07:41 10/05/2004 +, you wrote: Message-ID: <[EMAIL PROTECTED]> From: "Ng Hwee Hwee" <[EMAIL PROTECTED]> To: "DBList" <[EMAIL PROTECTED]> Date: Mon, 10 May 20

Re: [PHP-DB] Page cannot be displayed problems

2004-04-29 Thread Neil Smith [MVP, Digital media]
PUT is still used with great success by systems such as WebDav. I'd stick to GET or POST though in a web environment, as the server needs to be specially configured to accept PUT requests and there are certain security implications from allowing people to upload files using PUT. Cheers - Neil.

[PHP-DB] Re: Subject: Image / file uploader

2004-04-30 Thread Neil Smith [MVP, Digital media]
So did you intend for this to happen : Set $dest="". Check source supplied. Set $dest=$uploadpath.$photo_name; Check if $dest="". If $dest="" (which it cant be if you supplied an image), then move the uploaded file (it will never run). Else, echo couldn't store image. You see the problem, yes ?

[PHP-DB] Re: Subject: Image / file uploader

2004-04-30 Thread Neil Smith [MVP, Digital media]
BTW that line should read "if ($dest =='') " not "if ($dest = '')" You need 2 equals signs to test for equality, using one you are setting $dest to an empty string. It's a miracle it ever worked ;-) Cheers - Neil if ($dest = '') { if (move_uploaded_file($so

[PHP-DB] Re: Subject: diference between == and ===

2004-05-03 Thread Neil Smith [MVP, Digital media]
The PHP manual (a useful read btw !) states that === tests for equality and *exact* equivalence, that is: If you test for ==='1' then $var must be a string for the result to be true if you test for ===1 then $var must be an integer or double type for the result to be true Usually its used in te

[PHP-DB] Subject: Struggling [Is : With database normalisation]

2004-05-05 Thread Neil Smith [MVP, Digital media]
Probably something as simple as changing the structure to a more normalised form would help : By adding a table which links evt_details to evt_sponsors, you do away with the need to have (up to 4) distinct fields to hold the evt_sponsor in your evt_details table. So add something like table :

[PHP-DB] Re: Subject: SQL Statement

2004-05-19 Thread Neil Smith [MVP, Digital media]
You're missing a closing quote at the end of the line, following the group by `calls`, it should end as , `calls`"; Since you are passing a string to PHP to hand off to the DB engine. Also, PHP function mysql_error($connection) is useful as this will return any errors generated by your database

[PHP-DB] Re: Table Def error WAS "Where" Error

2004-05-29 Thread Neil Smith [MVP, Digital media]
It's probably a table definition thing. Is your 'netreceipts' column an ENUM ? How about your status column - is it a CHAR ? ENUM ? Send us the table definition for the misbehaving table. Also, send us the error message before asking what's the solution, we're not mind readers :-)) Your query

[PHP-DB] Re:Subject: big/small letters with oracle No2

2004-06-01 Thread Neil Smith [MVP, Digital media]
You can just use the PHP function ucwords(strtolower()) on the results as you loop through them to create the Select list ;-) So, this would convert NA to Na, and MG to Mg (as well as mG to Mg and MG to Mg ;-) Cheers - Neil At 10:41 01/06/2004 +, you wrote: Date: Tue, 01 Jun 2004 12:41:11 +

[PHP-DB] Re: Subject: Retrieve data, add new fields and enter it in new ta

2004-06-22 Thread Neil Smith [MVP, Digital media]
Look at the INSERT... SELECT syntax in the MySQL manual Basically you can do this but only between 2 different tables (which is what you specified) : Generate and *test* the SELECT statement you want to use to recover your data set. Then in PHP try a query like this : $query="INSERT INTO table2

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

2004-06-24 Thread Neil Smith [MVP, Digital media]
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

Re: [PHP-DB] Date help needed

2004-06-25 Thread Neil Smith [MVP, Digital media]
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 : validate 2 password fields

2004-06-29 Thread Neil Smith [MVP, Digital media]
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=""

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

2004-06-29 Thread Neil Smith [MVP, Digital media]
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

2004-06-30 Thread Neil Smith [MVP, Digital media]
].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;">

Re: [PHP-DB] Image Resize

2004-06-30 Thread Neil Smith [MVP, Digital media]
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: Subject OUTER JOIN ( WAS Subject: Multiple SELECT)

2004-07-12 Thread Neil Smith [MVP, Digital media]
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] Mysql and rollbacks

2004-07-15 Thread Neil Smith [MVP, Digital media]
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: Enabling LDAP support

2004-08-03 Thread Neil Smith [MVP, Digital media]
> "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

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

2004-08-16 Thread Neil Smith [MVP, Digital media]
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 Displaying Text From A Data File

2004-09-04 Thread Neil Smith [MVP, Digital media]
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: php Form Validation help

2004-09-07 Thread Neil Smith [MVP, Digital media]
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

Re: [PHP-DB] functions via event handlers

2004-09-07 Thread Neil Smith [MVP, Digital media]
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: Subject: Print

2004-09-09 Thread Neil Smith [MVP, Digital media]
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

[PHP-DB] Re: Subject: Form Processing

2004-10-16 Thread Neil Smith [MVP, Digital media]
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: Finding the highest number in a column?

2004-10-28 Thread Neil Smith [MVP, Digital media]
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: MySQL Data Not Returned

2004-11-13 Thread Neil Smith [MVP, Digital media]
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: php-db Digest 13 Nov 2004 11:54:41 -0000 Issue 2681

2004-11-13 Thread Neil Smith [MVP, Digital media]
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: Subject: Javascript Question (Was PHP / Javascript question)

2004-11-16 Thread Neil Smith [MVP, Digital media]
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: Subject: Javascript Question (Was PHP / Javascript question)

2004-11-16 Thread Neil Smith [MVP, Digital media]
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: Excel - merging cells with PHP

2004-11-30 Thread Neil Smith [MVP, Digital media]
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: [PHP-DB] KEYBOARD

2004-12-01 Thread Neil Smith [MVP, Digital media]
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: How to process a query form with >>CHECKBOX<< RADIO not checkbox !

2004-12-28 Thread Neil Smith [MVP, Digital media]
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: mysql - image storing

2005-01-18 Thread Neil Smith [MVP, Digital media]
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

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

2005-01-19 Thread Neil Smith [MVP, Digital media]
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

Re: [PHP-DB] timestamp

2005-01-29 Thread Neil Smith [MVP, Digital media]
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

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

2005-03-06 Thread Neil Smith [MVP, Digital media]
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

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

2005-03-07 Thread Neil Smith [MVP, Digital media]
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

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

2005-03-08 Thread Neil Smith [MVP, Digital media]
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

Re: [PHP-DB] Forms...

2005-03-10 Thread Neil Smith [MVP, Digital media]
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

[PHP-DB] Subject: Web Printing

2005-04-01 Thread Neil Smith [MVP, Digital media]
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

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

2005-04-22 Thread Neil Smith [MVP, Digital media]
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] Fwd: Subject: URL question

2005-04-30 Thread Neil Smith [MVP, Digital media]
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

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

2005-05-20 Thread Neil Smith [MVP, Digital media]
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] RE: Subject: Form information

2005-05-26 Thread Neil Smith [MVP, Digital media]
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 : Subject: Letters loop

2005-05-26 Thread Neil Smith [MVP, Digital media]
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: How many rows for 100 questions?

2005-05-30 Thread Neil Smith [MVP, Digital media]
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: how do i fetch some text

2005-05-30 Thread Neil Smith [MVP, Digital media]
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: Creating an Associative Array

2005-06-08 Thread Neil Smith [MVP, Digital media]
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: Com 1

2005-06-14 Thread Neil Smith [MVP, Digital media]
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] Subject: RE: [FIX YOUR SUBJECT !] php-db Digest 20 Jun 2005 23:54:37 -0000 Issue 2992

2005-06-22 Thread Neil Smith [MVP, Digital media]
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: floats

2005-07-20 Thread Neil Smith [MVP, Digital media]
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] RE : HTML Layout (WAS : DB formatting question)

2005-08-27 Thread Neil Smith [MVP, Digital media]
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: HTML layout and arrays (WAS : Brain not working, help needed :-)

2005-08-29 Thread Neil Smith [MVP, Digital media]
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,

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

2005-08-29 Thread Neil Smith [MVP, Digital media]
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 : Subject: com and retrieve text from word

2005-08-31 Thread Neil Smith [MVP, Digital media]
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

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

2005-10-22 Thread Neil Smith [MVP, Digital media]
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: Searching remote web sites for content

2005-10-23 Thread Neil Smith [MVP, Digital media]
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: Complex Left Join

2005-10-31 Thread Neil Smith [MVP, Digital media]
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: Specific order by MySQL statement

2005-11-08 Thread Neil Smith [MVP, Digital media]
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:Login Auth help?

2005-11-10 Thread Neil Smith [MVP, Digital media]
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: Login Auth help?

2005-11-11 Thread Neil Smith [MVP, Digital media]
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 : [PHP-DB] MySQL Update Quandry

2005-11-28 Thread Neil Smith [MVP, Digital media]
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] Subject: GROUP BY [Was: SELECT]

2005-12-11 Thread Neil Smith [MVP, Digital media]
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: Date Formatting Question

2005-12-14 Thread Neil Smith [MVP, Digital media]
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] Re: CLOSE button or link

2005-12-22 Thread Neil Smith [MVP, Digital media]
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: Subject: Scrolling News

2005-12-23 Thread Neil Smith [MVP, Digital media]
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 : Subject: using fsockopen to handle redirections

2005-12-23 Thread Neil Smith [MVP, Digital media]
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: Cannot connect to a MySQL DB using a Class

2006-01-05 Thread Neil Smith [MVP, Digital media]
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

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

2006-01-06 Thread Neil Smith [MVP, Digital media]
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: [

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

2006-01-09 Thread Neil Smith [MVP, Digital media]
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]

[PHP-DB] Freelancers, UK ?

2006-01-30 Thread Neil Smith [MVP, Digital media]
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

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

2006-02-05 Thread Neil Smith [MVP, Digital media]
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] Re: Sessions help needed !!!

2006-02-18 Thread Neil Smith [MVP, Digital media]
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 !!!

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

2006-02-25 Thread Neil Smith [MVP, Digital media]
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] Subject: Where did my Hard Returns go?

2006-03-01 Thread Neil Smith [MVP, Digital media]
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

[PHP-DB] Re: Subject: Parse Problem

2006-05-09 Thread Neil Smith [MVP, Digital media]
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] Re: Subject: making an array from data in textfile

2006-07-24 Thread Neil Smith [MVP, Digital media]
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

  1   2   >