Dennis Cole | 15 Apr 06:14 2001

RE: SQL Query

There is a nice piece of software that you should get,! It's not free, but you can download a
trial. (I would get it) It is great for building querys across tables.

-----Original Message-----
From: Zydox [mailto:Zydox <at>]
Sent: Friday, February 14, 2003 11:18 PM
To: php-general <at>
Subject: [PHP] SQL Query

I have a problem writing a query that can select a Interest for a specific
user... There are tvo tables, IList and IIndex...
IList contains this :
      ID  SubID  Interest  Valid
      Edit  Delete  1 0 Datorer 0
      Edit  Delete  2 1 Spel 0
      Edit  Delete  3 2 Strategi 0
      Edit  Delete  4 3 Star Craft 1
      Edit  Delete  5 3 Star Wars: Gallactic Battelinggrounds 1
      Edit  Delete  6 2 Shoot-Em-Up 0
      Edit  Delete  7 6 Half-Life 0
      Edit  Delete  8 7 Team Fortress 1
      Edit  Delete  9 7 Counter-Strike 1

And IIndex contains a UserID And InterestID... this query :
"SELECT DISTINCTROW InterestsList.ID, InterestsList.SubID,
InterestsList.Interest, InterestsList.Valid FROM InterestsList AS II RIGHT
JOIN InterestsList ON InterestsList.ID=II.SubID LEFT JOIN InterestsIndex ON
InterestsList.ID=InterestsIndex.InterestID AND InterestsIndex.UserID='1'"

(Continue reading)

Dennis Cole | 19 Apr 00:48 2001

RE: limiting characters

$words = "All I want for Christmas is my two front teeth ";

$newwords = trim($words);

$pieces = explode(" ", $words);

echo "$pieces[0] $pieces[1] $pieces[2] $pieces[3]...";

// Retures "All I want for... "

-----Original Message-----
From: Michael P. Carel [mailto:mikecarel <at>]
Sent: Tuesday, February 18, 2003 6:19 PM
To: Justin French; php-general <at>
Subject: Re: [PHP] limiting characters

it would be better if it will be chopped by words and not by characters. Any
idea how?

----- Original Message -----
From: "Justin French" <justin <at>>
To: "Michael P. Carel" <mikecarel <at>>; <php-general <at>>
Sent: Wednesday, February 19, 2003 7:26 AM
Subject: Re: [PHP] limiting characters

> Do you want it chopped at a certain number of words, or characters?
> Justin French
(Continue reading)

Dennis Cole | 19 Apr 01:29 2001

RE: ASCII/UNICODE Character Translation Comparison in Strings

$txt = "björk";
$txt = strtr($txt, "ÁÉÍÓÚÑÀÈÌÒÙÄËÏÖÜÂÊÎÔÛáéíóúñàèìòùäëïöüâêîôûç",
echo $txt; // Returns "bjork"

-----Original Message-----
From: Chris McCluskey [mailto:chris <at>]
Sent: Tuesday, February 18, 2003 7:03 PM
To: php-general <at>
Cc: Flint Doungchak; Ethan Nelson
Subject: [PHP] ASCII/UNICODE Character Translation Comparison in Strings

Hello, I was wondering if there are any native PHP functions that will
acomplish what I have set out to do here:

I have an issue where I would need to compare international characters, for
instance i would want "björk" to match "bjork", i would want ô,ö, and ò to
match o; ñ, Ñ to match n. etc...

I could just create a function that would do this, and I already have ideas
about how to go about this, but before i start coding, i want to make sure
there isn't something that PHP does already that could replace what i'm
trying to do here.


(yes, i googled already) ;-)

(Continue reading)