[PHP] Re: Best practices for deleting and restoring records - moving vs flagging

2005-08-12 Thread Arno Coetzee
Saqib Ali wrote: Hello All, What are best practices for deleting records in a DB. We need the ability to restore the records. Two obvious choices are: 1) Flag them deleted or undeleted 2) Move the deleted records to seperate table for deleted records. We have a complex schema. However the

[PHP] XSL namespaces and callbacks

2005-08-12 Thread Torgny Bjers
Hello, A while back I posted a question in relation to XSL namespaces and callbacks, but never got a response, not even a flame, which I found a bit odd for this list. :P I know this is pretty cutting-edge for PHP since the XSL library has only been used in PHP 5, well, except for the

Re: [PHP] Regular expression question

2005-08-12 Thread Robin Vickery
On 8/11/05, Leon Vismer [EMAIL PROTECTED] wrote: Hi Robin Many thanks for this, how would one extend this to support the following: $str = insert into userComment (userID, userName, userSurname) values (0, 'Leon', 'mcDonald'); one does not want $str = insert into user_comment

[PHP] logs problem

2005-08-12 Thread FSA
hi, i have a big php script with alot of db inserts and updates, what i want to do it's to log all this db commands into a table. I was wonderig if there is a better way to do this than the insert into logs_table the actual queryes. ty signature.asc Description: OpenPGP digital signature

Re: [PHP] logs problem

2005-08-12 Thread Torgny Bjers
FSA wrote: hi, i have a big php script with alot of db inserts and updates, what i want to do it's to log all this db commands into a table. I was wonderig if there is a better way to do this than the insert into logs_table the actual queryes. ty Depending the amount of queries and the

Re: [PHP] logs problem

2005-08-12 Thread Jochem Maas
Torgny Bjers wrote: FSA wrote: hi, i have a big php script with alot of db inserts and updates, what i want to do it's to log all this db commands into a table. I was wonderig if there is a better way to do this than the insert into logs_table the actual queryes. ty Depending the amount of

Re: [PHP] logs problem

2005-08-12 Thread FSA
this is a local script with a medium amount of data to log i just thaught it's a litle barbarian :) to actualy do inserts in the log table for all queryes. That's why i thaught maibe there is a simple more reliable way. Torgny Bjers wrote: FSA wrote: hi, i have a big php script with alot of db

RE: [PHP] logs problem

2005-08-12 Thread Jay Blanchard
[snip] hi, i have a big php script with alot of db inserts and updates, what i want to do it's to log all this db commands into a table. I was wonderig if there is a better way to do this than the insert into logs_table the actual queryes. [/snip] Don't forget, your database may be keeping logs

[PHP] getting ip of server

2005-08-12 Thread Tom Cruickshank
Hello, I'm curious to know if there is a php command that can get the IP of the server it's running on. I could always do this... $results = exec(/sbin/ifconfig ethernet device | grep broadcast | awk '{print $2}', $value); but I would prefer to not have to use system commands for this. Would

RE: [PHP] getting ip of server

2005-08-12 Thread Jay Blanchard
[snip] I'm curious to know if there is a php command that can get the IP of the server it's running on. I could always do this... $results = exec(/sbin/ifconfig ethernet device | grep broadcast | awk '{print $2}', $value); but I would prefer to not have to use system commands for this. Would

Re: [PHP] getting ip of server

2005-08-12 Thread Torgny Bjers
Tom Cruickshank wrote: Hello, I'm curious to know if there is a php command that can get the IP of the server it's running on. I could always do this... $results = exec(/sbin/ifconfig ethernet device | grep broadcast | awk '{print $2}', $value); but I would prefer to not have to use

Re: [PHP] getting ip of server

2005-08-12 Thread John Nichel
Tom Cruickshank wrote: Hello, I'm curious to know if there is a php command that can get the IP of the server it's running on. I could always do this... $results = exec(/sbin/ifconfig ethernet device | grep broadcast | awk '{print $2}', $value); but I would prefer to not have to use system

Re: [PHP] getting ip of server

2005-08-12 Thread Tom Cruickshank
Thanks for all the info guys! Apparantly I'm still not quite awake yet. Tom On 8/12/05, John Nichel [EMAIL PROTECTED] wrote: Tom Cruickshank wrote: Hello, I'm curious to know if there is a php command that can get the IP of the server it's running on. I could always do this...

Re: [PHP] PHP script for removing/forwarding suspected spam from pop3 mailbox

2005-08-12 Thread Stephen Allen
On Thu, Aug 11, 2005 at 02:39:57PM +0100 or thereabouts, I. Gray wrote: Hi. I'd like to find or write a script that I can run every so often (hourly for example) from cron that will check my pop3 mailboxes for any emails with SPAM in the subject line and either delete them or

Re: [PHP] making checkbox's and radio buttons sticky

2005-08-12 Thread Jochem Maas
Ted Passey wrote: Jochem, Thanks for your help...I can see your a great PHP programmer. flattery gets you everywhere - even if it isn't true. I'm not that bad - but lets leave the 'great' for those that really are - you know people who develop/invent the actual language - people who write

[PHP] frame help!

2005-08-12 Thread George B
I made a left frame, then made the three pages, and all the frames show fine. But this is not my problem! I made a leftpane which has code to check if user exists (its for a login script). In the code for the login FORM I set it to go directly to the userpane file. It works fine! It recognizes

Re: [PHP] PHP and Active Directory

2005-08-12 Thread cron
Some years ago i did this with ASP and a VB activex component i belive you can access a Activex from php. Angelo - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: php-general@lists.php.net Sent: Friday, August 12, 2005 2:24 AM Subject: Re: [PHP]

Re: [PHP] Best practices for deleting and restoring records - moving vs flagging

2005-08-12 Thread Jochem Maas
Saqib Ali wrote: Hello All, What are best practices for deleting records in a DB. We need the ability to restore the records. Two obvious choices are: 1) Flag them deleted or undeleted 2) Move the deleted records to seperate table for deleted records. We have a complex schema. However the

Re: [PHP] PHP and Active Directory

2005-08-12 Thread xfedex
Is this something you're looking for? http://www.phpfreaks.com/scripts/User_Authentication/16.php Thanks, if i try one, i let you now Saludos! xfedex -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] PHP and Active Directory

2005-08-12 Thread xfedex
Some years ago i did this with ASP and a VB activex component i belive you can access a Activex from php. Angelo Maybe, but i prefer to get away as much i can from Activex.just to think about it makes me shiver =P Saludos! xfedex -- PHP General Mailing List (http://www.php.net/) To

[PHP] need to convert field names into array for form submission

2005-08-12 Thread Bruce Gilbert
How would I organize this block in order to convert it into an array for my form field names. For instance if my field has: pHome Phone Number:/p input maxlength=6 size=6 name=area_code id=area_code value={$_POST['area_code']} nbsp; input maxlength=6 size=6

[PHP] Message (Your message dated Fri, 12 Aug 2005 16:07:30...)

2005-08-12 Thread Dartmouth College LISTSERV Server (14.4)
Your message dated Fri, 12 Aug 2005 16:07:30 -0400 with subject Returned mail: Data format error has been submitted to the moderator of the LLTI list: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] need to convert field names into array for form submission

2005-08-12 Thread Leif Gregory
Hello Bruce, Friday, August 12, 2005, 1:39:54 PM, you wrote: I believe this can be done with an array. any assistance is greatly appreciated! I've been working on a validation function for quite a while now that does what you're asking. I keep adding to it as I run across stuff I didn't need

[PHP] Migrating to PHP 5 - Cannot Load mySQL

2005-08-12 Thread Bagus Nugroho
Hello, I have problem 'cannot load mysql' with MySQL on PHP5( recently migrating grom PHP4 to PHP5). I was do the following actions to resolve the problem, but failed . 1. uncommented extension=php_mysql.dll 2. put php_mysql.dll on c:/php/ext 3. put libmysql.dll both on c:/winnt and

[PHP] one more mysql question

2005-08-12 Thread [EMAIL PROTECTED]
I apology for mysql question posted here, but, as I said once, I like you guys more! :) have two tables: orders and special_orders. foreign key is trans_no. I can't figure it out how to create a query that pulls orders from the orders tables that are NOT in special_orders table? Thanks for

RE: [PHP] PHP smarty - nested queries and arrays

2005-08-12 Thread Daevid Vincent
First I'll appologize for the cheuvanistic remark the other poster had. I know he had good intentions... So I don't know smarty, but it seems to me you're grabbing only one row here: $projects = $db-getAssoc() Normally in straight PHP, I would do something like. While ($row =

Re: [PHP] one more mysql question

2005-08-12 Thread Philip Hallstrom
I apology for mysql question posted here, but, as I said once, I like you guys more! :) have two tables: orders and special_orders. foreign key is trans_no. I can't figure it out how to create a query that pulls orders from the orders tables that are NOT in special_orders table? I can never

[PHP] Re: frame help!

2005-08-12 Thread George B
George B wrote: I made a left frame, then made the three pages, and all the frames show fine. But this is not my problem! I made a leftpane which has code to check if user exists (its for a login script). In the code for the login FORM I set it to go directly to the userpane file. It works

Re: [PHP] one more mysql question

2005-08-12 Thread [EMAIL PROTECTED]
I tried this one: SELECT trans_no FROM orders WHERE trans_no IN ( SELECT trans_no FROM special_orders ) but gives me an error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT trans_no FROM

[PHP] header redirect not working

2005-08-12 Thread Pablo Gosse
Hi, folks. I'm running into an incredibly bizarre problem with a header() redirect of which I cannot see the cause. We have a CMS here where I work, in two separate production and training environments. Last night I implemented a new events manager module, copying all necessary files from

Re: [PHP] one more mysql question

2005-08-12 Thread John Nichel
[EMAIL PROTECTED] wrote: I apology for mysql question posted here, but, as I said once, I like you guys more! :) I like my wife more than I like the people on these lists, but I don't go asking her my MySQL questions. I go to the MySQL list for that. What you like doesn't make your post any

Re: [PHP] one more mysql question

2005-08-12 Thread [EMAIL PROTECTED]
don't get this one: from mysql.com: SELECT s1 FROM t1 WHERE s1 NOT IN (SELECT s1 FROM t2); my query: select trans_no from orders where trans_no not in (select trans_no from special_orders); and I'm getting an error: You have an error in your SQL syntax. Check the manual that corresponds

Re: [PHP] one more mysql question

2005-08-12 Thread [EMAIL PROTECTED]
ok. accept critique. :( @moderator: please take my mysql questions off the php list. I apology to everybody for any inconviniance. -afan John Nichel wrote: [EMAIL PROTECTED] wrote: I apology for mysql question posted here, but, as I said once, I like you guys more! :) I like my wife

Re: [PHP] one more mysql question

2005-08-12 Thread Sebastian
[EMAIL PROTECTED] wrote: I tried this one: SELECT trans_no FROM orders WHERE trans_no IN ( SELECT trans_no FROM special_orders ) but gives me an error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near

Re: [PHP] one more mysql question

2005-08-12 Thread Sebastian
take what other say with a grain of salt.. im sure you're using php to pull info from mysql anyway.. the fact is without mysql php would be nowhere where it is today.. its like peanut butter w/o the jelly.. see my reply in the other email.. im sure it will work for you. [EMAIL PROTECTED]

Re: [PHP] header redirect not working

2005-08-12 Thread Jasper Bryant-Greene
Pablo Gosse wrote: [snip] $conn-Execute(delete from cms_events where e_id = {$fd['e_id']}) or $this-CMS_error(2,$this-mod_name,$query,$conn-ErrorMsg()); header(Location:{$this-CMS_base_path}mods/events_manager/cms.events_ma nager.dsp.php); [snip] Can anyone think of any reason

[PHP] ALLOW FILE UPLOADS...?

2005-08-12 Thread z a p a n
hello, sorry in advance if my question is naive.. i'm trying to allow file uploads. optimally i'd like to store these files (jpgs, mostly) directly to a folder in my httpdocs.. i've heard something about file uploads not being allowed if server is set to safemode.. not sure why but i've been

Re: [PHP] header redirect not working

2005-08-12 Thread Chris Shiflett
Pablo Gosse wrote: Can anyone think of any reason why the above code, just those two lines, would redirect correctly in one environment, yet simply redirect to the currently existing page in another? I can think of a few, and my first instinct is to check to see whether your script produces

[PHP] Help Building Dynamic Checkboxes

2005-08-12 Thread zedleon
I am having an issue with building dynamic checkboxes.. They appeared to be working properly...but then all the checkboxes in the array are checking ater the initial checkbox is selected. I am building a sticky form to present the data. so anything checked in the HTML would be dynamically checked

Re: [PHP] one more mysql question

2005-08-12 Thread John Nichel
Sebastian wrote: take what other say with a grain of salt.. im sure you're using php to pull info from mysql anyway.. And he might be using Apache on Linux like the majority of PHP users. More than likely outputting some HTML and maybe some JavaScript. Probably using a PC too. So what?

[PHP] Mail-id validation script

2005-08-12 Thread Nahalingam Kanakavel
Hai all, This is naha, I am very new to PHP as well as this group, I am in need of your guidence all my way. Now I am doing a project using PHP, in that I created a form. That form has a field called e-mailid, to validate that I need a script (function), whether I have to write it in the

Re: [PHP] Mail-id validation script

2005-08-12 Thread Jasper Bryant-Greene
Nahalingam Kanakavel wrote: Now I am doing a project using PHP, in that I created a form. That form has a field called e-mailid, to validate that I need a script (function), whether I have to write it in the server side or client side, which one is better?. I need your suggestions, If any