[PHP-DB] Re: DB400 on AS/400

2002-06-25 Thread John Lim
Hi Mike I have heard successful reports of using odbc to connect to db400. I have not personally done so. Regards, John Mike Germain [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I am trying to do a query on a database on an AS/400. The database is in DB400

[PHP-DB] A JOIN that works sometimes ?

2002-06-25 Thread Christine Clerc
Could anyone please help me with that query ? $req=SELECT * FROM tab AS C INNER JOIN inter AS A ON C.id_tab=A.id_tab WHERE A.id_cat IS NULL OR A.id_cat = 0 ORDER BY num; $result = mysql_query ($req,$db); It works on my machine but not on the server. Christine

[PHP-DB] email format: meeting request

2002-06-25 Thread Dib, Walid (MED, Stagiaire GEMS)
Hello, I have a little bit difficult question, I need to send email under format meeting request to automatically update the calendar in outlook, how can I do that with PHP and what parameters use?? Thank you Walid -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

RE: [PHP-DB] PHP in Database Fields..

2002-06-25 Thread Chris Barnes
eval() might do what your asking for. I'm no expert tho. -Original Message- From: Matthew Tedder [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 25 June 2002 7:32 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP in Database Fields.. Question: I want to put PHP code into database fields

Re: [PHP-DB] force no results

2002-06-25 Thread Martin Adler
Thans for awnsering! OK here is my Query SELECT entries.id, entries.head, entries.date, entries.author, (catgroup.gid IS NULL || catgroup.gid = *user-group-id*) AS indi FROM entries LEFT JOIN category ON entries.cat_no REGEXP CONCAT(\\.,category.id,(\\.|$)) LEFT JOIN entgroup ON entries.id =

Re: [PHP-DB] what the heck? (elementary question)

2002-06-25 Thread Martin Clifford
POST will allow larger form submits as well, like file uploads. GET are for smaller and faster data sets. -Mike Not only that, but POST results cannot be properly bookmarked by the user, whereas GET results contain the full URI string, therefore can be bookmarked. Good for searches, etc.

RE: [PHP-DB] what the heck? (elementary question)

2002-06-25 Thread Cosby, Christopher
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 7:47 PM To: Cosby, Christopher; [EMAIL PROTECTED] Subject: Re: [PHP-DB] what the heck? (elementary question) I will regularly use large echo style statements to generate HTML, especially

RE: [PHP-DB] email format: meeting request

2002-06-25 Thread Cosby, Christopher
I'll dig up some old code I have lying around that did this (may take a while to find). In the meantime, I did it like this: 1) Create an event in Outlook. 2) File - Save As... - event.ics 3) event.ics is a plain text calendar file. The dates are a pain in the @$$ (DTSTART, DTEND), but the

[PHP-DB] INNER JOIN by field content

2002-06-25 Thread Jos Moreira
for building my website i am implementing a tree-style data organization. for that i have a mysql table called 'jm_tree': CATID, int(10)auto_increment - Index PARENT, int(10) -the CATID of the 'parent' node TEXT, varchar(40)

[PHP-DB] Life's more than PHP :) Bruce Lee

2002-06-25 Thread Jos Moreira
http://www.allbrucelee.com/movies/brucelee.asf José Moreira Técnico de Informática | IT TechnicianVila Nova de Gaia, PortugalE-mail: [EMAIL PROTECTED]MSN: [EMAIL PROTECTED]ICQ: 136936120IRC: gray (irc.ptnet.org) -- PHP Database Mailing List

[PHP-DB] Form not working...

2002-06-25 Thread NIPP, SCOTT V (SBCSI)
I am working on a Call Log application for our SA group. I currently have the database back-end configured and working OK. Right now I am working with 3 pages, one is to post new entries, the second is a log view of all entries, and the last is a page that updates an existing entry. I

Re: [PHP-DB] what the heck? (elementary question)

2002-06-25 Thread szii
One large PHP block is more efficient than multiple small blocks of php. It's a tradeoff of multiple invocations of the parser versus having the parse run through (and ignore) normal text. We have run tests inhouse that validate the performance difference is fairly small, but it does exist.

Re: [PHP-DB] Re: DB400 on AS/400

2002-06-25 Thread szii
There's a long thread somewhere in the archives of PHPBuilder.com in regards to getting DB2/PHP to work on an AS/400. -Mike - Original Message - From: John Lim [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 25, 2002 12:01 AM Subject: [PHP-DB] Re: DB400 on AS/400 Hi Mike

Re: [PHP-DB] A JOIN that works sometimes ?

2002-06-25 Thread szii
Make sure you're exec'ing against the correct database with identical schema. Different MySQL versions? Schema? Permissions? var_dump() and cut'n'paste onto the server to make sure the query DOES run, then look for remote DB connection issues, permissions, database, etc. Are there multiple

Re: [PHP-DB] email format: meeting request

2002-06-25 Thread szii
You're going to have to rip open the MS-specific format and handbuild (or script) your PHP to custom-build that format with the correct data fields. While it can be done, it's a good bit of time and energy. -Mike - Original Message - From: Dib, Walid (MED, Stagiaire GEMS) [EMAIL

Re: [PHP-DB] Form not working...

2002-06-25 Thread szii
okay, couple of questions in this one... =) First... ?=$myData? is shorthand for ?php echo $myData; ? if you care. With a textarea there is no value attribute. TEXTAREA?=$myData?/TEXTAREA Your UPDATE call via sprintf() is okay for the parameter passing, but you're missing single quotes

Re: [PHP-DB] INNER JOIN by field content

2002-06-25 Thread szii
You need to have keys in each table to join them together. Once you have those keys in place, you can match the keys across the tables and use a WHERE clause to filter the results. 'Luck! -Mike - Original Message - From: José Moreira [EMAIL PROTECTED] To: Php-Db [EMAIL PROTECTED] Sent:

Re: [PHP-DB] Re: DB400 on AS/400

2002-06-25 Thread szii
Sorry, that was vague. ODBC is a standard of connectivity and IS supported by the AS/400 platform. With that said, if AS/400 has ODBC support and PHP has ODBC support then the two can talk. -Mike - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL

[PHP-DB] Time difference question...

2002-06-25 Thread NIPP, SCOTT V (SBCSI)
I am working on a Call Log application, and need to calculate time. For example, if a page is received at 12:00, the page is returned at 12:10, and the call is resolved at 14:30... I need to be able to calculate the time to return the page, and also the time to resolve the call. I am

Re: [PHP-DB] Time difference question...

2002-06-25 Thread Martin Clifford
Versions above just before 4.0 of MySQL can handle direct date math. Try SELECT date_returned - date_paged FROM pagetable; It'll work if you have values date_returned and date_paged in the table pagetable of course :o) HTH Martin NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] 06/25/02 04:40PM

Re: [PHP-DB] Time difference question...

2002-06-25 Thread szii
Watch out, though, as direct date math can really screw ya over when it Daylight Savings changes (if you're not in a daylight savings area, you're okay.) Best bet is to use getdate() to build up the array, modify the array elements, then mktime it. If you just add seconds you'll get odd results

[PHP-DB] Differences between two mySQL Databases

2002-06-25 Thread Michael Robbins
I'm looking for a utility that can compare two database structures and generate a SQL statement that will duplicate the differences. I'm using mySQL and I have both live and development databases. While working on the development database, I frequently make changes to table structures,

Re: [PHP-DB] Differences between two mySQL Databases

2002-06-25 Thread Pierre-Alain Joye
On Tue, 25 Jun 2002 14:29:08 -0700 Michael Robbins [EMAIL PROTECTED] wrote: I'm looking for a utility that can compare two database structures and generate a SQL statement that will duplicate the differences. I'm using mySQL and I have both live and development databases. While working

[PHP-DB] Why do these values not match?

2002-06-25 Thread Manuel
The if statement is not working here. Does anybody know why? $total= 332.06; $production = 45.11 + 134.38 + 85.35 + 67.22; print(Total = $totalbr); print(Production = $productionbr); if($total != $production) { print(Totals do not Match!); } else { print(Totals are in Balance); }