RE: [PHP] installing PHP with-apxs with-oci8 --with-oracle onLinux - remote oracle

2001-09-24 Thread Andrew Hill
Jeffrey, Ensure your ORACLE_SID is also set. This is a case of Oracle environment variables. Log in as the oracle user and look at the output of an 'env'. You are missing something there. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.open

RE: [PHP] XML works like a DataBase?

2001-09-25 Thread Andrew Hill
do need XML, then convert from relational data to XML on the fly. There are several ways to do this. An easy one is our database: Virtuoso You can download it for free at http://www.openlinksw.com/virtuoso Hope this helps. Best regards, Andrew Hill Director of Technology Evangelism OpenLink

[PHP] speechmarks

2001-09-25 Thread Andrew Austin
What is the method for mySQL to surround single speechmarks as in (don't) so it will be accepted in an SQL statement. thanks in advance Andrew

[PHP] RE: WebMail Client

2001-10-02 Thread Andrew Chase
You might want to take a look at Netmania. (http://www.netmania.org) Caveats: I helped install Netmania at a former employer back in February 2001, and with the then-current distribution we had all kinds of trouble setting it up until we realized that it depended on having *all* error handling t

RE: [PHP] Re: Submitting variables via /'s

2001-10-05 Thread Andrew Hill
Note, this is not currently possible under the CGI, only as a module. Best regards, Andrew Hill > -Original Message- > From: John A. Grant [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 05, 2001 4:04 PM > To: [EMAIL PROTECTED] > Subject: [PHP] Re: Submitting va

[PHP] Need to maintain the integrity of the checkbox

2004-07-29 Thread Andrew Reilly
New to the list, thanks in advance. I have created a form that lists the possible sponsorships of various events. I need to keep the names of the checkbox to identify the specific event, but the value is a dollar amount that needs to pass thru to the checkout area function. Without creating a

RE: [PHP] Need to maintain the integrity of the checkbox

2004-07-29 Thread Andrew Reilly
Example of form: Power of Money Series ($5000) Power of Politics ($3500) Power of Wine    Power of Golf (Fall) Series ($3500) Power of Golf (Spring) Series ($3500) So the dollar amounts are the same for three of the four events, but this is just a snippet of abou

RE: [PHP] Need to maintain the integrity of the checkbox

2004-07-29 Thread Andrew Reilly
So the would go in the value or name field of the checkbox? -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Thursday, July 29, 2004 10:01 AM To: Andrew Reilly; [EMAIL PROTECTED] Subject: RE: [PHP] Need to maintain the integrity of the checkbox [snip] Example of

[PHP] Cannot compile

2004-08-01 Thread Andrew W
I've compiled & installed software from source before but PHP 5 is proving a challenge. I've decompressed the tarball and cd into the directory. Run ./configure which seems to work ok but then when I do make I get the following error: "No targets specified and no makefile found" Sure enough t

Re: [PHP] Cannot compile

2004-08-02 Thread Andrew W
I'm using Linux. It doesn't work regardless of whether I include any options or not. On 2 Aug 2004, at 04:14, Support wrote: Sounds like configure did not work ok after all. :-) Did you include any options? What os? Any clues you could offer would help. -- PHP General Mailing List (http://www.php

[PHP] str_replace - is it case sensitive

2004-08-14 Thread Andrew W
Is the str_replace function case sensitive, I cant seem to find any answer on the PHP manual website or in my books. If it is, is there anyway to make it case insensitive so it can handle mIxEd CaSe woRdS in any combination? Thanks AW -- PHP General Mailing List (http://www.php.net/) To unsubsc

[PHP] Use of date(), and therefore time(), in the PEAR Date class

2004-09-10 Thread Andrew Hill
before/after the creation of the second call to Date (which is the one that generates the incorrect date), I actually get the correct time! Can anyone please suggest what might be causing date()/time() to (sometimes) return an incorrect time inside the Date class? Cheers, -- Andrew Hill Developer

Re: [PHP] Totaling sales by month

2004-09-10 Thread Andrew Kreps
This one worked for me, on MySQL 3.23.xx. I hope it's closer to what you need. select sum(ordersubtotal), date_format(orderdate, '%Y-%m') as odate from orders group by odate On Fri, 10 Sep 2004 15:01:34 -0700, Brian Dunning <[EMAIL PROTECTED]> wrote: > I have a MySQL db with a datetime field con

[PHP] PHP include before or after Apache SSI?

2004-09-13 Thread Andrew W
In which order do the two execute? I'm trying to work out the best way to integrate PHP backend code with an HTML interface in the cleanest way possible - I don't really want to copy & paste the PHP into the HTML because it will make maintaining both the PHP & the HTML more complicated. What

Re: [PHP] Re: mysql_connect does not connect

2004-09-14 Thread Andrew Kreps
On Tue, 14 Sep 2004 10:11:24 -0700, Sam Hobbs <[EMAIL PROTECTED]> wrote: > Also, are the warning messages documented? As I asked in my original > question, is 10061 an error code? 10061 is a generic winsock error for a timeout, it's not PHP or MySQL specific. It means that the call couldn't conne

Re: [PHP] PHP include before or after Apache SSI?

2004-09-15 Thread Andrew W
On 13 Sep 2004, at 19:11, Ed Lazor wrote: Why use SSI? PHP's include directive allows you to bring separate pages together for creating an overall page. You can include .html files. Also, PHP programming isn't *required* in a file with the php extension. I had wondered about that but I must be

RE: [PHP] split behaviour differences in perl and php

2004-09-16 Thread Andrew Martinez
just PHP being its own language. Cheers, Andrew Martinez RubyBay Inc. > -Original Message- > From: Curt Zirzow [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 16, 2004 10:45 AM > To: [EMAIL PROTECTED] > Subject: Re: [PHP] split behaviour differences in perl an

Re: [PHP] checking multiple URL parameters

2004-09-16 Thread Andrew Kreps
On Thu, 16 Sep 2004 11:15:13 -0400, Gryffyn, Trevor <[EMAIL PROTECTED]> wrote: > I could have sworn that there was a function that dropped ALL GET values > into an associative array. Kind of the inverse of "http_build_query". > I believe you're thinking of import_request_variables (). http://us2.

Re: [PHP] checking multiple URL parameters

2004-09-16 Thread Andrew Kreps
On Thu, 16 Sep 2004 12:47:26 -0700 (PDT), Chris Shiflett <[EMAIL PROTECTED]> wrote: > > This makes absolutely no sense to me. What do you mean by submitted? How > would a PHP script be executed at all if the browser never sends a > request? > PHP can be run from the command line, in which case t

Re: [PHP] checking multiple URL parameters

2004-09-16 Thread Andrew Kreps
On Thu, 16 Sep 2004 16:25:31 -0500, Greg Donald <[EMAIL PROTECTED]> wrote: > On Thu, 16 Sep 2004 13:31:08 -0700, Andrew Kreps <[EMAIL PROTECTED]> wrote: > > PHP can be run from the command line, in which case the GET and POST > > arrays wouldn't exist. > > $

Re: [PHP] $i++, incrementing by 10's

2004-09-16 Thread Andrew Kreps
On Fri, 17 Sep 2004 14:07:08 +0800, Louie Miranda <[EMAIL PROTECTED]> wrote: > is it possible to increment by 10's? or 20's? > > i have this piece of code, but it selects from 1 to 1000 and counts by 1's. > for($i = 1; $i <= 1000; $i++) > Yep, just change that last part from $i++ to $i += 10, or

Re: [PHP] sleep() and Max Execution Time

2004-09-18 Thread Andrew Kreps
On Sat, 18 Sep 2004 14:19:55 -0500, Stephen Craton <[EMAIL PROTECTED]> wrote: > I know I can change the default setting in the ini but I might need to span > this script on another server where I may not have the power to do that. > Whenever I go into a loop, and then go sleep(1) or so, after about

Re: [PHP] sleep() and Max Execution Time

2004-09-18 Thread Andrew Kreps
On Sat, 18 Sep 2004 15:19:29 -0500, Stephen Craton <[EMAIL PROTECTED]> wrote: > Thanks, I had a look at this but it doesn't seem that it will solve my > issues, since it just adds on the time the script runs but still limits it. > Any suggestions? > The manual states that if you pass set_time_lim

[PHP] Re: Query takes terribly long

2004-09-18 Thread Andrew Kreps
On Sat, 18 Sep 2004 22:25:12 +0200, Dirk Schippers <[EMAIL PROTECTED]> wrote: > > with indexes: id = primary, putdatetime, userid, > {put,front,topcategory,approvedby} and review. > > If I want to know the 30 most recently added and approved items, I do > the following simple query: > SELECT id F

Re: [PHP] Infinate looping

2004-09-19 Thread Andrew Kreps
On Sat, 18 Sep 2004 19:48:37 -0500, Stephen Craton <[EMAIL PROTECTED]> wrote: > Here's what I'm doing in a nutshell: Loop infinitely, checking for changes > to a database, flushing the data, sleep, and repeat the loop. It all goes > well and I'm getting it to work correctly. However, I'm not sure o

Re: [PHP] PHP and extern link

2004-09-19 Thread Andrew Kreps
On Sun, 19 Sep 2004 01:07:25 +0200, Martin Justra <[EMAIL PROTECTED]> wrote: > Hello, > > I want to write a script which does the following: > > You enter http://www.test.com/test.php?number=123456 > > and the script shows the site > https://www.domain.com/direct_access.do?usert=test&password=te

Re: [PHP] inserting timestamp into mysql field

2004-09-21 Thread Andrew Kreps
On Tue, 21 Sep 2004 16:25:37 +0100, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > i need to insert a current timestamp into a mysql field when a form is posted. > can anyone suggest a simple way of doing this? Here's the MySQL answer: If you have a (data type) timestamp field in your table, you d

Re: [PHP] alternative to mysql_field_name()

2004-09-21 Thread Andrew Kreps
On Tue, 21 Sep 2004 22:01:02 +0100, Luke <[EMAIL PROTECTED]> wrote: > however, i'd like to add more meaningful names as the field name > headings in the excel file. can anyone suggest how i can write a list of > tab separated headings into $header? > If you're talking about hard coding the header

Re: [PHP] ASP guts needs help.

2004-09-22 Thread Andrew Kreps
On Wed, 22 Sep 2004 00:09:01 -0600, LW Ellis <[EMAIL PROTECTED]> wrote: > I'm new to php, but am familar with ASP. > I have this code to open and read a text file. > What I need is to take out the 'while' and present the data one line at a > time. > I read up on fgetcsv, but we will be using one te

Re: [PHP] inserting timestamp into mysql field

2004-09-22 Thread Andrew Kreps
On Wed, 22 Sep 2004 09:29:21 +0100, Chris Dowell <[EMAIL PROTECTED]> wrote: > That's not 100% correct > > If you have more than one TIMESTAMP field only the first (IIRC) will be > filled with the current time - other TIMESTAMP fields will only be filed > if you set them = NULL. > You're absolute

Re: [PHP] Does PHP need another mailing list???

2004-09-22 Thread Andrew Kreps
On Wed, 22 Sep 2004 14:13:37 -0700, Ed Lazor <[EMAIL PROTECTED]> wrote: > 2. Add a new FAQ section on what information to collect when > troubleshooting PHP related problems and how this information can help you > find solutions as quickly as possible - including details on how to discern > whethe

Re: [PHP] PHP Failing to open remote files using include/require

2004-09-23 Thread Andrew Kreps
On Thu, 23 Sep 2004 15:04:26 +0100, Mark Cooke <[EMAIL PROTECTED]> wrote: > I have a server hosted by a company running Win2k, they are in charge of > the maintainance, and we had a site working fine, then yesterday, it > failed to include any files using http:// using: > include ("http://".$_SERVE

Re: [PHP] sending SMS messages to mobile phones from PHP

2004-10-11 Thread Andrew Cowles
ased in the UK; which means our prices are in pounds... but you can pay using most major credit cards, so it shouldn't be a big problem. There is a good currency converter at http://www.xe.com/ if you need it, or I'm sure our Sales staff will happily give you the current rates. Best regar

Re: [PHP] Best practise for resolving potential conflicts when editing db content?

2004-10-11 Thread Andrew Kreps
On Tue, 12 Oct 2004 02:41:10 +1000, Murray @ PlanetThoughtful <[EMAIL PROTECTED]> wrote: > User A finishes his or her page edit and commits the changes, but the > underlying record was already changed by User B's page rename. User A's edit > changes overwrite this update in the record in question,

[PHP] Re: [PHP-INSTALL] Impossibility

2004-10-11 Thread Andrew Kreps
On Mon, 11 Oct 2004 15:20:11 -0400, Scott Hamm <[EMAIL PROTECTED]> wrote: > I know it's impossible, but is there a way php can read something from excel > file? > If you really believe it's impossible, why ask the question? :) Start with the first link here, and work your way down. Thankfully,

Re: [PHP] sending SMS messages to mobile phones from PHP

2004-10-12 Thread Andrew Cowles
g address then you don't need to include the user/pass details in the email, so it'd work with just; mail("[EMAIL PROTECTED]","$message",""); You can also make an HTTP Post. The best way to do this is by writing a quick HTTP Post fun

Re: [PHP] Loop within Loop help please

2004-09-28 Thread Andrew Kreps
On Tue, 28 Sep 2004 10:45:19 -0700, Jason Davidson <[EMAIL PROTECTED]> wrote: > I see lots of references to modulus, which works fantastic.. but how > abut just testing if its equal to 20, then there isnt that extra > arthmitc call.. this is just another way to do the same thing.. take > your pick.

Re: [PHP] classes in php5

2004-09-28 Thread Andrew Kreps
On Tue, 28 Sep 2004 13:46:27 -0600, Daniel Watrous <[EMAIL PROTECTED]> wrote: > In my efforts to port this over to PHP5 I am having trouble. Not only do I not get > back an > instance of my Foo class, but the script execution stops entirely without so much as > a > warning. My first suggesti

Re: [PHP] Loop within Loop help please

2004-09-28 Thread Andrew Kreps
On Tue, 28 Sep 2004 16:22:18 -0300, Eduardo Sampaio <[EMAIL PROTECTED]> wrote: > You missed the $count = 0; > right below it Andrew... his code works just like the modulus one... Whoops, my mistake. I write code, really I do. :) -- PHP General Mailing List (http://www.php.net/) To

Re: [PHP] How do I make an 'email this page' feature?

2004-09-29 Thread Andrew Kreps
On Wed, 29 Sep 2004 22:03:07 +0100, PHP Tech <[EMAIL PROTECTED]> wrote: > > I thought by clicking the link this would be a form sending the url of the > page to the next page and so I could then use $_GET to retrieve this. I > also thought of using $_SERVER and getting the referer web address. Th

Re: [PHP] How do I make an 'email this page' feature?

2004-09-30 Thread Andrew Kreps
On Thu, 30 Sep 2004 08:33:45 +0100, PHP Tech <[EMAIL PROTECTED]> wrote: > Do you mean that I would have a different ID no. for different pages and > pass that variable to the 'email this page' page which will then send the > url according to the ID number? If that's what you mean it sounds like a

Re: [PHP] php script run by cron job

2004-10-01 Thread Andrew Kreps
On Fri, 01 Oct 2004 08:18:55 +0200, Merlin <[EMAIL PROTECTED]> wrote: > Here is the how I did it: > 14 8 * * * root /usr/local/bin/php /home/www/cron/statistics.php > > Does anybody see an error in this? > I'm not familiar with a crontab format that allows you to specify a username as you

[PHP] Including function libraries

2004-10-02 Thread Andrew W
Ok, I've got a file called functions.lib which contains the following: function checkLoggedIn() { return (true); } function Test ($x) { return ($x * $x); } and a file called test.php which contains the following: include 'functions.lib'; if (checkLoggedIn()) { print "Logged

Re: [PHP] Question about handling credit cards

2004-10-05 Thread Andrew Kreps
On Mon, 4 Oct 2004 14:49:44 -0700, Ed Lazor <[EMAIL PROTECTED]> wrote: > I'm looking at online stores and it seems like a lot of them maintain copies > of credit card numbers. Is this true? That seems like a "bad thing" to me, > especially in terms of liability and risk of hackers. On the flip s

Re: [PHP] Page cannot be displayed after form submission

2004-10-07 Thread Andrew Kreps
On Thu, 07 Oct 2004 08:48:01 -0500, Philip Thompson <[EMAIL PROTECTED]> wrote: > > However, I get `Page cannot be displayed` error if the page calls > itself and has to reload some data but only in IE for Windows. If I > hit the `Refresh` button, the page shows up and all the appropriate > fie

Re: [PHP] code not working...help?

2004-10-07 Thread Andrew Kreps
On Thu, 7 Oct 2004 14:14:10 -0400, Matthew <[EMAIL PROTECTED]> wrote: > Hi guys im pretty new at this and cant seem to get this going I want the > code to query the database for the number of messages posted within the last > month this is the code i have but its not working... I might even hav

Re: [PHP] fopen and http://

2004-10-08 Thread Andrew Kreps
On Fri, 8 Oct 2004 08:33:11 -0500 (CDT), Adam Williams <[EMAIL PROTECTED]> wrote: > So now it works except on the > very last line it processes, it prints "does not exist", so there is still > some sort of a hidden character but its not affecting fetching the URLs > from the web server. so i'm sti

Re: [PHP] Quotes """ in form textarea fields

2004-10-08 Thread Andrew Kreps
On Fri, 08 Oct 2004 06:22:22 -0700, Sam Smith <[EMAIL PROTECTED]> wrote: > Then from FROM2.php we Submit BACK to FROM1.php and enter it back into the > textarea field with: > which may also get you past the quoting problem. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit

Re: [PHP] Need help with a string

2004-10-08 Thread Andrew Kreps
On 8 Oct 2004 17:27:10 -, Tim Van Wassenhove <[EMAIL PROTECTED]> wrote: > In article <[EMAIL PROTECTED]>, Greg Donald wrote: > > On Fri, 8 Oct 2004 11:38:23 -0500, Brent Clements > ><[EMAIL PROTECTED]> wrote: > >> Given the following string: > >> > >> $textString = "Share A Dream Come True Para

[PHP] Trying to Integrate PHP 4.3.4 w/ JDK 1.5.0

2004-10-21 Thread Andrew Hauger
Everything compiled okay, and I think everything is installed in the right places. When I try to run a test program, I get the error: [error] PHP Fatal error: java.lang.UnsatisfiedLinkError: no php_java in java.library.path in /usr/local/apache/htdocs/java_test2.php on line 5 The file php_java.j

Re: [PHP] Trying to Integrate PHP 4.3.4 w/ JDK 1.5.0

2004-10-22 Thread Andrew Hauger
I am still getting the error. Here's my configuration: OS: Solaris 9 on Sparc PHP: 4.3.10-dev (as of this morning, was 4.3.4) automake: 1.62 autoconf: 2.53 Again, I would appreciate any useful suggestions. --- raditha dissanayake <[EMAIL PROTECTED]> wrote: > Andrew Hauger wrote: >

Re: [PHP] while-question

2008-11-17 Thread Andrew Ballard
;> >> function add($a , $b) { >> //code here but no + - / * operators > > I'll assume no post/pre-increment operators either. > >> return $answer; >> } >> >> echo add(5, 17); > > function add($a, $b) { > $a = array_merge(array_fill(

Re: [PHP] Date Issue

2008-11-18 Thread Andrew Ballard
e the reasoning of why months and days of the week work that way (even though I think it's counter-intuitive and subtraction is a pretty simple operation). I don't understand why the day of the month or of the year would be zero-based, though. It's almost like the function just takes the number of seconds elapsed since the beginning of the year, divides by 86400 and truncates the result to a integer. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Date Issue

2008-11-18 Thread Andrew Ballard
;d either have to include an empty element in the 0th position of at the beginning of the array, use an associative array, or that last line would have to be changed: var x = month_name['en'][myDate.getMonth() - 1]' Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] mysql_fetch_object and modulo %

2008-11-19 Thread Andrew Ballard
the field in the database. > > Hope this helps, > - Craige > That only works if the query returns rows with contiguous IDs, which is not always the case. If rows get deleted there will be gaps in an autonumber field. Even if no rows are deleted, it is quite common for a query to return ro

Re: [PHP] HTTP Authentication

2008-11-19 Thread Andrew Ballard
of a URL, so shouldn't the username and password be urlencoded? I'm thinking it will work if you replace the '#' sign with %23. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Invalid Arguements

2008-11-19 Thread Andrew Ballard
commercial apps that we host. My impression was that it was more of a templating language for Dreamweaver/Java than what I am used to. Back on topic, your latest error is a syntax error and isn't directly related to the problem you've been talking about. I was going to suggest somet

Re: [PHP] HTTP Authentication [ SOLVED ]

2008-11-19 Thread Andrew Ballard
On Wed, Nov 19, 2008 at 12:47 PM, Thiago H. Pojda <[EMAIL PROTECTED]> wrote: > On Wed, Nov 19, 2008 at 12:15 PM, Andrew Ballard <[EMAIL PROTECTED]> wrote: >> >> On Wed, Nov 19, 2008 at 9:26 AM, Thiago H. Pojda <[EMAIL PROTECTED]> >> wrote: >> > Guys

Re: [PHP] Curl with asp pages....

2008-11-27 Thread Andrew Ballard
SELECT MULTIPLE lists) such that ASP does not need (and should not use) square brackets in field names the way PHP does. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Curl with asp pages....

2008-11-28 Thread Andrew Ballard
y a lifesaver. FWIW, there is a similar tool for IE too, if you ever find yourself stuck for one of those lovely cases where the site works fine in Firefox but not in IE. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Curl with asp pages....

2008-11-28 Thread Andrew Ballard
escaped); the other turns the recordset into a multi-dimensional array. As I recall, though, the indexes are "reversed". > Sadly, the song is lost as I failed to make a copy of that codebase before I > moved on to another task. Sadly? Are you really pining for it? :-) Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Parsing XML

2008-11-28 Thread Andrew Ballard
e document put into an array tree, which is fine for > what I need so far. > > > Ash > www.ashleysheridan.co.uk A bit over the top, but you could always use XSL to turn it into CSV. LOL Andrew

Re: [PHP] Last working day of a month

2008-12-04 Thread Andrew Ballard
lumns to indicate whether each date is a workday, weekday, weekend, holiday, or any other date category/group that you need to track. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] IE8 and HTML5

2008-12-05 Thread Andrew Ballard
e a whole different batch of problems than the beta. :-) Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Help with IF ELSE

2008-12-05 Thread Andrew Ballard
gt; > SanTa > No, the solution would be mysql_real_escape_string(), or equivalent if using another database engine. However, in this case since you are encrypting the value (and since many encryptions return binary data) you could either hexdec() or base64encode() the value as well. Andrew

Re: [PHP] Help with IF ELSE

2008-12-05 Thread Andrew Ballard
e PHP automatically sets a 302 on a Location: header when the parameter is empty. http://www.php.net/header Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] How to fetch .DOC or .DOCX file in php

2008-12-05 Thread Andrew Ballard
n some additional control characters in some of the documents I tried, and some documents had extra stuff at the end of the document. It was still text, but it looked like the text from the page header/footer definitions. It would be cool to see this polished and released. I just wish there was someth

Re: [PHP] Poll of sorts: Javascript Form validation or PHP

2008-12-05 Thread Andrew Ballard
rver-side validation is a MUST, no questions asked. If the client has javascript disabled, or someone uses wget, curl, etc. to send data, it still needs to be validated! Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] A MySQL Question

2008-12-08 Thread Andrew Ballard
ROMsometable AS a WHERE a.keyid NOT IN ( SELECT b.keyid FROMsomeothertable AS b ) SELECT a.* FROMsometable AS a WHERE NOT EXISTS ( SELECT * FROMsomeothertable AS b WHERE a.keyid = b.keyid ) Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] MSSQL_CONNECT problem

2008-12-09 Thread Andrew Ballard
on't stand up to SQL > injection...So I wanted to use mssql_connect with "mssql_bind" so I can do > parameterized queries > > Do you have any other thoughts? > > Thanks! > I've had decent luck so far with the SQL Server Driver for PHP published by

Re: [PHP] Need help on MySQL query

2008-12-10 Thread Andrew Ballard
hat involve NULL yield a NULL value. With the example you posted, it would be like saying "When I went to the bank December 1, I deposited 10000.00 but I don't know how much I withdrew." What would you say the net value of such a transaction would be? In your database, neither `withdrawn` nor `deposit` should be UNKNOWN/MISSING. (At least I would hope not!) Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Foreign Keys Question

2008-12-11 Thread Andrew Ballard
rs the fuzzy > thinking. > > Thanks, > > tedd > That's the way to go. Just keep in mind that you will have to consider ways of preventing overloading your courses due to concurrency, whether you use table locks or devise your own mechanism. I don't know if you are

Re: [PHP] search for person by comparing his data with data in mysql

2008-12-20 Thread Andrew Ballard
s the expressions (e.g. email = '$email') > evaluate to bools and are auto-cast to ints. > > Im guess there needs to be some parenthesis in there somewhere, no? > > anyway nice snippet :-) > If it works, it must be a MySQL "feature". Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] IE Problem Detecting Post Variables

2009-01-02 Thread Andrew Ballard
ot; attribute. Whatever the reason, that was a fun lesson to track down the first time I had people tell me a page I wrote didn't work in IE. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Searching in a long text

2009-01-03 Thread Andrew Ballard
highly relevant result could be returned at the bottom of the list as two less-relevant results because of the line split. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] A beginner´s question

2009-01-05 Thread Andrew Ballard
> Unless you have taken steps to ensure that the value of $tastes does not include any HTML markup, you want to escape the value: Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] a weired query issue

2009-01-08 Thread Andrew Ballard
If I was wrong, then I would like to know better. > > Cheers, > > tedd > I can take or leave the backticks. However, one of my pet peeves is comparing a string/varchar value to a numeric column. I know that most databases will implicitly convert the character value to an integer when th

Re: [PHP] header("Location: ") wont show up in logs of either server

2009-01-08 Thread Andrew Ballard
> script being called. > > Any ideas? > > I'll take the simple answer and say neither script IS being called? OK, I'll go back to my corner now. Andrew [Geesh - I take the time to send out a sarcastic message and forget to send it to the list.] -- PHP General Mailing

Re: [PHP] Adressing XML Objects

2009-01-08 Thread Andrew Ballard
ccess. > > Thank you for any hint. > > Best regards, Merlin > I haven't used SimpleXML too much, but aren't you just looking for this? $attributes = $xml->anbieter->immobilie->anhaenge->daten->anhanginhalt->anhang->attributes(); echo $attributes['loc

Re: [PHP] Re: redoing website after 7 years

2009-01-09 Thread Andrew Ballard
ou did search and replace? > > ;) > > Cheers, > Rob. Doesn't your search and replace tool support regular expression matching and replacement? Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Re: hello

2009-01-09 Thread Andrew Ballard
to the Internet to be insecure. > > Cheers, > > tedd > Nope. It just has to accept instructions. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Re: hello

2009-01-09 Thread Andrew Ballard
do that with this list sometimes :p >>> >> >>You can. >> >> >> >> > > turns out the official word from php itself is that this list doesn't exist > *oh nos* > > Warning: unlink(php-general@lists.php.net) [ href='function.unli

Re: [PHP] Re: hello

2009-01-09 Thread Andrew Ballard
On Fri, Jan 9, 2009 at 12:35 PM, Daniel Brown wrote: > On Fri, Jan 9, 2009 at 12:34, Andrew Ballard wrote: >> >> Now... you'd have really freaked out if that had actually worked! LOL > > Hey, good point, Andrew. > >Nate, you do know that was only pseudo-c

Re: [PHP] Couple of beginner questions

2009-01-09 Thread Andrew Ballard
On Fri, Jan 9, 2009 at 12:18 PM, Gary wrote: > I've done a number of sites in html and am now venturing into php. > > Can I create a page in html and insert php code that will work? (for > example, take an existing page and insert a date command) Not unless you configure your web server to parse

Re: [PHP] Couple of beginner questions

2009-01-09 Thread Andrew Ballard
ime-type. 2) You have to configure the web server to use something like mod_rewrite to point URLs to the correct script. 3) You create a folder for every unique page in the entire site and each folder contains exactly one file named either index.php or index.html (or whatever the default document n

Re: [PHP] Re: redoing website after 7 years

2009-01-12 Thread Andrew Ballard
On Sun, Jan 11, 2009 at 5:09 PM, Robert Cummings wrote: > On Mon, 2009-01-12 at 09:00 +1100, Chris wrote: >> Robert Cummings wrote: >> > On Fri, 2009-01-09 at 08:56 -0500, Andrew Ballard wrote: >> >> On Fri, Jan 9, 2009 at 2:09 AM, Robert Cummings >> >>

Re: [PHP] Re: Re: Php and CSS where to put it

2009-01-13 Thread Andrew Ballard
lf in everything except IE ;) > > > Ash > www.ashleysheridan.co.uk In my experience, it's usually IE that is doing the misbehaving. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Re: php session GC error

2009-01-13 Thread Andrew Ballard
memory. 2) Because the cookie now has a lifetime, it is still valid even if the browser closes and reopens within the cookie_lifetime. Neither of these are something I want. Because of that (and the occasional need to persist sessions on clustered web servers) I usually write my own session s

Re: [PHP] Basic Authentication

2009-01-14 Thread Andrew Ballard
13 characters), but based on the manual that seems to be variable with the system anyway. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Basic Authentication

2009-01-14 Thread Andrew Ballard
inal post. > > I do have before and after examples I could use to identify what algorithm > was used. I just need to know what algorithms could have been used and (if > it's not too much to ask) working example of each. > > Cheers, > > tedd > So can you not j

Re: [PHP] Basic Authentication

2009-01-14 Thread Andrew Ballard
like a totally different question from your original post. Are you saying that you already have values in the .htaccess file that don't match what you expect when you run the known passwords through crypt()? What do you get when you try this? It's been a while since I've used this,

Re: [PHP] Zend Framework...where to start? -- don't.

2009-01-14 Thread Andrew Ballard
On Wed, Jan 14, 2009 at 7:26 PM, Eric Butera wrote: > On Wed, Jan 14, 2009 at 6:47 PM, Daevid Vincent wrote: >> On Wed, 2009-01-14 at 14:28 -0800, Kyle Terry wrote: >> >>> On Wed, Jan 14, 2009 at 2:18 PM, Eric Butera wrote: >>> >>> > On Wed, Jan 14, 2009 at 5:03 PM, Robert Cummings >>> > wrote:

Re: [PHP] Dirty Button

2009-01-26 Thread Andrew Ballard
gt;> >>> Cheers, >>> >>> tedd >>> --- >>> http://sperling.com http://ancientstones.com http://earthstones.com > This is veering away from PHP and into JavaScript, but there are defaultValue (for text and textarea) and defaultSelected

Re: [PHP] Non-traditional software accessing my website

2009-01-26 Thread Andrew Ballard
On Mon, Jan 26, 2009 at 2:14 PM, Thiago H. Pojda wrote: > On Mon, Jan 26, 2009 at 4:13 PM, Robert Cummings wrote: > >> On Mon, 2009-01-26 at 13:04 -0600, R B wrote: >> > Hello, >> > >> > Is there a way to be sure that a website is going to be accessed only by >> > traditional browsers and not from

Re: [PHP] Get Money Fast with the Government Grants

2009-01-27 Thread Andrew Williams
Hi, Beware of he spam mailer so do not let them spam your money away. Andrew On Tue, Jan 27, 2009 at 9:18 AM, clive wrote: > Dora Gaskins wrote: > >> If you have received this email, take a time to really read it carefully! >> >> American Gov Money >> > More

Re: [PHP] Global Changes With Loop To Allow Nulls In A Table...

2009-01-27 Thread Andrew Ballard
uments I've read against them, but I tend to agree that the number of columns that accept NULL values should be kept as small as possible. Even if you decide that you need to allow NULL values in some cases, IMHO I wouldn't write a script that ran through my entire database and opened every column in every table to accept. Just my 2 cents. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Global Changes With Loop To Allow Nulls In A Table...

2009-01-27 Thread Andrew Ballard
On Tue, Jan 27, 2009 at 12:58 PM, Boyd, Todd M. wrote: >> -Original Message- >> From: Andrew Ballard [mailto:aball...@gmail.com] >> Sent: Tuesday, January 27, 2009 11:39 AM >> To: revDAVE >> Cc: php-general@lists.php.net >> Subject: Re: [PHP] Global C

Re: [PHP] Global Changes With Loop To Allow Nulls In A Table...

2009-01-28 Thread Andrew Ballard
've seen several that use one table with NULL columns for > steps that haven't yet been processed. > > > // Todd > Even so - I would think it undesirable (and dangerous) for EVERY column (including primary/foreign keys) in EVERY table to allow NULL values. Granted, I don't know the nature of the project here, nor the problem being addressed. I just wanted to raise a flag noting that this MAY not be a great idea in the event a self-described "newbie" hadn't considered the potential pitfalls he could be introducing. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Making a Variable from different tables with Matching Db fields?

2009-01-28 Thread Andrew Ballard
I think it's the preferred) is $sql = "SELECT workorders.WorkOrderID , workorders.AdminID, admin.AdminID FROM workorders INNER JOIN admin ON workorders.AdminID = admin.AdminID WHERE admin.UserName = '" . mysql_real_escape_string($username) . "'"; Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Making a Variable from different tables with Matching Db fields?

2009-01-28 Thread Andrew Ballard
On Wed, Jan 28, 2009 at 4:22 PM, Christoph Boget wrote: >> Well I'm stuck I have the AdminID but now I can't seem to use it to pull >> workorders with that AdminID . I couldn't get your block to work Andrew :( >> I think I'm just not using it right now tha

<    2   3   4   5   6   7   8   9   10   11   >