Re: [PHP] Batch/Prepared statements for Mysql in PHP

2004-05-01 Thread Curt Zirzow
* Thus wrote electroteque ([EMAIL PROTECTED]): > I was wondering if there is any current API for creating match/prepare > statements, therefore say i have a script to insert, update and insert in > the same post, is there a way to reduce to many queries to the database to > do it all in one hit ? A

Re: [PHP] Re: creating a mailing list

2004-05-01 Thread Curt Zirzow
* Thus wrote Manuel Lemos ([EMAIL PROTECTED]): > Hello, > > On 04/29/2004 06:44 AM, Chris O'Shea wrote: > > >Does anybody know the best way of doing a mass mail through php? > > mail() function is just fine in most cases. imo, php should refuse mass mailing ;) > > >Also, do you know how php m

[PHP] Re: Installing sendmail in win9X/Me

2004-05-01 Thread Manuel Lemos
Hello, On 04/30/2004 02:05 PM, Helmut Kemper wrote: I need install sendmail in windows 9X/Me for use mail() command. PHP work only in localhost which active site server (similar to apache) and send mail by proxy network. PHP never uses sendmail under Windows. Sendmail support is only available

[PHP] Re: creating a mailing list

2004-05-01 Thread Manuel Lemos
Hello, On 04/29/2004 06:44 AM, Chris O'Shea wrote: I have a list of email addresses in mySQL from people who have signed up on my site and I want to use PHP to email out to the list. My initial thought was to go through the loop, sending an email to each person, but then I saw this somewhere: "It

Re: [PHP] Select from 24 tables

2004-05-01 Thread Curt Zirzow
* Thus wrote Travis Low ([EMAIL PROTECTED]): > Hi Michal, > > Getting back to the original posting, I'm basically saying that I don't > think it's a good idea to structure or restructure a database for the sake > of simplifying a few SQL statements. Especially if the data being joined > is in

Re: [PHP] Select from 24 tables

2004-05-01 Thread Travis Low
Hi Michal, Getting back to the original posting, I'm basically saying that I don't think it's a good idea to structure or restructure a database for the sake of simplifying a few SQL statements. Especially if the data being joined is in separate tables for a good reason. Regarding optimizing

Re: [PHP] Php & MySql selection question

2004-05-01 Thread Curt Zirzow
* Thus wrote Dave Carrera ([EMAIL PROTECTED]): > Hi List, > > I am trying to make a search box for my site and I ask the list how can I > search 24 tables to find a search string posted by a form. oohh.. ouch ;) > > I get Column: 'listing' in where clause is ambiguous when I run > > $sql = my

Re: [PHP] Select from 24 tables

2004-05-01 Thread Michal Migurski
> Up what creek? You didn't really provide any technical justification > for your suggestion. Up the creek of having to call for help on php-general because you have 24 identical tables you need to join, having never performed a join before. > The "pain" only occurs when writing the SQL statemen

Re: [PHP] php user management functionality

2004-05-01 Thread Travis Low
I wrote a job-tracking/workflow management application called Willow Job Tracker. You can download a copy of the free GPL version from here: http://dawnstar.com/index.php?display=ProductDetails&id=780 And there's a demo here: http://dawnstar.com/wjtf/ Login to the demo using admin/admin.

Re: [PHP] reversing an IF statement

2004-05-01 Thread Curt Zirzow
* Thus wrote Kim Steinhaug ([EMAIL PROTECTED]): > Often I end up using a "dumb" IF statement which to me seems that > it could have been done some other way. > > Example : > if( > ($_GET["id"]==1) or > ($_GET["mode"]=="home") or > ((!isset($_GET["item"])) && ($_GET["mode"]=="news")) F

Re: [PHP] Select from 24 tables

2004-05-01 Thread Travis Low
Michal Migurski wrote: In my experience, it's usually a safe assumption that if you have a bunch of tables all structured identically and used in similar ways, you should probably merge them all into a single table with an extra column that corresponds to whatever differentiating characteristic use

[PHP] php user management functionality

2004-05-01 Thread bruce
hey doing some basic research... has anyone found a seriously good user management script (preferably free) that can be incorporated within a web application. i'm looking for something that allows for the following functions: - user registration/login - admin function - group/team definiti

Re: [PHP] Re: Sorting text with multibyte characters

2004-05-01 Thread Michal Migurski
> Run into this before, PHP seams to do quite well when you set the locale > right ( de_DE ) which will place AÄBCD instead of ABCDÄÖÜ. > > Hope this helps :-) Thanks, I hadn't thought of that. - michal migurski- contact

Re: [PHP] Select from 24 tables

2004-05-01 Thread Michal Migurski
> This isn't always desirable, or even possible. I once designed a > database to hold characteristics for a series of 70 different tests. > There were about 50 different characteristics used in various > combinations for each test. Each characteristic could be one of many > values. So the charac

[PHP] Re: Select from 24 tables

2004-05-01 Thread Richard A. DeVenezia
Dave Carrera wrote: > Hi List, > > How do I select data from 24 table in my database. > > Each one is identical in structure layout being > > Id,name,list > > I want to select where like $_POST[var] from a form all of the tables > but I am having trouble :( > > I thought making a var string like >

[PHP] Re: Sorting text with multibyte characters

2004-05-01 Thread Red Wingate
Run into this before, PHP seams to do quite well when you set the locale right ( de_DE ) which will place AÄBCD instead of ABCDÄÖÜ. Hope this helps :-) -- red Michal Migurski wrote: Hi, Does anyone have any thoughts on how to effectively sort text with multi byte characters? I am worki

Re: [PHP] - Delete records in an Access DB

2004-05-01 Thread Torsten Roehr
So the problem is not the delete statement but that you cannot even open a connection, right? Have you tried PHP's ODBC functions to connect to the Access DB?: http://de.php.net/manual/en/function.odbc-connect.php There are some user comments regarding Access - maybe this helps. Regards, Torsten

[PHP] - Delete records in an Access DB

2004-05-01 Thread francesco
Hi all, I have this problem: I want to delete records in an Access DB. I use this code: $query="DELETE FROM Test_Table WHERE name='franco';"; // the connection parameters $path="d:/inetpub/webs/my_site/mdb-database/" ; $db_name="test.mdb" ; $dsource=$path.$db_name ; $cn_string="Provider=Micr

[PHP] Sorting text with multibyte characters

2004-05-01 Thread Michal Migurski
Hi, Does anyone have any thoughts on how to effectively sort text with multi byte characters? I am working on a project that uses lots of German text, and the letters with umlauts don't sort correctly. I'm using the mb_* functions in a few places (to adapt an ASCII-encoded database to XML output f

php-general Digest 1 May 2004 22:23:15 -0000 Issue 2738

2004-05-01 Thread php-general-digest-help
php-general Digest 1 May 2004 22:23:15 - Issue 2738 Topics (messages 185091 through 185110): reversing an IF statement 185091 by: Kim Steinhaug 185092 by: Torsten Roehr 185093 by: Anguz 185101 by: Chris Re: Separating spaces from the rest 185094 by: A

Re: [PHP] Select from 24 tables

2004-05-01 Thread Travis Low
This isn't always desirable, or even possible. I once designed a database to hold characteristics for a series of 70 different tests. There were about 50 different characteristics used in various combinations for each test. Each characteristic could be one of many values. So the characterist

Re: [PHP] Select from 24 tables

2004-05-01 Thread John Nichel
John W. Holmes wrote: Dave Carrera wrote: Hi List, How do I select data from 24 table in my database. Each one is identical in structure layout being Id,name,list The first thing you need to do is reorganize your database schema and put all of this into one table. You can see what a pain it

Re: [PHP] Select from 24 tables

2004-05-01 Thread John W. Holmes
Dave Carrera wrote: Hi List, How do I select data from 24 table in my database. Each one is identical in structure layout being Id,name,list The first thing you need to do is reorganize your database schema and put all of this into one table. You can see what a pain it is having 24 similar ta

Re: [PHP] Select from 24 tables

2004-05-01 Thread John Nichel
Dave Carrera wrote: Hi List, How do I select data from 24 table in my database. Each one is identical in structure layout being Id,name,list I want to select where like $_POST[var] from a form all of the tables but I am having trouble :( I thought making a var string like $string = "table1,ta

[PHP] Re: Select from 24 tables

2004-05-01 Thread Red Wingate
First, this is a MySQL Question, next time you better send your request to a list which covers your type of question. use tablename.fieldname in your WHERE clause if you have fields with the same name. -- red Dave Carrera wrote: Hi List, How do I select data from 24 table in my database. Each o

[PHP] Select from 24 tables

2004-05-01 Thread Dave Carrera
Hi List, How do I select data from 24 table in my database. Each one is identical in structure layout being Id,name,list I want to select where like $_POST[var] from a form all of the tables but I am having trouble :( I thought making a var string like $string = "table1,table2,table3,.";

[PHP] XSLT_SABOPT_DISABLE_ADDING_META option

2004-05-01 Thread Fabrice Dufour
hello, how can i turn |the following sablotron option XSLT_SABOPT_DISABLE_ADDING_META to true ? Regards, Fabrice | -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] XSLT_SABOPT_DISABLE_ADDING_META option

2004-05-01 Thread Fabrice Dufour
hello, how can i set |XSLT_SABOPT_DISABLE_ADDING_META option to true ? Fabrice | -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Re: https & sessions failing to persist

2004-05-01 Thread Michael R. Wayne
On Fri, Apr 30, 2004 at 10:01:40PM -0500, Luis Bernardo wrote: > > Apache or IIS? CGI or ISAPI module? FreeBSD4.8 apache+mod_ssl-1.3.29+2.8.16_1 CGI > "Michael R. Wayne" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > > > Upgraded our PHP installation from 4.1.2 to 4.3.4, scri

RE: [PHP] reversing an IF statement

2004-05-01 Thread Chris
The easiest method is just to encase all the checks in parenthese, then negate it: if(!( ($_GET["id"]==1) or ($_GET["mode"]=="home") or ((!isset($_GET["item"])) && ($_GET["mode"]=="news")) )) { // This is where we do it } -Original Message- From: Kim Steinhaug [mailt

[PHP] Php & MySql selection question

2004-05-01 Thread Dave Carrera
Hi List, I am trying to make a search box for my site and I ask the list how can I search 24 tables to find a search string posted by a form. I get Column: 'listing' in where clause is ambiguous when I run $sql = mysql_query("select * from $tbs where listing like \"$_POST[tglstring]\"") or die(

[PHP] Re: https & sessions failing to persist

2004-05-01 Thread Luis Bernardo
Apache or IIS? CGI or ISAPI module? "Michael R. Wayne" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Upgraded our PHP installation from 4.1.2 to 4.3.4, scripts that > worked fine before are no longer doing so. The failure can be > traced to the fact that sessions are never bein

RE: [PHP] Script never returns from funktion.

2004-05-01 Thread Lars . Pedersen
Hi Wolf Thanks for the try. but sorry to say that the script stil hangs in the auth3.php script. Med venlig hilsen - Best Regards Lars Pedersen Notes Administrator

RE: [PHP] Strip_tags issue / question

2004-05-01 Thread Dave Carrera
Thanks David, That sorted that out nicely :-) I hope that helps someone else on the list. Dave C -Original Message- From: David Risner [mailto:[EMAIL PROTECTED] Sent: 01 May 2004 14:36 To: Dave Carrera Subject: Re: [PHP] Strip_tags issue / question How about something like: $cleanStr

[PHP] PHP Conference in Amsterdam

2004-05-01 Thread Filip de Waard
Hey, Next week I will be attending the International PHP Conference in Amsterdam and since I don't know anybody who will attend I thought it would be nice to get some contacts before I go. I'm sure there are some people on this list who will be going to the conference, so I thought this might

[PHP] Strip_tags issue / question

2004-05-01 Thread Dave Carrera
Hi List, I am using stip_tags to return to me just the words contained in a page from my website but what is displayed is some thing like this : --- Output Example --- hello world Why so much space ? --- End - So whe

Re: [PHP] Re: Separating spaces from the rest

2004-05-01 Thread Anguz
Curt Zirzow wrote: You forgot the pattern deliminator: print_r(preg_split('/(\s+)/', " word1 word2 word3.", -1, PREG_SPLIT_DELIM_CAPTURE)); Curt You're right, that fixed the space capturing. Justin Patrin wrote: > ...I wonder why you're doing this, but here's an answer for you. > > BTW, if

[PHP] Re: reversing an IF statement

2004-05-01 Thread Anguz
Kim Steinhaug wrote: Often I end up using a "dumb" IF statement which to me seems that it could have been done some other way. Example : if( ($_GET["id"]==1) or ($_GET["mode"]=="home") or ((!isset($_GET["item"])) && ($_GET["mode"]=="news")) ) { // Here we do nothing } else {

[PHP] Re: reversing an IF statement

2004-05-01 Thread Torsten Roehr
"Kim Steinhaug" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Often I end up using a "dumb" IF statement which to me seems that > it could have been done some other way. > > Example : > if( > ($_GET["id"]==1) or > ($_GET["mode"]=="home") or > ((!isset($_GET["item"])) &&

[PHP] reversing an IF statement

2004-05-01 Thread Kim Steinhaug
Often I end up using a "dumb" IF statement which to me seems that it could have been done some other way. Example : if( ($_GET["id"]==1) or ($_GET["mode"]=="home") or ((!isset($_GET["item"])) && ($_GET["mode"]=="news")) ) { // Here we do nothing } else { // This is where

php-general Digest 1 May 2004 10:14:04 -0000 Issue 2737

2004-05-01 Thread php-general-digest-help
php-general Digest 1 May 2004 10:14:04 - Issue 2737 Topics (messages 185076 through 185090): Re: https & sessions failing to persist 185076 by: Michael R. Wayne 185077 by: Curt Zirzow initializing HTML form using PHP 185078 by: Denis Kertz 185079 by: Daniel C

RE: [PHP] Script never returns from funktion.

2004-05-01 Thread PHP Email List
> Subject: [PHP] Script never returns from funktion. > Hi , i am having problems with a funktion call never returns from the > funktion. Now I'm still new to PHP so bare with me if this is wrong. But don't you have to assign the "authenticate()" function to something as your returning the $user

[PHP] Re: @session_start()?

2004-05-01 Thread Torsten Roehr
"Brandon Goodin" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I noticed this notation in one of the PEAR packages @session_start()? What > is the purpose of the '@' sign? It suppresses/ignores any error output for this function. Regards, Torsten > > > > Thanks > > Brandon > > -

[PHP] Script never returns from funktion.

2004-05-01 Thread Lars . Pedersen
Hi , i am having problems with a funktion call never returns from the funktion. The script is started from ldaptest.php with call the funktion authenticate(). when inserting the real name and password the script stop's at the end and dont return to ldaptest.php system info: linux Suse 9.0 p