php-general Digest 4 Feb 2009 07:58:51 -0000 Issue 5939

2009-02-04 Thread php-general-digest-help
php-general Digest 4 Feb 2009 07:58:51 - Issue 5939 Topics (messages 287566 through 287594): Throwing an exception seems to defeat output buffering 287566 by: Wickland, Leif 287568 by: Stuart 287573 by: Shawn McKenzie 287579 by: Alpár Török Re: calculate

Re: [PHP] Is it possible to send POST vars through a header redirect?

2009-02-04 Thread Stuart
2009/2/3 TS sunnrun...@gmail.com: I'm trying to send vars via POST somehow. Is this possible? Currently I'm doing header(Location: http://domain/index.php?var=3;); but, want to send POST or some other method that doesn't stick with the session. I'm not sure what you mean by stick with

[PHP] why does a html mail send as text ?

2009-02-04 Thread Bulend Kolay
I use php-5.2.6 and apache2.2.x on opensuse11 I have a file called mailsend.php to send a mail of html format. the server sends the mail form of html format. But I get it as text instead of html. default_mimetype is set as text/html in php.ini file. How can I correct this ? -- PHP

Re: [PHP] Is it possible to send POST vars through a header redirect?

2009-02-04 Thread Stuart
2009/2/4 Jônatas Zechim zechim@gmail.com: Try curl 1) I really wish people would look at other replies to a post before sending their own. Duplicates are rarely useful. 2) CURL cannot perform a header redirect as the OP is asking for, so the more useful response is to ask what they're

Re: [PHP] How can I do the opposite of property_exists(), maybe a create_property() in PHP5?

2009-02-04 Thread Stuart
2009/2/3 Daevid Vincent dae...@daevid.com: On Wed, 2009-02-04 at 08:58 +1100, Chris wrote: the question is what is __set() doing, if it's throwing an exception for undefined properties then obviously it with 'blow up'. But why should __set() even be called if I'm accessing the

Re: [PHP] why does a html mail send as text ?

2009-02-04 Thread Phpster
Show your code, but it sounds like maybe the HTML flag is not set. Consider using a class like phpmailer or the mime mail class from phpclasses.org Bastien Sent from my iPod On Feb 4, 2009, at 6:28, Bulend Kolay bma...@ihlas.net.tr wrote: I use php-5.2.6 and apache2.2.x on opensuse11 I

Re: [PHP] calculate the time that day ends

2009-02-04 Thread Shawn McKenzie
Lupus Michaelis wrote: Shawn McKenzie a écrit : STFW That's not so fair. If Thodoris ask about day end, it is obvious he's wrong with the word. Wrong because he isn't mastering english. So, without the good word (sunset), he can't find. So please don't bash us when we appear silly !

Re: [PHP] why does a html mail send as text ?

2009-02-04 Thread Bulend Kolay
I attached my code Thanks Show your code, but it sounds like maybe the HTML flag is not set. Consider using a class like phpmailer or the mime mail class from phpclasses.org Bastien Sent from my iPod On Feb 4, 2009, at 6:28, Bulend Kolay bma...@ihlas.net.tr wrote: I use php-5.2.6

[PHP] php rpm

2009-02-04 Thread admin
Okay here is my question. Does anyone know of an RPM of php that is pre-compiled with all the extras like soap, mssql, freetds, etc... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Is it possible to send POST vars through a header redirect?

2009-02-04 Thread Mike Roberts
Ladies and Gentlemen. I am a recruiter who joined this list to understand a little about PHP. I respected the boundaries, and never tried to recruit you. Now I am asking for a courtesy in return. I have tried several ways and several times to be excluded from the list, but I still get emails.

Re: [PHP] why does a html mail send as text ?

2009-02-04 Thread Bastien Koert
2009/2/4 Bulend Kolay bma...@ihlas.net.tr I attached my code Thanks Show your code, but it sounds like maybe the HTML flag is not set. Consider using a class like phpmailer or the mime mail class from phpclasses.org Bastien Sent from my iPod On Feb 4, 2009, at 6:28, Bulend Kolay

RE: [PHP] Is it possible to send POST vars through a header redirect?

2009-02-04 Thread tedd
At 9:47 AM -0500 2/4/09, Mike Roberts wrote: Ladies and Gentlemen. I am a recruiter who joined this list to understand a little about PHP. I respected the boundaries, and never tried to recruit you. Now I am asking for a courtesy in return. I have tried several ways and several times to be

Re: [PHP] calculate the time that day ends

2009-02-04 Thread tedd
At 8:59 AM +0100 2/4/09, Lupus Michaelis wrote: Shawn McKenzie a écrit : STFW That's not so fair. If Thodoris ask about day end, it is obvious he's wrong with the word. Wrong because he isn't mastering english. So, without the good word (sunset), he can't find. So please don't bash us

Re: [PHP] php rpm

2009-02-04 Thread Yannick Mortier
Can you tell us what distribution you have? Some distributions already deliver PHP rpms and you just have to install additional modules. Mostly they are called php(4|5)-(extensionname). For example php5-mssql or php4-bc. Try to look into your package manager or tell us what distro you have so I

RES: [PHP] Mutiple SQL request

2009-02-04 Thread Jônatas Zechim
For example i’ve this query: SELECT admin_nome FROM ctalk_admin WHERE admin_lastping = '1233762658' AND admin_lastping = '1233762608' AND admin_id='1' I ran explain, the result for extra is ‘Impossible WHERE noticed after reading const table...’ How can i optimize this query? Is there

Re: [PHP] why does a html mail send as text ?

2009-02-04 Thread Bulend Kolay
Ok it works. it comes as html, But it comes with servername at From part. That's to say, I get the mail no-re...@sitename.com@full.servername.com How can I conceal the servername at the From part ? Thanks 2009/2/4 Bulend Kolay bma...@ihlas.net.tr I attached my code Thanks Show

[PHP] Re: Mutiple SQL request

2009-02-04 Thread Carlos Medina
Jônatas Zechim schrieb: Hi there, i've a system that do a query each 3s, does it impact on mysql Server? I mean, can this slow my Server? zechim No. and yes. I think if you are doing a Join Query over 32 Tables without indexes then it will be very slow Carlos -- PHP General Mailing List

RES: [PHP] Is it possible to send POST vars through a header redirect?

2009-02-04 Thread Jônatas Zechim
Try curl -Mensagem original- De: Stuart [mailto:stut...@gmail.com] Enviada em: quarta-feira, 4 de fevereiro de 2009 07:52 Para: TS Cc: php-general@lists.php.net Assunto: Re: [PHP] Is it possible to send POST vars through a header redirect? 2009/2/3 TS sunnrun...@gmail.com: I'm trying

Re: RES: [PHP] Mutiple SQL request

2009-02-04 Thread Jim Lucas
Jônatas Zechim wrote: For example i’ve this query: SELECT admin_nome FROM ctalk_admin WHERE admin_lastping = '1233762658' AND admin_lastping = '1233762608' AND admin_id='1' I ran explain, the result for extra is ‘Impossible WHERE noticed after reading const table...’ How can

Re: [PHP] Mutiple SQL request

2009-02-04 Thread Bastien Koert
On Wed, Feb 4, 2009 at 9:43 AM, Jônatas Zechim zechim@gmail.com wrote: Hi there, i've a system that do a query each 3s, does it impact on mysql Server? I mean, can this slow my Server? zechim -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP] Mutiple SQL request

2009-02-04 Thread Jônatas Zechim
Hi there, i've a system that do a query each 3s, does it impact on mysql Server? I mean, can this slow my Server? zechim -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] why does a html mail send as text ?

2009-02-04 Thread Bulend Kolay
Thanks to Bastien I think, I wrote wrong the expression I have entered the string again as below $headers .= From: \Site Admin\ no-re...@sitename.com\n; the mail comes as html and also server name at from part doesn't appear. Ok it works. it comes as html, But it comes with servername at

Re: [PHP] Mutiple SQL request

2009-02-04 Thread Bastien Koert
On Wed, Feb 4, 2009 at 10:54 AM, Jônatas Zechim zechim@gmail.comwrote: For example i've this query: *SELECT admin_nome FROM ctalk_admin WHERE admin_lastping = '1233762658' AND admin_lastping = '1233762608' AND admin_id='1'* I ran explain, the result for extra is 'Impossible WHERE

Re: [PHP] why does a html mail send as text ?

2009-02-04 Thread Stuart
2009/2/4 Bulend Kolay bma...@ihlas.net.tr: I use php-5.2.6 and apache2.2.x on opensuse11 I have a file called mailsend.php to send a mail of html format. the server sends the mail form of html format. But I get it as text instead of html. default_mimetype is set as text/html in php.ini file.

Re: [PHP] Mutiple SQL request

2009-02-04 Thread Per Jessen
Jônatas Zechim wrote: Hi there, i've a system that do a query each 3s, does it impact on mysql Server? I mean, can this slow my Server? Probably not - if the query and the database doesn't change in between, the results are cached. /Per Jessen, Zürich -- PHP General Mailing List

RES: [PHP] Mutiple SQL request

2009-02-04 Thread Jônatas Zechim
Can you dump the table structure to show us how you've set it up? Bastien Cat, the other other white meat Yeah, that’s it: CREATE TABLE `ctalk_admin` ( `admin_id` int(9) NOT NULL auto_increment, `admin_nome` varchar(50) NOT NULL, `admin_login_nome` varchar(32) NOT NULL,

Re: [PHP] Is it possible to send POST vars through a header redirect?

2009-02-04 Thread Morris
Not possible to send POST in header if your aim is to hide vars from users. Could think about dynamically send POST using Javascript. form.send(); This requires some JS knowledge about how to exchange data between PHP and JS 2009/2/4 tedd tedd.sperl...@gmail.com At 9:47 AM -0500 2/4/09, Mike

RES: [PHP] Is it possible to send POST vars through a header redirect?

2009-02-04 Thread Jônatas Zechim
U can do it by using a session, or using a XML request via JS to save the vars. -Mensagem original- De: Morris [mailto:morris...@gmail.com] Enviada em: quarta-feira, 4 de fevereiro de 2009 16:00 Para: tedd Cc: Mike Roberts; php-general@lists.php.net Assunto: Re: [PHP] Is it possible to

Re: RES: [PHP] Mutiple SQL request

2009-02-04 Thread Jim Lucas
Jônatas Zechim wrote: Can you dump the table structure to show us how you've set it up? Bastien Cat, the other other white meat Yeah, that’s it: CREATE TABLE `ctalk_admin` ( `admin_id` int(9) NOT NULL auto_increment, `admin_nome` varchar(50) NOT NULL,

RES: RES: [PHP] Mutiple SQL request

2009-02-04 Thread Jônatas Zechim
Thank i'll try these to see the perfomance.. Thanks Zechim -Mensagem original- De: Jim Lucas [mailto:li...@cmsws.com] Enviada em: quarta-feira, 4 de fevereiro de 2009 16:11 Para: Jônatas Zechim Cc: 'Bastien Koert'; php-general@lists.php.net Assunto: Re: RES: [PHP] Mutiple SQL request

Re: [PHP] Is it possible to send POST vars through a header redirect?

2009-02-04 Thread Shawn McKenzie
Stuart wrote: 2009/2/4 Jônatas Zechim zechim@gmail.com: Try curl 1) I really wish people would look at other replies to a post before sending their own. Duplicates are rarely useful. 2) CURL cannot perform a header redirect as the OP is asking for, so the more useful response is to

[PHP] is this use of subquery smart

2009-02-04 Thread Afan Pasalic
What would be more appropriate way to create a query: Solution 1: select records from registrants table SELECT r.reg_id, r.date_registered, r.old_record FROM registrants r WHERE r.org_id=12 AND r.reg_status=0 AND r.reg_id=r.person_id # php validation if($old_record != 0) { SELECT

RE: [PHP] Is it possible to send POST vars through a header redirect?

2009-02-04 Thread Ashley Sheridan
Just look at the headers of EVERY email that comes from the mailing list, as they contain the unsubscribe email address. On Wed, 2009-02-04 at 09:47 -0500, Mike Roberts wrote: Ladies and Gentlemen. I am a recruiter who joined this list to understand a little about PHP. I respected the

[PHP] Bad words [SQL, database, txt, whatever]

2009-02-04 Thread Jônatas Zechim
Hi there I don't know how to say 'palavrões'(i mean bad words, like f*** you, your bi***, as*) in English, but I need that. Anyone has or know where I can get a database, txt, whatever of 'bad words or 'palavrões'' zechim -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP] why does a html mail send as text ?

2009-02-04 Thread Ashley Sheridan
On Wed, 2009-02-04 at 18:43 +0200, Bulend Kolay wrote: Thanks to Bastien I think, I wrote wrong the expression I have entered the string again as below $headers .= From: \Site Admin\ no-re...@sitename.com\n; the mail comes as html and also server name at from part doesn't appear.

Re: [PHP] php rpm

2009-02-04 Thread Yannick Mortier
2009/2/4 ad...@buskirkgraphics.com: Wow I am so sorry did not mean to be so vague about my installation. RHEL 5.3 The distro that comes with it is 5.1.6 The bad part is the Redhat does not offer an uptodate disto of php. So i am compiling from source. I cant find much information on the

[PHP] Passing an undetermined amount of arguments by reference

2009-02-04 Thread Jay Moore
Greetings list. Say I have a function that escapes a string before being passed to MySQL like so: function escape($id, $string) { $string = mysql_real_escape_string($string, $id); } I'm passing $string as a reference so I don't have to reassign it like so: $foo = escape($id, $foo);

Re: [PHP] php rpm

2009-02-04 Thread Ashley Sheridan
On Wed, 2009-02-04 at 20:52 +0100, Yannick Mortier wrote: 2009/2/4 ad...@buskirkgraphics.com: Wow I am so sorry did not mean to be so vague about my installation. RHEL 5.3 The distro that comes with it is 5.1.6 The bad part is the Redhat does not offer an uptodate disto of php. So i am

Re: [PHP] Passing an undetermined amount of arguments by reference

2009-02-04 Thread Ashley Sheridan
On Wed, 2009-02-04 at 14:02 -0600, Jay Moore wrote: Greetings list. Say I have a function that escapes a string before being passed to MySQL like so: function escape($id, $string) { $string = mysql_real_escape_string($string, $id); } I'm passing $string as a reference so I

Re: [PHP] Passing an undetermined amount of arguments by reference

2009-02-04 Thread Jim Lucas
Jay Moore wrote: Greetings list. Say I have a function that escapes a string before being passed to MySQL like so: function escape($id, $string) { $string } Use an array as an alternate method of sending/returning data to the second argument. function escape($id, $data) {

Re: [PHP] Passing an undetermined amount of arguments by reference

2009-02-04 Thread Jay Moore
Ashley Sheridan wrote: On Wed, 2009-02-04 at 14:02 -0600, Jay Moore wrote: Greetings list. Say I have a function that escapes a string before being passed to MySQL like so: function escape($id, $string) { $string = mysql_real_escape_string($string, $id); } I'm passing $string as a

Re: [PHP] Bad words [SQL, database, txt, whatever]

2009-02-04 Thread Andrew Ballard
On Wed, Feb 4, 2009 at 2:48 PM, Jônatas Zechim zechim@gmail.com wrote: Hi there I don't know how to say 'palavrões'(i mean bad words, like f*** you, your bi***, as*) in English, but I need that. Anyone has or know where I can get a database, txt, whatever of 'bad words or 'palavrões''

Re: [PHP] Passing an undetermined amount of arguments by reference

2009-02-04 Thread Jay Moore
Jim Lucas wrote: Jay Moore wrote: Greetings list. Say I have a function that escapes a string before being passed to MySQL like so: function escape($id, $string) { $string } Use an array as an alternate method of sending/returning data to the second argument. function escape($id,

Re: [PHP] Passing an undetermined amount of arguments by reference

2009-02-04 Thread Shawn McKenzie
Jay Moore wrote: Jim Lucas wrote: Jay Moore wrote: Greetings list. Say I have a function that escapes a string before being passed to MySQL like so: function escape($id, $string) { $string } Use an array as an alternate method of sending/returning data to the second argument.

Re: [PHP] Passing an undetermined amount of arguments by reference

2009-02-04 Thread Jay Moore
Shawn McKenzie wrote: Jay Moore wrote: Jim Lucas wrote: Jay Moore wrote: Greetings list. Say I have a function that escapes a string before being passed to MySQL like so: function escape($id, $string) { $string } Use an array as an alternate method of sending/returning data to the

RES: [PHP] Bad words [SQL, database, txt, whatever]

2009-02-04 Thread Jônatas Zechim
Thank you, but i thought one of you had the .sql or .txt, .xls, etc. I had already find that results. But it's ok now.. zechim -Mensagem original- De: Andrew Ballard [mailto:aball...@gmail.com] Enviada em: quarta-feira, 4 de fevereiro de 2009 18:19 Para: Jônatas Zechim Cc: PHP-General

Re: [PHP] php rpm

2009-02-04 Thread Daniel Brown
On Wed, Feb 4, 2009 at 09:46, ad...@buskirkgraphics.com wrote: Okay here is my question. Does anyone know of an RPM of php that is pre-compiled with all the extras like soap, mssql, freetds, etc... Afternoon, Rich, et al; On an RHEL 5.3 system, you should already have 'yum'

Re: RES: [PHP] Bad words [SQL, database, txt, whatever]

2009-02-04 Thread Ashley Sheridan
On Wed, 2009-02-04 at 18:34 -0200, Jônatas Zechim wrote: Thank you, but i thought one of you had the .sql or .txt, .xls, etc. I had already find that results. But it's ok now.. zechim -Mensagem original- De: Andrew Ballard [mailto:aball...@gmail.com] Enviada em: quarta-feira,

Re: RES: [PHP] Bad words [SQL, database, txt, whatever]

2009-02-04 Thread Daevid Vincent
On Wed, 2009-02-04 at 21:10 +, Ashley Sheridan wrote: Not only that, but just replacing words can cause it's own problems. I remember a lot of early basic filters (Hotmail anyone?) that prevented words like this, and any unfortunate with a surname of Hancock was left in a right mess! I

Re: RES: [PHP] Bad words [SQL, database, txt, whatever]

2009-02-04 Thread Robert Cummings
On Wed, 2009-02-04 at 13:14 -0800, Daevid Vincent wrote: Thankfully he IM'd me about it and I fixed it for him, but if he were a real customer, I bet they would go away and never come back. I commented out the code and it's bit-rotting as we speak, as it's just too much h*BLEEP*le to try and

Re: RES: [PHP] Bad words [SQL, database, txt, whatever]

2009-02-04 Thread Ashley Sheridan
On Wed, 2009-02-04 at 16:22 -0500, Robert Cummings wrote: On Wed, 2009-02-04 at 13:14 -0800, Daevid Vincent wrote: Thankfully he IM'd me about it and I fixed it for him, but if he were a real customer, I bet they would go away and never come back. I commented out the code and it's

Re: [PHP] is this use of subquery smart

2009-02-04 Thread Chris
Solution 2: SELECT r.reg_id, r.date_registered, r.old_record, if(r.ghost_record!=0, (SELECT CONCAT(people.last_name, ', ', people.first_name) FROM people, registrants WHERE people.instance_id=12 and people.person_id=registrants.person_id AND registrants.reg_id=r.ghost_record), 'y') as

Re: RES: [PHP] Mutiple SQL request

2009-02-04 Thread Chris
Jônatas Zechim wrote: For example i’ve this query: SELECT admin_nome FROM ctalk_admin WHERE admin_lastping = '1233762658' AND admin_lastping = '1233762608' AND admin_id='1' I ran explain, the result for extra is ‘Impossible WHERE noticed after reading const table...’ Well this one is

Re: RES: [PHP] Mutiple SQL request

2009-02-04 Thread Ashley Sheridan
On Thu, 2009-02-05 at 08:38 +1100, Chris wrote: Jônatas Zechim wrote: For example i’ve this query: SELECT admin_nome FROM ctalk_admin WHERE admin_lastping = '1233762658' AND admin_lastping = '1233762608' AND admin_id='1' I ran explain, the result for extra is

Re: [PHP] is this use of subquery smart

2009-02-04 Thread Bastien Koert
On Wed, Feb 4, 2009 at 4:33 PM, Chris dmag...@gmail.com wrote: Solution 2: SELECT r.reg_id, r.date_registered, r.old_record, if(r.ghost_record!=0, (SELECT CONCAT(people.last_name, ', ', people.first_name) FROM people, registrants WHERE people.instance_id=12 and

Re: RES: [PHP] Mutiple SQL request

2009-02-04 Thread Chris
Ashley Sheridan wrote: On Thu, 2009-02-05 at 08:38 +1100, Chris wrote: Jônatas Zechim wrote: For example i’ve this query: SELECT admin_nome FROM ctalk_admin WHERE admin_lastping = '1233762658' AND admin_lastping = '1233762608' AND admin_id='1' I ran explain, the result for extra is

Re: [PHP] Passing an undetermined amount of arguments by reference

2009-02-04 Thread Jim Lucas
Jay Moore wrote: Shawn McKenzie wrote: Jay Moore wrote: Jim Lucas wrote: Jay Moore wrote: Greetings list. Say I have a function that escapes a string before being passed to MySQL like so: function escape($id, $string) { $string } Use an array as an alternate method of

Re: RES: [PHP] Mutiple SQL request

2009-02-04 Thread Ashley Sheridan
On Thu, 2009-02-05 at 08:48 +1100, Chris wrote: Ashley Sheridan wrote: On Thu, 2009-02-05 at 08:38 +1100, Chris wrote: Jônatas Zechim wrote: For example i’ve this query: SELECT admin_nome FROM ctalk_admin WHERE admin_lastping = '1233762658' AND admin_lastping = '1233762608'

Re: [PHP] php rpm

2009-02-04 Thread Thodoris Goltsios
Daniel Brown wrote: On Wed, Feb 4, 2009 at 09:46, ad...@buskirkgraphics.com wrote: Okay here is my question. Does anyone know of an RPM of php that is pre-compiled with all the extras like soap, mssql, freetds, etc... Afternoon, Rich, et al; On an RHEL 5.3 system, you

Re: [PHP] php rpm

2009-02-04 Thread Kyle Terry
On Wed, Feb 4, 2009 at 12:59 PM, Daniel Brown danbr...@php.net wrote: On Wed, Feb 4, 2009 at 09:46, ad...@buskirkgraphics.com wrote: Okay here is my question. Does anyone know of an RPM of php that is pre-compiled with all the extras like soap, mssql, freetds, etc... Afternoon, Rich, et

Re: [PHP] php rpm

2009-02-04 Thread Daniel Brown
On Wed, Feb 4, 2009 at 16:55, Thodoris Goltsios t...@kinetix.gr wrote: This probably more then one rpm :-) . You're correct. ;-P I meant to lead-off the last email by saying that there is no single official RHEL RPM that includes those modules/extensions by default. -- /Daniel P.

Re: RES: [PHP] Mutiple SQL request

2009-02-04 Thread Chris
MySQL may have noticed it was impossible with the current data he had using the index on that field, but in the future it may become valid, so I wouldn't necessary eliminate it if it's deemed crucial. A query that returns no results is equally as useful as one that returns many. I'm not

Re: [PHP] php rpm

2009-02-04 Thread Daniel Brown
On Wed, Feb 4, 2009 at 16:56, Kyle Terry k...@kyleterry.com wrote: I might be wrong, but I think the packages have the php version appended to the it. so php5-soap, for example. Some do, some don't. At least it's like that in Fedora. Depends on the RPM packager and the repo, among

Re: RES: [PHP] Mutiple SQL request

2009-02-04 Thread Micah Gersten
Jim Lucas wrote: snip I would add a second column to that admin_lastping KEY KEY `admin_lastping` (`admin_lastping`, `admin_id`) Since you are using both columns in your where clause, they both need to be specified /in the same/ index for and index to be used. Otherwise, some random

[PHP] Clarity needed

2009-02-04 Thread tedd
Hi gang: I need some fog removed. I have a problem where I have an unlimited number of tutors teaching an unlimited number of courses. When I call upon a tutor, I want to see all the courses they teach. In my old days, I would just set up a linked list of courses and attach it to the tutor

Re: [PHP] Clarity needed

2009-02-04 Thread Ashley Sheridan
On Wed, 2009-02-04 at 17:24 -0500, tedd wrote: Hi gang: I need some fog removed. I have a problem where I have an unlimited number of tutors teaching an unlimited number of courses. When I call upon a tutor, I want to see all the courses they teach. In my old days, I would just set

Re: [PHP] Clarity needed

2009-02-04 Thread Edmund Hertle
2009/2/4 tedd t...@sperling.com Hi gang: I need some fog removed. I have a problem where I have an unlimited number of tutors teaching an unlimited number of courses. When I call upon a tutor, I want to see all the courses they teach. In my old days, I would just set up a linked list of

Re: [PHP] Clarity needed

2009-02-04 Thread TG
Yup, that's how I've done it before: tutors - id tutorname courses - id coursename xref_tutors_courses tutor_id course_id But I've been known to do things goofy before. I'm curious to see how other people handle it. -TG -

[PHP] Speed Opinion

2009-02-04 Thread PHP
Hi all, I am seeking some knowledge, hopefully I explain this right. I am wondering what you think is faster. Say you have 1000 records from 2 different tables that you need to get from a MySQL database. A simple table will be displayed for each record, the second table contains related info

[PHP] Re: Clarity needed

2009-02-04 Thread Shawn McKenzie
tedd wrote: Hi gang: I need some fog removed. I have a problem where I have an unlimited number of tutors teaching an unlimited number of courses. When I call upon a tutor, I want to see all the courses they teach. In my old days, I would just set up a linked list of courses and attach

Re: [PHP] Clarity needed

2009-02-04 Thread Daniel Brown
On Wed, Feb 4, 2009 at 17:24, tedd t...@sperling.com wrote: [snip!] I understand that I can have one record set up for each tutor, and another record set up for each course, and then tie the two together by another record like an assignment. That way I can have as many assignments as I want

Re: [PHP] Speed Opinion

2009-02-04 Thread Chris
PHP wrote: Hi all, I am seeking some knowledge, hopefully I explain this right. I am wondering what you think is faster. Say you have 1000 records from 2 different tables that you need to get from a MySQL database. A simple table will be displayed for each record, the second table contains

Re: [PHP] Speed Opinion

2009-02-04 Thread Afan Pasalic
PHP wrote: Hi all, I am seeking some knowledge, hopefully I explain this right. I am wondering what you think is faster. Say you have 1000 records from 2 different tables that you need to get from a MySQL database. A simple table will be displayed for each record, the second table contains

Re: [PHP] Speed Opinion

2009-02-04 Thread Robert Cummings
On Wed, 2009-02-04 at 14:42 -0800, PHP wrote: Hi all, I am seeking some knowledge, hopefully I explain this right. I am wondering what you think is faster. Say you have 1000 records from 2 different tables that you need to get from a MySQL database. A simple table will be displayed for

Re: [PHP] Passing an undetermined amount of arguments by reference

2009-02-04 Thread Shawn McKenzie
Jim Lucas wrote: Jay Moore wrote: Shawn McKenzie wrote: Jay Moore wrote: Jim Lucas wrote: Jay Moore wrote: Greetings list. Say I have a function that escapes a string before being passed to MySQL like so: function escape($id, $string) { $string } Use an array as an alternate

Re: [PHP] [PROJECT HELP] - JotBug - A Project Management Issue Tracker written 100% with Zend Framework

2009-02-04 Thread rcastley
Hi, I forget to mention that you can log into the site using any username (no password is required). This is just dummy/test authentication mechanism whilst I finished off support for LDAP and OpenID. rcastley wrote: Hi, I now have a demo site available so you can easily monitor the

Re: [PHP] Speed Opinion

2009-02-04 Thread Ashley Sheridan
On Thu, 2009-02-05 at 09:44 +1100, Chris wrote: PHP wrote: Hi all, I am seeking some knowledge, hopefully I explain this right. I am wondering what you think is faster. Say you have 1000 records from 2 different tables that you need to get from a MySQL database. A simple table

Re: [PHP] Clarity needed

2009-02-04 Thread Phpster
Yep, 3 tables is the way to go! One for tutors, one for courses and one to join them Bastien Sent from my iPod On Feb 4, 2009, at 17:24, tedd t...@sperling.com wrote: Hi gang: I need some fog removed. I have a problem where I have an unlimited number of tutors teaching an unlimited

Re: [PHP] is this use of subquery smart

2009-02-04 Thread Chris
Bastien Koert wrote: On Wed, Feb 4, 2009 at 4:33 PM, Chris dmag...@gmail.com mailto:dmag...@gmail.com wrote: Solution 2: SELECT r.reg_id, r.date_registered, r.old_record, if(r.ghost_record!=0, (SELECT CONCAT(people.last_name, ', ', people.first_name) FROM

[PHP] Re: Clarity needed

2009-02-04 Thread Nathan Rixham
tedd wrote: Hi gang: I need some fog removed. I have a problem where I have an unlimited number of tutors teaching an unlimited number of courses. When I call upon a tutor, I want to see all the courses they teach. In my old days, I would just set up a linked list of courses and attach it

Re: [PHP] Speed Opinion

2009-02-04 Thread Nathan Rixham
Ashley Sheridan wrote: On Thu, 2009-02-05 at 09:44 +1100, Chris wrote: PHP wrote: Hi all, I am seeking some knowledge, hopefully I explain this right. I am wondering what you think is faster. Say you have 1000 records from 2 different tables that you need to get from a MySQL database. A

[PHP] PHP pop-up windows

2009-02-04 Thread Clancy
I'm working on a website editor, primarily for my own use. Normally it will be used on my own computer, and much of what I wish to achieve could arguably be better done in either C or JavaScript, but both of these have a similar programming syntax to PHP, but with subtle differences, and I

Re: [PHP] PHP pop-up windows

2009-02-04 Thread Chris
Clancy wrote: I'm working on a website editor, primarily for my own use. Normally it will be used on my own computer, and much of what I wish to achieve could arguably be better done in either C or JavaScript, but both of these have a similar programming syntax to PHP, but with subtle

[PHP] Re: PHP pop-up windows

2009-02-04 Thread Nathan Rixham
Clancy wrote: I'm working on a website editor, primarily for my own use. Normally it will be used on my own computer, and much of what I wish to achieve could arguably be better done in either C or JavaScript, but both of these have a similar programming syntax to PHP, but with subtle

[PHP] Reg-ex help

2009-02-04 Thread Craige Leeder
Hey guys, I'm trying to write a regular expression to match a tag for my frameworks template engine. I seem to be having some trouble. The expression should match: {:seg 'segname':} {:seg 'segname' cache:} What I have is... $fSegRegEx = #\{:seg \'[a-z0-9\-\_]{3,}\'( cache)?:\}#i; Which

Re: [PHP] PHP pop-up windows

2009-02-04 Thread Phpster
Forget using the two windows and avoid the cross window communication by using a couple of divs and Ajax. Bastien Sent from my iPod On Feb 4, 2009, at 20:22, Clancy clanc...@cybec.com.au wrote: I'm working on a website editor, primarily for my own use. Normally it will be used on my own

Re: [PHP] Reg-ex help

2009-02-04 Thread Jim Lucas
Craige Leeder wrote: Hey guys, I'm trying to write a regular expression to match a tag for my frameworks template engine. I seem to be having some trouble. The expression should match: {:seg 'segname':} {:seg 'segname' cache:} What I have is... $fSegRegEx = #\{:seg \'[a-z0-9\-\_]{3,}\'(

Re: [PHP] Re: PHP webhosting - USA - conclusion

2009-02-04 Thread Thodoris
I should have said in the beginning it's a small website and I am not looking for a dedicated server. Howewer, I decided to move to Lypha.com Thanks for all your fruitful* comments :) Martin PS: PHP mailgroup rulz *) that was in dictionary You could check ICDsoft

Re: RES: [PHP] Bad words [SQL, database, txt, whatever]

2009-02-04 Thread Alpár Török
2009/2/4 Ashley Sheridan a...@ashleysheridan.co.uk On Wed, 2009-02-04 at 16:22 -0500, Robert Cummings wrote: On Wed, 2009-02-04 at 13:14 -0800, Daevid Vincent wrote: Thankfully he IM'd me about it and I fixed it for him, but if he were a real customer, I bet they would go away and

[PHP] File Manager

2009-02-04 Thread Sn!per
What would you guys recommend as a good and free opensource file management system? TIA. -- Sign Up for free Email at http://ureg.home.net.my/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Clarity needed

2009-02-04 Thread Yannick Mortier
2009/2/4 tedd t...@sperling.com: Hi gang: I need some fog removed. I have a problem where I have an unlimited number of tutors teaching an unlimited number of courses. When I call upon a tutor, I want to see all the courses they teach. In my old days, I would just set up a linked list of