[PHP-DB] odbc_columns()

2001-01-22 Thread szii
() method is working. After more playing, I still cannot seem to actually USE the results of an odbc_columns() call on DB2 since just about everything "fetch-related" segfaults. Is there another method or set of methods that I'm missing? Thoughts? Ideas? -Szii -- PHP Database Ma

Re: [PHP-DB] Connectivity to AS/400

2001-02-04 Thread szii
=path. Make sure you run the CATALOG commands on the client so that it can find the AS400 database. 'Luck! -Szii At 10:41 AM 2/4/2001 -0800, Pete Lancashire wrote: I'm going to be trying to connect to the native DB2 database in a AS/400 So far thats all I know about the IBM side. Can someone give

Re: [PHP-DB] db2 with php

2001-02-04 Thread szii
add a line into /etc/ld.so.conf too. -Szii At 11:08 PM 2/4/2001 -0500, Chris Book wrote: Hello, I've installed db2 and created the default instance at /home/db2inst1/. PHP is compiled with the --with-ibm-db2 option, however when I try to start apache I get the message: "Cannot load /etc/httpd/mod

Re: [PHP-DB] Tricky one - include($identifer);

2001-02-07 Thread szii
http://www.php.net/manual/en/function.eval.php Couple of notes from the userbase show how to include HTML in a php $content passed to eval() 'Luck. -Szii At 05:07 PM 2/8/2001 +1300, Simon Helson wrote: Hey guys - I've been mulling this one over for a few days now - and still haven't come up

[PHP-DB] mysql_insert_id()

2001-03-12 Thread szii
Is there a known way to "reset" this field? If I make a call and it succeeds, then it should be set. If it fails, shouldn't it at least be reset to 0 or -1 instead of simply the last successful insert? Is this the expected behavior? -Szii -- PHP Database Mailing List (http://w

Re: [PHP-DB] Updating multiple forms

2001-04-18 Thread Szii
Off the top of my head, and it's 3am local so take this with a grain of salt, but I think that this will work... Update Table1, Table2 SET Table1.column1 = 'blah', Table2.column1='foo' WHERE Table1.ID = x AND Table2.ID = y 'Luck -Szii - Original Message - From: Lester June Cabrera

Re: [PHP-DB] MySQL transactions?

2001-04-18 Thread Szii
The newest MySQL code has transactions via their implementation of Sleepcat's BDB tables. If you use BDB tables instead of MyISAM you can do transactions. Check the syntax on CREATE TABLE for details on how to create BDB tables. 'Luck -Szii - Original Message - From: Gary Huntress

Re: [PHP-DB] PHP question needing info

2001-04-20 Thread Szii
*begins dousing Paul S with water before the flames start* -Szii - Original Message - From: Paul S [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 20, 2001 3:04 PM Subject: [PHP-DB] PHP question needing info I have a question that I need help with. The question

Re: [PHP-DB] reword my question

2001-04-20 Thread Szii
Read The Fine Manual? exec(); -Szii - Original Message - From: Paul S [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 20, 2001 4:13 PM Subject: [PHP-DB] reword my question How do I execute a shell script in php? I just started to use php and I am learning

Re: [PHP-DB] Can't get my head around this problem...

2001-04-24 Thread Szii
Perhaps...? $x = 0; while ($x 7) { if (!isset($myArray[$x])) { $myArray[$x] =0; } } -Szii - Original Message - From: Tyrone Mills [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 3:58 PM Subject: [PHP-DB] Can't get my head around this problem

Re: [PHP-DB] Flash+PHP search error

2001-05-14 Thread Szii
This is not really related to PHPDB Send me the code . It looks like you have an unbalanced double-quote. Same thing's happening with your footer, too. Should be an easy fix. -Szii - Original Message - From: Brian Tegtmeier [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday

Re: [PHP-DB] 'the missing character'

2001-05-16 Thread Szii
that inc's your start by one, and then adds 3500. Drop the second if($start == 0) clause which sets $start to 1. 'Luck -Szii - Original Message - From: Jimmy Brake [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 9:54 PM Subject: [PHP-DB] 'the missing character

Re: [PHP-DB] Filling mysql db with access db

2001-05-16 Thread Szii
Export as a comma-delimited file, explode() the file one line at a time along commas, and use insert via normal methods. Not sure if MySQL has a parser for comma-delim (probably does) but this way you have more control over how it goes in. -Szii - Original Message - From: Gabriel

Re: [PHP-DB] 'the missing character' YIKES

2001-05-16 Thread Szii
, but it seems to work... -Szii - Original Message - From: Jimmy Brake [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 9:58 PM Subject: [PHP-DB] 'the missing character' YIKES I forgot to detail the problem, I loose a character every once in a while basically every 3500

Re: [PHP-DB] mySQL Addition Problem

2001-05-16 Thread Szii
Sorry, last message was a little vague. Your SQL will fail because of the ',' after the SET clause. Therefore affected_rows shows 0, and inserts a new row. Then when you match with the LIKE clause, it's going to match multiple times. Miles, you were SO close with #2. =) -Szii - Original

Re: [PHP-DB] Storing duplicate checkbox values

2001-05-17 Thread Szii
)) // It's checked, therefore it's set - if it's not checked, it's just not set. { echo Set\n; } else { echo Not set\n; } } /XMP This will give you Set/Not Set lines 80 times. G'luck.. -Szii - Original Message - From: John Starkey [EMAIL PROTECTED] To: [EMAIL PROTECTED

Re: [PHP-DB] Need Database Design help

2001-05-18 Thread Szii
; or if you wanted to check multiple groups, SELECT UserID from GroupMemberTable WHERE GroupID IN (4,2,3); The map table may get huge depending on the number of users/groups, but it's a possibility. -Szii - Original Message - From: Doug Schasteen [EMAIL PROTECTED] To: php-db list [EMAIL

Re: [PHP-DB] RE: Storing Code in a db?

2001-07-03 Thread Szii
!\;; // note that it's got a ; INSIDE the string...it's PHP in there, after all eval($str); If you wanted to pre-generate it, I don't see any reason why you couldn't addslashes() the code, and INSERT it that way. Pull it back out, stripslashes() it, and eval() it. Voila! -Szii - Original

Re: [PHP-DB] kinda unrelated, but curious...

2001-07-03 Thread Szii
for work. It's amazing how many people know people that know people and you end up with work. 8-) -Szii - Original Message - From: David Balatero [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 02, 2001 11:27 PM Subject: [PHP-DB] kinda unrelated, but curious... ...where do you

Re: [PHP-DB] Not Really A DB Question

2001-07-27 Thread Szii
This is not VB - this is better. Probably want to name all of your text fields something similar, since they'll be mixed in with the drop downs, radio buttons, etc... Check $HTTP_POST_VARS and $HTTP_GET_VARS in your form's target. -Szii - Original Message - From: Peter J. Krawetzky

[PHP-DB] MySQL Modules and multiple database

2001-08-13 Thread Szii
solution. Anyone have any ideas/thoughts? Thanks. -Szii -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] MySQL Modules and multiple database

2001-08-13 Thread Szii
it on two different links, it's seems to modify both links. Almost like it's global *shrug* -Szii - Original Message - From: Paul Burney [EMAIL PROTECTED] To: Szii [EMAIL PROTECTED]; php mailing list [EMAIL PROTECTED] Sent: Monday, August 13, 2001 2:28 PM Subject: Re: [PHP-DB] MySQL

Re: [PHP-DB] db's war

2001-09-18 Thread Szii
. If you just need a super fast lightweight database, OpenSource. For everything else, DB2. And if you need a kick-arse track-anything-anywhere-anyhow system, look at Camstar Systems, which will handle backends of both DB2 and Oracle. It's better than the Oracle MES/tracking modules. -Szii

Re: [PHP-DB] Learning PHP Sessions

2001-10-30 Thread Szii
. Check out http://www.php.net/manual/en/ref.session.php 'Luck -Szii - Original Message - From: Matthew Tedder [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 30, 2001 12:30 PM Subject: [PHP-DB] Learning PHP Sessions ?php /* Hi, I'm new to PHP and am having trouble

Re: [PHP-DB] Another Drop down question

2002-03-27 Thread szii
; -Szii - Original Message - From: Kim Kohen [EMAIL PROTECTED] To: PHP [EMAIL PROTECTED] Sent: Wednesday, March 27, 2002 5:18 PM Subject: [PHP-DB] Another Drop down question Hello all, I'm trying for the first time to use a dynamically created popup menu from a mysql database

Re: [PHP-DB] need some help...

2002-04-02 Thread szii
. ** http://www.php.net/manual/en/function.fopen.php http://www.php.net/manual/en/function.fputs.php http://www.php.net/manual/en/function.fclose.php Party on! -Szii -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Complex (for me) table join - help please?

2002-04-19 Thread szii
Try SELECT TableA.Category, TableB.PersonID FROM TableA LEFT JOIN TableB ON (TableA.CategoryID = TableB.TableAID) WHERE TableB.ClientID = $cid ORDER BY TableA.Category ASC LEFT JOIN states that you should return all TableA, inserting NULL for TableB if there is no match. 'Luck -Szii

Re: [PHP-DB] Re: Retrieve information from mutiple tables

2002-04-22 Thread szii
that the above SEQUENCE is important. If you deviate from it, you may get unknown variable or other error messages. -Szii - Original Message - From: Prodoc [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 2:38 PM Subject: Re: [PHP-DB] Re: Retrieve information from mutiple

Re: [PHP-DB] auto-increment question

2002-04-23 Thread szii
This is more of a MySQL question, but you can set the column default for the auto_increment column to something other than 1. Look up the SET DEFAULT clause of the table create / alter table calls. -Szii - Original Message - From: Dan Swensen [EMAIL PROTECTED] To: php [EMAIL PROTECTED

Re: [PHP-DB] please help!

2002-04-23 Thread szii
not being used correctly 'Luck -Szii - Original Message - From: Evans, Josh [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 11:26 AM Subject: [PHP-DB] please help! Database: sites I have to columns: id and site. I will have approx 800 entries in the db when I am

Re: [PHP-DB] User getting superuser access. ack!

2002-04-23 Thread szii
Well, that looks like a problem within the findLoginType() call. Since it's not been included, it's hard to help you. :) 'Luck -Szii - Original Message - From: J. Wharton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 11:09 AM Subject: [PHP-DB] User getting

Re: [PHP-DB] User getting superuser access. ack!

2002-04-24 Thread szii
, or what the status is currently. 'Luck! -Szii - Original Message - From: J. Wharton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 8:51 AM Subject: Re: [PHP-DB] User getting superuser access. ack! here's the code for findLoginType($username): function

Re: [PHP-DB] Mssql/Sybase errors

2002-04-25 Thread szii
hehehe, you recoded PHP to reconnect to MSSQL, but you forgot to redo your connection stuff. Sybase error: means that you're connecting to Sybase and not MSSQL. *wink* 'Luck -Szii - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 25, 2002 10

Re: [PHP-DB] FORM not inserting data

2002-04-26 Thread szii
put in a var_dump($sql);die(); right after $result = mysql_query($sql); Then copy/paste it into mysql's command line util, and see what you get. -Szii - Original Message - From: Neil [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 25, 2002 6:34 PM Subject: [PHP-DB

Re: [PHP-DB] selected problem

2002-04-26 Thread szii
When you build the list up, originally, you'll NOT put selected on Choose City, but move it to Alexandria. -Szii - Original Message - From: its me [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 26, 2002 1:39 AM Subject: [PHP-DB] selected problem i have the file

Re: [PHP-DB] Session Problem, Please Help.....

2002-05-02 Thread szii
I believe it's because $CLIENTID is not set at ALL before you register it. (ie, isset($CLIENTID) would fail) Therefore it cannot register the variable...there's nothing for it to register or track. Try... $CLIENTID = ; session_register(CLIENTID); $CLIENTID=SOMEVALUE; - Original Message

Re: [PHP-DB] Re: Spaces Problem php mysql

2002-05-02 Thread szii
. $name = This is Paul's field. . . . INSERT INTO table ( name ) VALUES ( '$name' ) Will fail, because you have VALUES ('This is Paul'); Post the full value of $name via var_dump($name) and var_dump($query) and we'll see what we can find with it. 'Luck -Szii -- PHP Database Mailing List (http

Re: [PHP-DB] Global Connection object

2002-05-02 Thread szii
pooling capabilities, so it's not really any overhead to reconnect. If no pooling is available, then you limit yourself (and your webserver) to a single connection. (Will kill your performance.) HTH. 'Luck -Szii - Original Message - From: Shaun Johnston [EMAIL PROTECTED] To: [EMAIL

Re: [PHP-DB] Re: Spaces Problem php mysql

2002-05-02 Thread szii
AddSlashes() or AddCSlashes() -Szii - Original Message - From: Paul [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 4:11 PM Subject: Re: [PHP-DB] Re: Spaces Problem php mysql On Thursday 02 May 2002 10:10 am, you wrote: - Original Message - From

Re: [PHP-DB] sql querry problem

2002-05-03 Thread szii
Delete from does not work with multiple tables, AFAIK.. -Szii - Original Message - From: andy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 03, 2002 2:02 AM Subject: [PHP-DB] sql querry problem Hi there, I do have 2 tables. One contains an update for the other one

Re: [PHP-DB] need help on improving performance on this querry

2002-05-07 Thread szii
SELECT DISTINCT L.* from data.languages L, data2.user U WHERE L.id IN (U.language_1, U.language_2, U.language_3) order by name; I believe the IN clause is a shade faster than multiple ORs, but I'm not 100% sure. 'Luck -Szii - Original Message - From: andy [EMAIL PROTECTED

Re: [PHP-DB] PHP/MySQL and inserting blob data?

2002-05-09 Thread szii
$escdata = addslashes($data); UPDATE Blabla SET value = '$escdata' WHERE... Make sure you use addslashes, though. It's important. 'Luck -Szii - Original Message - From: Hadmut Danisch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 09, 2002 1:06 PM Subject: [PHP-DB

Re: [PHP-DB] DB and eval. HELP !!!

2002-05-20 Thread szii
foreach($website = mysql_fetch_array($result)) { $text = You can go here: strong?=$website['originalDomain']?/strong and find information; eval($text); } You get the idea... 'Luck -Szii - Original Message - From: Bogdan ROMAN [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday

Re: [PHP-DB] problems 'adding' to MySQL DBs

2002-05-20 Thread szii
interface. You can also use the mysql_error() and mysql_errno() calls to see what went wrong. -Szii - Original Message - From: cin [EMAIL PROTECTED] html body ? php mysql_connect(localhost, test, testpw); mysql_select_db(testdb); msyql_query(insert into firsttab (first_name

Re: [PHP-DB] DB and eval. HELP !!!

2002-05-20 Thread szii
doesn't even require an eval() call. Apologies for the confusion.. -Szii - Original Message - From: [EMAIL PROTECTED] To: Bogdan ROMAN [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, May 20, 2002 11:11 AM Subject: Re: [PHP-DB] DB and eval. HELP !!! foreach($website

Re: [PHP-DB] DB and eval. HELP !!!

2002-05-20 Thread szii
... :) -Szii - Original Message - From: [EMAIL PROTECTED] To: Bogdan ROMAN [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, May 20, 2002 11:21 AM Subject: Re: [PHP-DB] DB and eval. HELP !!! Oops, minor oversights on my part. If you're calling eval() in the context of a PHP script, you

Re: [PHP-DB] JOIN statement not producing expected output

2002-05-20 Thread szii
://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SELECT 'Luck -Szii - Original Message - From: admin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 20, 2002 5:48 PM Subject: [PHP-DB] JOIN statement not producing expected output Okay, now this is my first try

Re: [PHP-DB] replication questions

2002-05-20 Thread szii
in `my.cnf' or just exclude a set of databases with replicate-ignore-db. -- Two-way replication is not supported yet. http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Replication 'Luck -Szii

Re: [PHP-DB] xml doc validation .... details ...... ! ! ! !

2002-05-20 Thread szii
Your questions are far too vague and XML/XML:Schema/XSLT etc are far too complicated to explain without definitive focus'd questions. XML allows you to do whatever YOU want in whatever format YOU want. Best help I can give is this... http://www.w3.org/ 'Luck -Szii - Original Message

Re: [PHP-DB] String datetime to DateTime

2002-06-20 Thread szii
Hmm...odd. I guess their %s (yes that was a typo) looks for a space as a delimiter and not the specified next one. Easiest workarounds off the cuff... 1) sscanf() to get the bulk of the data out, then regex out the %s string. 2) eregi_replace() Jun with the numeric 3) Dump it as numeric

Re: [PHP-DB] got it, thanks

2002-06-24 Thread szii
Because it's not $s in the context of a printf() call. It is %s to denote a string replacement. -Mike - Original Message - From: Matthew Crouch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 12:41 PM Subject: [PHP-DB] got it, thanks Seth Yount wrote: in

Re: [PHP-DB] check two tables at same time?

2002-06-24 Thread szii
SQL JOINs... http://www.mysql.com/doc/J/O/JOIN.html -Mike - Original Message - From: Noah Spitzer-Williams [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 4:21 PM Subject: [PHP-DB] check two tables at same time? hey guys, im trying to figure out a query

Re: [PHP-DB] Works with one server and not the other

2002-06-24 Thread szii
MySQL doesn't support subselects. Look up mysql_insert_id(). It'll return the ID of the last inserted record. Or just break out the second INSERT statement into one SELECT and then the actual INSERT. -Mike - Original Message - From: Christine Clerc [EMAIL PROTECTED] To: [EMAIL

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

2002-06-24 Thread szii
- Original Message - From: Cosby, Christopher [EMAIL PROTECTED] I don't want to start a tangent here, but the most accepted way for generating HTML with PHP is to NOT generate HTML with PHP. Thus, the original code should be written like this: Huh? .. most accepted way for

Re: [PHP-DB] Re: brand new elementary question

2002-06-24 Thread szii
Just a quick follow up... from http://www.w3.org/MarkUp/html-spec/html-spec_8.html#SEC8.1 When there is only one single-line text input field in a form, the user agent should accept Enter in that field as a request to submit the form. and a random link...

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

2002-06-24 Thread szii
exec() the query results. -Mike - Original Message - From: Matthew Tedder [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 2:31 PM Subject: [PHP-DB] PHP in Database Fields.. Question: I want to put PHP code into database fields holding HTML text, how can

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

2002-06-24 Thread szii
I'm sorry, brainfart. Don't exec(), eval(). Apologies. -Mike - Original Message - From: Matthew Tedder [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 4:00 PM Subject: Re: [PHP-DB] PHP in Database Fields.. On Monday 24 June 2002 09:21 pm,

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

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