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

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 `cl

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

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 20

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

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 bel

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

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 A

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

> 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" a

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

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. -T

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

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 PROTECTE

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

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 serialize/uns

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

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 database,

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

if you just have a simple array with automatic numeric keys and text you could just implode the data to a string with a separator not found in your data: $dataArray = array("hello", "goodbye", "etc."); $storable = implode("", $dataArray); // $storable becomes "hellogoodbyeetc." //

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

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

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

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 est

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

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 make

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

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

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

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. --