RE: [PHP] Currency Exchange Database?

2007-06-28 Thread Andy B.
You could have a look at the Euro foreign exchange reference rates rom the European Central Bank. They also provide a regularly updated XML file: http://www.ecb.int/stats/exchange/eurofxref/html/index.en.html Hope it helps... Andy -Original Message- From: Tom Ray [Lists] [mailto:[

RE: [PHP] mail() only working with php-cli

2007-05-07 Thread Andy B.
. A simple error message like "/usr/sbin/sendmail: permission denied" would have made it. Regards, Andy -Original Message- From: Richard Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 01:01 To: Andy B. Cc: php-general@lists.php.net Subject: Re: [PHP] mail() only

RE: [PHP] mail() only working with php-cli

2007-05-06 Thread Andy B.
3:58 To: php-general@lists.php.net Cc: Andy B. Subject: Re: [PHP] mail() only working with php-cli Hello Andy, did you take a look into the apache log files? Regards, Oliver Am Samstag, 5. Mai 2007 22:53 schrieb Andy B.: > Is there any way to debug the mail() function within PHP4 or PHP5? > &

RE: [PHP] mail() only working with php-cli

2007-05-05 Thread Andy B.
ve already tested with E_ALL and also dumping errors/warnings into log files... Andy -Original Message- From: Tijnema ! [mailto:[EMAIL PROTECTED] Sent: Saturday, May 05, 2007 23:58 To: Andy B. Cc: php-general@lists.php.net Subject: Re: [PHP] mail() only working with php-cli Are you

[PHP] mail() only working with php-cli

2007-05-05 Thread Andy B.
Is there any way to debug the mail() function within PHP4 or PHP5? The following code is not working when called from a browser, but it does work from the command line: php and php-cli use the same php.ini file. Php via Apache is launched as a module, NOT as CGI! sendmail_path is correctly se

[PHP] GUI editor for php?

2004-11-01 Thread Andy B
Hi. Is there any GUI editors out there for php? if so does anybody know of a good one that doesnt cost a ton of money?? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] MultiSelect List Box in PHP

2004-10-31 Thread Andy B
27;t being built right... you can change it to work with your db just change the connect string and the field list from a db to test it... -Original Message- From: Marek Kilimajer [mailto:[EMAIL PROTECTED] Sent: Sunday, October 31, 2004 4:14 PM To: Andy B Cc: PHP mailing list Subject

RE: [PHP] MultiSelect List Box in PHP

2004-10-31 Thread Andy B
I need to be able to print the selected items without the "array..." thing around it. so example would be if 1 and 2 are selected it would print: 1, 2 it's supposed to be formatted for the user... -Original Message- From: -{ Rene Brehmer }- [mailto:[EMAIL PROTECTED] Sent: Sunday, Octobe

RE: [PHP] MultiSelect List Box in PHP

2004-10-31 Thread Andy B
creen?? -Original Message- From: Eric Lee [mailto:[EMAIL PROTECTED] Sent: Sunday, October 31, 2004 3:06 AM To: Andy B Subject: Re: [PHP] MultiSelect List Box in PHP it's just likes you used in normal html & javascript, but the code that generated to control the ui are now moved t

[PHP] MultiSelect List Box in PHP

2004-10-30 Thread Andy B
Hi. I was just wondering where I can find info on how to use a MultiSelect List Box with PHP? I need to use it with MYSQL 5.0.0, PHP 4.3.9, and windows XP sp2. Any help/leads would be greatly appreciated. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.ne

[PHP] adult content censoring

2004-04-25 Thread Andy B
hi... i have to make an adult content censoring system so people cant post "bad" words on any public viewable posts. i know preg_replace and possibaly preg_match would be a huge help but im wondering how i would put all the bad words in a file (textfile) 1 word on a line and have it look through t

Re: [PHP] formatting a string

2004-04-24 Thread Andy B
[snip] $phone = '1234567890'; $newphone = preg_replace('/(\d{3})(\d{3})(\d)/','(\1)\2-\3',$phone); echo $newphone.''; -- regards, Tom [/snip] ok sorry but since i never used preg_* before i dont quite get what some of this stuff means. i looked at the doc page for it but it doesnt make mention at

[PHP] formatting a string

2004-04-24 Thread Andy B
hi... i have a string i want to pull out of a database (mysql). the column name is Phone1 and it is a 10 digit phone number. the raw string coming out of the table column would look like this: 1234567890 what i want to do is format the string on display like this: (123)456-7890 but dont quite kno

Re: [PHP] mouse over problem on php

2004-04-24 Thread Andy B
try javascript - Original Message - From: "gowthaman ramasamy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 24, 2004 8:11 AM Subject: [PHP] mouse over problem on php > hi list , > In the web page, i display different bars (actually tables with single > column, with

Fw: [PHP] php/apache/mysql on ntfs

2004-04-24 Thread Andy B
does anybody have any idea why this message keeps coming up every time i send a msg to the list?? im sort of confused now - Original Message - From: <[EMAIL PROTECTED]> To: "Andy B" <[EMAIL PROTECTED]> Sent: Saturday, April 24, 2004 7:17 AM Subject: NDN: [PHP] ph

[PHP] php/apache/mysql on ntfs

2004-04-24 Thread Andy B
hi... we are upgrading test servers to xp home and want to know if its possible to run php/apache/mysql and all that sort of stuff on ntfs or does the servers have to run fat32?? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Question about the mail() php function

2004-04-24 Thread Andy B
hi... the reason that mail() wont work on windows without an smtp server (outgoing mail server) is because normally windows doesnt have a mail server installed. the default smtp settings in php.ini usually is for *nix systems (that is if it is even set). it is very easy to fix: go into c:\windows

Re: [PHP] online php books

2004-04-22 Thread Andy B
ok tnx will try it out and have a look around (hopefully they take paypal) since i dont have a credit card at least not yet anyways... - Original Message - From: "Richard Davey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 22, 2004 9:40 PM Subject: Re: [PHP] online p

[PHP] online php books

2004-04-22 Thread Andy B
hi... just wondering if there are any good php books that are online (even if you have to buy them)... just as long as they are online or downloadable.. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] self documenting php

2004-04-22 Thread Andy B
so far i like phpdoc... most reliable that i found and besides it gives more of a range of different output types: chm (windows help file format) html, xml, pdf and so on... i think its pretty cool... - Original Message - From: "Edward Peloke" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>

Re: [PHP] Re: phpedit

2004-04-22 Thread Andy B
t; it needs to download them (~12 Mb), then it all depends on your connection. > > "Andy B" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > i know this isnt quite php exactly but anybody thats ever installed > phpedit > > before remember how

Re: [PHP] mysql version

2004-04-22 Thread Andy B
select version as version; if used directly in the server (i.e. mysql)... if you want to use it in php: $query="select version() as mysql_version"; $result=mysql_query($query) or die(); if(!$result){ echo "cant determine mysql version"; } else { //whatever you want to do with it } - Origina

[PHP] phpedit

2004-04-21 Thread Andy B
i know this isnt quite php exactly but anybody thats ever installed phpedit before remember how long it took to install on windows?? seems like mine is taking about 6 hours to install for some strange reason... its either massive huge or my computer is super slow for some reason... -- PHP Genera

Re: [PHP] Unwanted e-mails

2004-04-19 Thread Andy B
hahahaha!! go for it grin!! - Original Message - From: "Ryan A" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, April 19, 2004 7:59 PM Subject: Re: [PHP] Unwanted e-mails > > > when i talked to my internet people about those sorts of emails like > > bt

Re: [PHP] Unwanted e-mails

2004-04-19 Thread Andy B
they arent just coming from the people who want to unsubscribe?? they are going to people who just want to send a message to the list too... got rid of the info desk the advanced whatever and the pandasoft stuff but having problems with mysql mailing list myself too... same sort of problems... -

Re: [PHP] Images & PHP

2004-04-19 Thread Andy B
dont know that much about images at the minute but phpclasses.org has tons of image classes that might help... - Original Message - From: "Tim Thorburn" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 19, 2004 7:12 PM Subject: [PHP] Images & PHP > Hi, > > I've created a

Re: [PHP] Unwanted e-mails

2004-04-19 Thread Andy B
> BUT that does not help at all. btconnect is my service provider, and I > have to send my eMails through them. The messages are caused by > lists.php.net not accepting my messages >but your messages *ARE* getting accepted otherwise i >would not be >reading this email right now! >chris.

Re: [PHP] Unwanted e-mails

2004-04-19 Thread Andy B
i guess that would be a slight problem then - Original Message - From: "Lester Caine" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 19, 2004 6:36 PM Subject: Re: [PHP] Unwanted e-mails > Andy B wrote: > > > i know i got tons of t

Re: [PHP] Unwanted e-mails

2004-04-19 Thread Andy B
i know i got tons of those before... all i did was block the btconnect address and be done with it just ignore them at least thats all i did - Original Message - From: "Lester Caine" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 19, 2004 6:02 PM Subject: Re: [PHP] U

[PHP] inovative award

2004-04-15 Thread Andy B
just wondering if there is a website where i can find out everything needed to know on that inovation award thing... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] PHP Programming Innovation Award

2004-04-14 Thread Andy B
lt;[EMAIL PROTECTED]> Sent: Thursday, April 15, 2004 1:49 AM Subject: Re: [PHP] PHP Programming Innovation Award > Hello, > > On 04/15/2004 01:54 AM, Andy B wrote: > > one question though how can you tell if a class or package you are > > writting or want to at

Re: [PHP] mysql connect function in my class

2004-04-14 Thread Andy B
e: [PHP] mysql connect function in my class > * Thus wrote Andy B ([EMAIL PROTECTED]): > > hi > > i have this function inside a class that im writing that eventually i want > > to put inside a package of my own... the function goes like this: (comment > > block i

Re: Re[2]: [PHP] mysql connect function in my class

2004-04-14 Thread Andy B
>How many versions of the wheel exist in the world >today? ...not many >hacked out of stone I bet :-) > >-- >regards, >Tom what does that mean?? is everybody saying i should give up on this idea then?? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/un

Re: [PHP] PHP Programming Innovation Award

2004-04-14 Thread Andy B
one question though how can you tell if a class or package you are writting or want to attempt to write has ever been created before?? 99.9% of the time anything i ever thought of for classes/packages to write are either too simple or the idea has already been created before... i.e. i want

[PHP] mysql connect function in my class

2004-04-14 Thread Andy B
hi i have this function inside a class that im writing that eventually i want to put inside a package of my own... the function goes like this: (comment block included): /** *function Connect: open connection to database. * [EMAIL PROTECTED] string $host mysql hostname to connect to [EMAIL PRO

Re: [PHP] automatic doc generation for classes

2004-04-13 Thread Andy B
though...gues it could be a slight better but overall its ok... grin - Original Message - From: "Richard Harb" <[EMAIL PROTECTED]> To: "Andy B" <[EMAIL PROTECTED]> Sent: Wednesday, April 14, 2004 1:43 AM Subject: Re: [PHP] automatic doc generation for cla

Re: [PHP] automatic doc generation for classes

2004-04-13 Thread Andy B
des\converter.php on line 4199 cant quite tell what im doing wrong but going to go through the docs and see if i messed it up somehow... - Original Message - From: "Richard Harb" <[EMAIL PROTECTED]> To: "Andy B" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]&g

[PHP] automatic doc generation for classes

2004-04-13 Thread Andy B
does anybody have any good recommendations for anything to do auto doc generation for php classes/functions and stuff.. like phpdoc or something of that sort? what ones are the best to use for windows -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP] class design

2004-04-12 Thread Andy B
hi... i was reading something on phppatterns website about class design. the reading said that its best to take say a db extraction class that you might want to write and instead of making one super huge class out of it called "db" or whatever it would be called but to turn that "db" class into a

Re: [PHP] creating log files out of a delete statement

2004-04-11 Thread Andy B
got it will try that instead.. - Original Message - From: "John W. Holmes" <[EMAIL PROTECTED]> To: "Andy B" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, April 11, 2004 8:23 PM Subject: Re: [PHP] creating log files out of a delete stat

Re: [PHP] using $_SESSION inside of user functions

2004-04-11 Thread Andy B
didnt know if it was possible to use $_SESSION vars in that function or any user defined functions for that matter... - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, April 11, 2004 8:11 PM Subject: Re: [PHP] using $_SESSION inside of user functions

[PHP] using $_SESSION inside of user functions

2004-04-11 Thread Andy B
//log function //writes log files function WriteLog($LogType){ switch($LogType: case "login": //use session vars here... } -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] creating log files out of a delete statement

2004-04-11 Thread Andy B
hi... i have a section of a website that deletes records from a mysql table... right now all the query is is a delete statement but i need to make a "log file" in this format: current time::username who executed delete:: deleted(name of record)::delete completed or delete failed depending on what

[PHP] [solved][ignore]Re: [PHP] cannot find server even though the page is there?

2004-04-11 Thread Andy B
found problem...apache died somehow for some reasonall better now - Original Message - From: "Andy B" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, April 11, 2004 6:32 AM Subject: [PHP] cannot find server even though the page is there? > hi

[PHP] cannot find server even though the page is there?

2004-04-11 Thread Andy B
hi... i have a page on my test web server... it has php/mysql stuff in it that points to another db elsewhere that i have remote access to... my ip address/domain name exist but when i go to it to test the page it says cannot find server?? im lost now...it worked last night why not now... -- PHP

Re: [PHP] Re: query strings coming from the same page going back to the same page

2004-04-10 Thread Andy B
> To: <[EMAIL PROTECTED]> Sent: Saturday, April 10, 2004 6:33 PM Subject: [PHP] Re: query strings coming from the same page going back to the same page > Andy B schrieb: > > was wondering if this would work or do i need different code: > > > include("libs/conf.db"

[PHP] query strings coming from the same page going back to the same page

2004-04-10 Thread Andy B
was wondering if this would work or do i need different code: 12)){ $query="SELECT Type, StartDate, EndDate, Name, County, Notes FROM $EventsTable ORDER BY StartDate DESC"; } else { $query="SELECT Type, StartDate, EndDate, Name, County, Notes FROM $EventsTable WHERE StartingMonth='{$_GE

Re: [PHP] php 5 install

2004-04-10 Thread Andy B
anybody know how to put that in english?? i have no clude what it says... - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 10, 2004 5:13 PM Subject: Re: [PHP] php 5 install > Hallo und guten Tag, > > herzlichen Dank für Ihre Mail. > > Zeit zu

[PHP] php 5 install

2004-04-10 Thread Andy B
if i install php5 will it affect any of the php4.3.3 code that i have running at all...?? i want to install 5 and see what they have new going on and stuff but i dont want to crash my 4.3.3 running code any and where would i be able to read a list of stuff that is new in 5?? -- PHP General M

[PHP] php as cgi and module at same time

2004-04-10 Thread Andy B
is it possible to have php installed with apache as cgi and module both at the same time...?? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] stripping the query string from url

2004-04-10 Thread Andy B
i have to write code for the following standard: 1. 13 links at the top and bottom of the page 2. those links reload the same page with a query string that will be part of a mysql query 3. all query strings that come from anywhere except from say www.test.com/ViewEvents.php get stripped out and ign

Re: [PHP] writing a class in php to print form elements

2004-04-09 Thread Andy B
>I think just about everybody re-invents that wheel ... well i dont have much of a choice but to reinvent that wheel because as far as im aware of the gpl/lgpl doesnt allow me to write code, say sell that webservice/php program for $100 and also have gpl/lgpl code in it (as well as copyright proble

Re: [PHP] ATTN: List Admins

2004-04-09 Thread Andy B
i just blocked them whatever they are but still dont need any strange stuff going on... somebody might want to check into a "pandasoft" autoresponder that keeps answering my messages saying that the list couldnt accept them and it was deleted and blocked because i have a virus?? i had people try s

Re: [PHP] "\n" doesnt work in error_log and windows?

2004-04-09 Thread Andy B
everything works now tnx - Original Message - From: "Jay Blanchard" <[EMAIL PROTECTED]> To: "Andy B" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, April 09, 2004 10:45 AM Subject: RE: [PHP] "\n" doesnt work in error_log and wi

[PHP] "\n" doesnt work in error_log and windows?

2004-04-09 Thread Andy B
i have this sort of a log string: error_log("\n".$date.":".$_SESSION['username'].":Logged in:normal login\n", 3, $LogPath."admin.log"); problem is when it writes the entry in a file the first one shows up fine but when you get 2 or more in it then it either strings the lines together (the second e

Re: [PHP] security on shared servers

2004-04-09 Thread Andy B
> You don't have access to anything outside of the webroot? If /home/user/www/ > is your webroot, then write them to /home/user/. If you're saying you can't > do that and they have to be put under the webroot, then give them .php > extensions and make the first line > > > > Then they can't be view

[PHP] security on shared servers

2004-04-09 Thread Andy B
hi... im writing this admin system for a website and need to have it write system logs to its own log files... the only problem i can really see is that its on a shared webserver and all files are restricted to your own domain/vhost dirs (whatever those happen to be). the admin wont let anybody pu

Re: [PHP] Looking for a comprehensive PHP tutorial

2004-04-09 Thread Andy B
www.php.net/manual/ might help - Original Message - From: "Ash.." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 09, 2004 5:34 AM Subject: [PHP] Looking for a comprehensive PHP tutorial > Hi, > > I am looking for a comprehensive handholder tutorial, that introduces the

[PHP] self referencing links?

2004-04-08 Thread Andy B
hi... i have a page called ViewEvents.php. at the top of the page and at the bottom of the page there is a bar with links on them jan-dec and view all. all 13 links are supposed to call the same page(ViewEvents.php) each link with a different query string. for example: jan=ViewEvents.php?request_m

Re: [PHP] page design and possible conflict??

2004-04-08 Thread Andy B
dont know what his deal is but ok will close this idea now i guess.. - Original Message - From: "Miles Thompson" <[EMAIL PROTECTED]> To: "Andy B" <[EMAIL PROTECTED]> Sent: Thursday, April 08, 2004 7:41 AM Subject: Re: [PHP] page design and possible confl

[PHP] page design and possible conflict??

2004-04-08 Thread Andy B
hi.. this might be sort of ot and out of the range of the list but i had a site design question: is it an absolute no no to put inset borders 3px wide around "EVERY" table on the section of the site?? im trying to make an attempt at making the site have some sort of layout standards and that happe

[PHP] html forms class in php

2004-04-07 Thread Andy B
hi yesterday i posted a msg about wanting to know if it was a good idea to write a class that created/dealt with html forms and so on... somebody told me to go look at html_quick_forms class and it looks good like everything i would want to do but there is 1 problem: is there any classes for the s

Re: [PHP] very large and long if statement

2004-04-07 Thread Andy B
;]['StartingDay']) > && !empty($_SESSION['add']['StartingMonth']) > && !empty($_SESSION['add']['StartingYear']) > && !empty($_SESSION['add']['EndingDay']}) > && !empty($_SESSION['ad

Re: [PHP] path to binary for php on linux

2004-04-07 Thread Andy B
hp on linux > * Thus wrote Andy B ([EMAIL PROTECTED]): > > anybody know what the exact path for the php binary on linux is? > > Depends on how it was installed, a common place is: > /usr/local/bin/php > > Or you can type: > which php > > and it will tell y

[PHP] path to binary for php on linux

2004-04-07 Thread Andy B
anybody know what the exact path for the php binary on linux is? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] very large and long if statement

2004-04-07 Thread Andy B
I have this very large and long if statement: if (!empty($_SESSION['add']['type']) && !empty($_SESSION['add']['start_date'] && !empty($_SESSION['add']['end_date']) && !empty($_SESSION['add']['name']) && !empty($_SESSION['add']['county']) && !empty($_SESSION['add']['discription']) && !empty($

Re: [PHP] confused big time

2004-04-07 Thread Andy B
- Original Message - From: "Chris W. Parker" <[EMAIL PROTECTED]> To: "Andy B" <[EMAIL PROTECTED]> Sent: Wednesday, April 07, 2004 6:30 PM Subject: RE: [PHP] confused big time Andy B <mailto:[EMAIL PROTECTED]> on Wednesday, April 07, 2004 2:09

[PHP] writing a class in php to print form elements

2004-04-07 Thread Andy B
hi... is it totally usefull/reasonable to write a class in php that prints different different form elements in html... i.e. inputs, buttons, drop downs, multi selects and son? that way (at least i think) then it would be easier to change the element attributes dynamically... -- PHP General Mai

Re: [PHP] radio buttons checked or not

2004-04-07 Thread Andy B
- Original Message - From: "Daniel Clark" <[EMAIL PROTECTED]> To: "Andy B" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, April 07, 2004 4:22 PM Subject: Re: [PHP] radio buttons checked or not > My understanding is if the va

[PHP] creating sql statements?? was:confused big time

2004-04-07 Thread Andy B
> I always found this way of inserting data into a database messy. Here is > a handy function to do array inserts and it builds the sql for you. > > function arrayINSERT($a,$tablename) > { > $sql = "INSERT INTO $tablename ("; > foreach($a as $key => $value) > { > $sql .= $key .","; > } > $sql[strle

Re: [PHP] warning:supplied argument to mysql_fetch_array not valid resource type?

2004-04-07 Thread Andy B
>[snip] >i have this query set: >$EditQuery="select * from $EventsTable where >Id='$edit'"; >$query=mysql_query($EditQuery)||die(mysql_error()); >[/snip] > >You forgot the connection string arguement in >mysql_query even after putting in my standard mysql_connect(.) stuff it still fails now the

Re: [PHP] radio buttons checked or not

2004-04-07 Thread Andy B
>Assuming $old['Type'] somehow comes from >$_REQUEST['eventtype'] (or is >related to it), then yeah, that'll work. no its coming from a db result from fetch_array() of which im having an interesting problem with right now but thats in another post -- PHP General Mailing List (http://www.php.net/

[PHP] warning:supplied argument to mysql_fetch_array not valid resource type?

2004-04-07 Thread Andy B
i have this query set: $EditQuery="select * from $EventsTable where Id='$edit'"; $query=mysql_query($EditQuery)||die(mysql_error()); //later in the code i have this: while($old=mysql_fetch_array($query)){ //do stuff } when i run the page i get: warning: supplied argument to mysql_fetch_array is not

[PHP] radio buttons checked or not

2004-04-07 Thread Andy B
hi... i have this code: Yes No was just wondering if that was the right way to determine the state of a radio button...? if the value of $old['Type']="Annual" then the yes button is checked...if not then the no button is checked instead... -- PHP General Mailing List (http://www.php.net/) To u

[PHP] php and drop down boxes

2004-04-06 Thread Andy B
hi... i have a few things i need and dont know where to go to get some ideas/examples of how to do some things: 1. i need to know how to take info from a mysql db load it into a dropdown box and then select as the default choice whatever value was in the db: i.e. i have a combo box with the month

[PHP] assign mysql query to a variable first or not

2004-04-06 Thread Andy B
hi... is it better to give the mysql query string to a variable instead of directly doing it with mysql_query? i.e. $query="select * from table";//is this a better way? $query=mysql_query("select * from table");//or is this way //better? mysql_query("select * from table");//not a good idea i do

Re: [PHP] confused big time

2004-04-06 Thread Andy B
>i was hoping that wouldn't cause any confusion, but i >guess it did. the >thing to remember is that a query is a query. you know, >parts is parts. oops stress and the fact that im sort of new at this stuff mixed me up... $query="insert into table values( '{$array['index1']['index2']}', '{$array[

Re: [PHP] confused big time

2004-04-06 Thread Andy B
> AB> 1. how were those queries unreadable?? and > > You're kidding, right? sorry...my bad... never had any "writing readable code" help anywhere...guess if i do it like c/c++ then it would work better > > AB> 2. whenever i put '' around the array keys in multi dimensional arrays in a > AB> query

Re: [PHP] confused big time

2004-04-06 Thread Andy B
> He was showing you a neatly formatted query, the example applies to > inserts too: > > $sql = " > INSERT INTO >tablename >( > field1, > field2, > field3 >) > VALUES > ( > '$blah', > $here

[PHP] [fixed!][PHP] confused big time

2004-04-06 Thread Andy B
ok query is fixed for the second one now... now to work on the if(!empty.. tests i have to check and make sure every one of those arrays isnt empty. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] confused big time

2004-04-06 Thread Andy B
"MINE: $sql = " SELECT name , age , height , etc FROM user WHERE name = '$name' AND height = '5'";" um...im not doing selects im doing inserts with variable names... i understand the idea with

[PHP] confused big time

2004-04-06 Thread Andy B
"two things i would recommend before disecting your code. 1. write readable queries. GOOD: $sql = " SELECT name , age , height , etc FROM user WHERE name = '$name' AND height = '5'"; 2. alway

[PHP] confused big time

2004-04-06 Thread Andy B
hi... i have 2 mysql queries first one: //the extra { at the beginning and the extra , at the end of //each variable should be an '... "insert into $EventsTable values(NULL, '{$_SESSION[add][type]}', '{$_SESSION[add][start_date]}', '{$_SESSION[add][end_date]}', '{$_SESSION[add][name]}', '{$

[PHP] notice:use of undefined constant: add-assumed 'add' in..........

2004-04-06 Thread Andy B
i have something like this: if(!empty($_SESSION['add']['start_date']) && !empty($_SESSION['add']['end_date'])..)){ and i get the unexpected error: notice:use of undefined constant: add-assumed 'add' in (filename). dont quite understand why that is since i used other code that i have

[PHP] [fixed][PHP] function CreateDate i made doesnt work?

2004-04-06 Thread Andy B
"date() expects a UNIX timestamp. MMDDHHMMSS is NOT a UNIX timestamp. So, instead of converting the UNIX timestamp to MMDDHHMMSS in your function, why not leave it a UNIX timestamp? Then you can send it through date() whenever you want it formatted. " yea...it works now...hmmm... dont know

[PHP] function CreateDate i made doesnt work?

2004-04-06 Thread Andy B
> > Replace the above two lines with > > $time = date('YmdHis', mktime(0,0,0,$month,$day,$year); > ok the function works now because when i echo the output of $_SESSION['add']['start_date'] it shows the right 14 digit timestamp for the date i wanted to create... now the problem is getting it to ec

[PHP] function CreateDate i made doesnt work?

2004-04-06 Thread Andy B
i have the function i made: function CreateDate($day, $month, $year) { if(!empty($day) && !empty($month) && !empty($year)){ //convert $day, $month, and $year into a valid timestamp $time= strtotime($day, mktime(0,0,0,$month,1,$year)); $time=date("YmdHis", $time); return $time; } else { return false

[PHP] assigning NULL to a variable

2004-04-05 Thread Andy B
how would you assign NULL to a variable if its original value is ""? otherwise leave it with its value... the form im working on has a date field called "date" on the form itself. that "date" will get turned into $_SESSION[add][date] on the next page... i want it so if the person filling out the

[PHP] [solved][PHP] mysql_query problem with multi dim arrays

2004-04-05 Thread Andy B
> $sql = "INSERT INTO x VALUES ({$_SESSION['add']['name']} "; > > oh, and unless add & name are actually constants you should always wrap > them in single quotes. (php will covert the non-exstent constant into a > string a issue an E_NOTICE + its overhead) well that got me on the right track..

[PHP] mysql_query problem with multi dim arrays

2004-04-05 Thread Andy B
hi... i cant cut and paste my exact mysql query because it takes the '' stuff out doubles the $'s and the ,'s in the whole thing (dont know why but anyways...)... i have a query that goes something like this: mysql_query("insert into $GuestbookTable values(NULL, '$_SESSION[add][date]', '$_SESSIO

[PHP] mktime error

2004-04-05 Thread Andy B
if you need to turn the result of mktime() into a valid mysql timestamp format then put these 2 lines in your code when needed: http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] mktime error

2004-04-05 Thread Andy B
"On my personal machine the return value is: 1081026000" interesting... i got 1081054800 from mine with the code: even on cli it gives the same thing -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: $HTTP_SESSION_VARS still holds original values even after unset?

2004-04-04 Thread Andy B
"There are two problems there. First, your session data is not getting cleared. Second, it is not getting reset with the new values. For the former, in guestbook_save.php you can simply do a session_unset (if you really want to clear all of them). However this does not handle an abnormals equen

[PHP] Re: $HTTP_SESSION_VARS still holds original values even after unset?

2004-04-04 Thread Andy B
"Okay, start showing some code so we can see wtf is going on. Constantly posting back "nope", "doesn't work" is just going to have us grasping at straws again and again. Is register globals on or off? " register_globals=off here is the code that gives me problems: files are attached (if allowed)

[PHP] [solved][PHP] php as default "value" in html

2004-04-04 Thread Andy B
"When someone pulls up a form and fills it out, they subsequently submit that form. When submitting a form your browser creates a one on one connection with the server where the server inputs the data from your form before or after the next person without mixing the two. (no matter if the two sub

[PHP] Re: $HTTP_SESSION_VARS still holds original values even after unset?

2004-04-04 Thread Andy B
"Use the session_* functions then.." still does nothing at all or it does the same as session_destroy. and that forces a user back to the login screen right in the middle of an sql insert/update -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub

[PHP] Re: $HTTP_SESSION_VARS still holds original values even after unset?

2004-04-04 Thread Andy B
"Umm.. Use $_SESSION for that.." wish i could but it wont work for the server that its going to run onthey still use php4.0.4pl1 believe it or not -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] $HTTP_SESSION_VARS still holds original values even after unset?

2004-04-04 Thread Andy B
"$HTTP_SESSION_VARS = array();" doesnt work... it kills the session and forces me to login as soon as the array is empty -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] $HTTP_SESSION_VARS still holds original values even after unset?

2004-04-04 Thread Andy B
how would you empty all the contents of $HTTP_SESSION_VARS when you dont need them anymore but still keep the current session running? the problem seems to be that when i try to fill them with something else (dont need the original values anymore) but need new ones without destroying the session

[PHP] php as default "value" in html

2004-04-04 Thread Andy B
> > is there any way to keep multiple users using the same form from mixing up > > variables >>I have no idea what you mean here. if user #1 logs in and starts using a form and then user #2 logs in and starts using the same one as user #1, say by chance they submit it at the same time... is there

  1   2   >