[PHP-DB] Highlighting data selected from one table that appear in another

2005-09-01 Thread boclair
Content-Type: multipart/alternative; boundary=070700030402040702060708 X-Authentication-Info: Submitted using SMTP AUTH PLAIN at omta05ps.mx.bigpond.com from [138.130.220.111] using ID boclair at Thu, 1 Sep 2005 11:49:59 + This is a multi-part message in MIME format.

Re: [PHP-DB] Highlighting data selected from one table that appear in another

2005-09-01 Thread Miles Thompson
At 08:50 AM 9/1/2005, boclair wrote: Content-Type: multipart/alternative; boundary=070700030402040702060708 X-Authentication-Info: Submitted using SMTP AUTH PLAIN at omta05ps.mx.bigpond.com from [138.130.220.111] using ID boclair at Thu, 1 Sep 2005 11:49:59 + This is

Re: [PHP-DB] PHP5-MySQL Not Connecting Through Socket

2005-09-01 Thread Evan J
As of this post, this problem has not been solved [For those who get to this link via search engines]. I also tried to downgrade from PHP 5.0.4 to PHP 4.4.0 but the problem still persists. For some reason on my system (Slackware 10.1, kernel 2.6.11.3, MySQL 4.1.13a, Apache 2.0.54), PHP cannot

[PHP-DB] Storing an array on a table?

2005-09-01 Thread Miguel Guirao
Hi!! I want to store an array into a field on a MySQL table, Is it posible to save it? Maybe into a string field? Best Regards, --- Miguel Guirao Aguilera Logistica R8 TELCEL Tel. (999) 960.7994 Este mensaje es exclusivamente para el uso de la persona o entidad a quien

RE: [PHP-DB] Storing an array on a table?

2005-09-01 Thread Bastien Koert
yes, check out the serialize and unserialize fuinctions in the manual (www.php.net/serialize) bastien From: Miguel Guirao [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Storing an array on a table? Date: Thu, 01 Sep 2005 08:55:24 -0500 Hi!! I want to store an array into a

Re: [PHP-DB] Storing an array on a table?

2005-09-01 Thread tg-php
Sorry, didn't catch this thread from the beginning, but did anyone recommend trying the serialize() and unserialize() commands? They'll convert the array to a block of text that can be stored, retrieved and unserialized. My gut instinct is that if you're trying to store any array in a

Re: [PHP-DB] Storing an array on a table?

2005-09-01 Thread Jordan Miller
Yes, this has been mentioned in this thread. But with serialize/ unserialize, you can run into other problems that may be more confusing/difficult to troubleshoot. e.g.: http://www.php.net/serialize As you can see, the original array : $arr[20041001103319] = test after

RE: [PHP-DB] Storing an array on a table?

2005-09-01 Thread Miguel Guirao
Thanks to you all for your replies!! They are of great help --- Miguel Guirao Aguilera Logistica R8 TELCEL Tel. (999) 960.7994 -Original Message- From: Jordan Miller [mailto:[EMAIL PROTECTED] Sent: Jueves, 01 de Septiembre de 2005 10:28 a.m. To: [EMAIL

Re: [PHP-DB] Storing an array on a table?

2005-09-01 Thread tg-php
Ahh..thanks Jordan.. sorry I missed that one and thanks for the info. I assumed serialize was just magic and worked properly. hah. Now I know. I always thought it was sloppy to use anyway, but in a pinch, it's nice to know there's an option like that. Imploding does sound better though.

RE: [PHP-DB] Highlighting data selected from one table that appear in another

2005-09-01 Thread Murray @ PlanetThoughtful
mysql 4.0.25 php 4.3.1 I seem to be unable to solve this problem without some help. A webpage is to list all the clients in a mysql Client table. Each client has an an allocated clid. Those clients who are listed, identified by their allocated clid, in a Transactions are to be

[PHP-DB] Re: [PHP] Help: Get the value of pi up to 200+ digits?

2005-09-01 Thread Jordan Miller
strange, with your code, mine cuts out at 49 significant digits: 3.141592653589793115997963468544185161590576171875 it must be a system-specific limitation. we need more information on what you are trying to do, *exactly*. be as detailed and specific as possible. On Sep 1, 2005, at 10:57

[PHP-DB] Re: Highlighting data selected from one table that appear in another

2005-09-01 Thread Frank Flynn
I'm thinking that you need a LEFT JOIN (see the mysql documentation) to do this. Basically LEFT JOIN (or RIGHT JOIN) allow you to select all the rows from the table on the left side even if they have no corresponding row on the right side (the values of the columns in the select that

Re: [PHP-DB] Highlighting data selected from one table that appear in another

2005-09-01 Thread boclair
Miles Thompson wrote: At 08:50 AM 9/1/2005, boclair wrote: Content-Type: multipart/alternative; boundary=070700030402040702060708 X-Authentication-Info: Submitted using SMTP AUTH PLAIN at omta05ps.mx.bigpond.com from [138.130.220.111] using ID boclair at Thu, 1 Sep

[PHP-DB] Re: Highlighting data selected from one table that appear in another

2005-09-01 Thread boclair
Frank Flynn wrote: But if you could be more specific - send the schema and precisely what you were looking to do I could give you an example of how to make it work. I am still having difficulties with my workup and more help would be appreciated . I have two tables CREATE TABLE