Re: [PHP-DB] Some data manipulation

2002-10-06 Thread Hatem Ben
i was trying to do it with preg_replace, but this is much better thanks a lot, Hatem - Original Message - From: Rasmus Lerdorf [EMAIL PROTECTED] To: Hatem Ben [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, October 06, 2002 3:09 AM Subject: Re: [PHP-DB] Some data manipulation

[PHP-DB] passing array to next page

2002-10-06 Thread Smita Manohar
hello all, im having variable $item_id_v = 100 when i want to pass this value to the page item_maint.php i use the statement : ?php echo A HREF=\item_maint.php?item_id=$item_id_v\ Click /A ? i need to pass array using such way. but i dont know how to do that. can anyone pls help me out for

RE: [PHP-DB] passing array to next page

2002-10-06 Thread John W. Holmes
Look at the serialize() function or use sessions. www.php.net/serialize ---John Holmes... -Original Message- From: Smita Manohar [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 06, 2002 6:33 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] passing array to next page hello all, im

RE: [PHP-DB] Some data manipulation

2002-10-06 Thread John W. Holmes
Write a function to do whatever you want to each element, then use array_walk(). ---John Holmes... -Original Message- From: Hatem Ben [mailto:[EMAIL PROTECTED]] Sent: Saturday, October 05, 2002 6:49 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Some data manipulation hey all i

Re: [PHP-DB] $_POST And $_REQUEST

2002-10-06 Thread Marco Tabini
$_REQUEST is an associative array consisting of the contents of $_GET, $_POST, $_COOKIE, and $_FILES Also, they are not function but arrays, as Hatem said. You can usa $_REQUEST as a catch-all that provides you with both what was passed to your page through the URL query ($_GET) and what was

RE: [PHP-DB] passing array to next page

2002-10-06 Thread Marco Tabini
Also, if you decide to use serialize() and unserialize() through the post variables (I'd recommend against using it in the query URL because some browsers have a limit as to how much data they can fit into it), you should consider encrypting it in some way or at least appending an encrypted CRC

[PHP-DB] Noob error question

2002-10-06 Thread Noah Smith
This may be a rather noob question, but: I make several requests against a mysql db roughly of the form: mysql_connect mysql_select_db mysql_query mysql_close This will work for several connections (and sometimes all connections over the course of the script) On occassion, the script will be

[PHP-DB] possible Error in Querydefiniton

2002-10-06 Thread Ruprecht Helms
Hi, I've some trouble with the following querydefinition ? mysql_connect(localhost,root); mysql_db_query(finace,INSERT INTO buchung (Bezeichnung) VALUES ('b')) or die (Query ungültig); ? and this is the tablestructur

RE: [PHP-DB] possible Error in Querydefiniton

2002-10-06 Thread John W. Holmes
You can find out why with mysql_error(), but it's probably because you haven't selected a database with mysql_select_db(). ---John Holmes... -Original Message- From: root@linux [mailto:root@linux] On Behalf Of Ruprecht Helms Sent: Sunday, October 06, 2002 3:25 PM To: [EMAIL

RE: [PHP-DB] Noob error question

2002-10-06 Thread John W. Holmes
Is this on a live site, or one with just this test script running? You may be running into the max_connections of mysql. You're not connecting for _every_ query on the page, are you? You should have just one connect at the beginning, do all of your queries, then close at the end of the script.

[PHP-DB] DBF question: column names?

2002-10-06 Thread suzerain.studios
Hi there. I'm not familiar with DBF files, or the PHP dbase functions. I've found (very) few code snippets on the Web about DBF files...a class on PHP classes and a couple of other brief mentions elsewhere. I have a question: I was given a DBF file that I don't know the structure of. Is

[PHP-DB] a where clause question

2002-10-06 Thread Alex Shi
Hi, I need a where clause in following situation: Say I want to query two tables: A and B. In table A there is field Afn, while in table B there ere 3 fields: Bfn1, Bfn2 and Bfn3. I want to compose a query, in which the where clause can do this: if A.Afn=1, then check Bfn1, if A.Afn=2, then

[PHP-DB] Pedigree question

2002-10-06 Thread Russell Griechen
I need to develop a tree-like pedigree of animals up to 5 generations. I know there are other attributes to the animal; but do I need anyother tables...assuming that I can develop all the code to generate these ancestors. I have developed a CSS positioning code that will place these results in a

Re: [PHP-DB] Pedigree question

2002-10-06 Thread Mihail Bota
Yes, there are. There is a pretty good php code, called HTML Tree which can make trees, dynamically. Regarding the coding itself...you can have a simple table that records who is ancestor of who. This is a solution. Another one, which is not so neat is to create a table with 5 columns...one per

Re: [PHP-DB] Pedigree question

2002-10-06 Thread Matt Neimeyer
I need to develop a tree-like pedigree of animals up to 5 generations. I know there are other attributes to the animal; but do I need anyother tables...assuming that I can develop all the code to generate these ancestors. Animal ID Name Foal ID SireID DamID Would it be any more

Re: [PHP-DB] Pedigree question

2002-10-06 Thread Russell Griechen
Mihail Bota [EMAIL PROTECTED]wrote: Yes, there are. There is a pretty good php code, called HTML Tree which can make trees, dynamically. I did a search in the Php Manual...but did not understand what I was looking at. http://www.php.net/manual/sv/printwn/ref.domxml.php I will look

Re: [PHP-DB] Pedigree question

2002-10-06 Thread Russell Griechen
Thank you for your response. see comments below... - Original Message - From: Matt Neimeyer [EMAIL PROTECTED] I need to develop a tree-like pedigree of animals up to 5 generations. I know there are other attributes to the animal; but do I need anyother tables...assuming that I can

Re: [PHP-DB] Pedigree question

2002-10-06 Thread John Coder
On Sun, 2002-10-06 at 21:21, Russell Griechen wrote: I would like to have someone comment on whether the 2 tables mentioned would suffice and what functions...or code would be better to apply. Michael Koifler sp? in a book is purported to have a solution for heirarchical display...but I am

Re: [PHP-DB] Pedigree question

2002-10-06 Thread Mihail Bota
No, that is not the link. I am using this code: http://pear.php.net/package-info.php?pacid=77 There are many tree codes out there. Just try to use one. On Sun, 6 Oct 2002, Russell Griechen wrote: Mihail Bota [EMAIL PROTECTED]wrote: Yes, there are. There is a pretty good php code, called