php-general Digest 2 May 2005 19:58:28 -0000 Issue 3431
Topics (messages 214318 through 214350):
Can someone help me build a regular expression?
214318 by: mwestern.sola.com.au
214324 by: Jason Sweeney
214325 by: Thomas Bonham
Re: Submit name change
214319 by: Jochem Maas
CMS backend
214320 by: Dustin Krysak
214330 by: Philip Hallstrom
Strange problem with DB queries
214321 by: George Pitcher
Re: Strange problem with DB queries - MORE
214322 by: George Pitcher
Extensions modules, PHP5.1 from CVS and Windows
214323 by: Jirka Kosek
Re: form array
214326 by: Brent Baisley
Re: Having problems connecting to MS SQL2000 server on PHP5
214327 by: Nathan Tobik
Re: Newbie Help
214328 by: Richard Collyer
Re: Templating engines
214329 by: Skrol29
214333 by: Skrol29
214334 by: Robert Cummings
Image Generation: Centering Text
214331 by: Richard Collyer
214332 by: Richard Davey
php4 to php5, now classes don't work?
214335 by: Mike
214336 by: Chris
mysqli grrrr
214337 by: JM
214338 by: JM
possible to use eregi instead of LIKE
214339 by: Ross
214340 by: Jay Blanchard
214341 by: John Nichel
214342 by: John Nichel
214343 by: Jay Blanchard
214344 by: Ross
214345 by: Ross
214346 by: Jay Blanchard
214348 by: John Nichel
just going with LIKE
214347 by: Ross
214349 by: Marek Kilimajer
214350 by: Matthew Weier O'Phinney
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[email protected]
----------------------------------------------------------------------
--- Begin Message ---
Hi All,
I've sucessfully got a JavaScript validating some text boxes to make
sure that only numbers exist. I cheated and downloaded a regular
expression someon else had used and that works nicely. I wish to
validate the text box in the format of:
xXX.X
With the upper case Xs being a required number and the lower case x
being allowed but not needed.
Can anybody help me?
Ta
Matthew
--- End Message ---
--- Begin Message ---
Give this a shot:
^[0-9]{2,3}\.[0-9]$
Returns regex that begins with 2-3 digits, followed by a period, and
ends with one digit.
jason sweeney
jason.designshift.com
[EMAIL PROTECTED] wrote:
Hi All,
I've sucessfully got a JavaScript validating some text boxes to make
sure that only numbers exist. I cheated and downloaded a regular
expression someon else had used and that works nicely. I wish to
validate the text box in the format of:
xXX.X
With the upper case Xs being a required number and the lower case x
being allowed but not needed.
Can anybody help me?
Ta
Matthew
--- End Message ---
--- Begin Message ---
[EMAIL PROTECTED] wrote:
Hi All,
I've sucessfully got a JavaScript validating some text boxes to make
sure that only numbers exist. I cheated and downloaded a regular
expression someon else had used and that works nicely. I wish to
validate the text box in the format of:
xXX.X
With the upper case Xs being a required number and the lower case x
being allowed but not needed.
Can anybody help me?
Ta
Matthew
You mite try this. I know that this work with perl.
=~ m/^[0-9][A-Z][a-z]{2-3} \.[0-9]+$/
I'm still very new to this. But I'm trying to help.
Thomas
[EMAIL PROTECTED]
--- End Message ---
--- Begin Message ---
Anasta wrote:
I need this to change the value of the button 'sit in' to the name of a
user --it doesnt work so anyone got any ideas or is what i am looking to do
impossible.
have you tried the [EMAIL PROTECTED] list? ;-)
(with kudos to John Nichel for the original 'psychic-db' comment which still
makes me laugh when I think about it)
Either the button name can show the username or a text field can change from
blank to show the username when clicked.
<FORM ACTION="<?=$PHP_SELF?>" METHOD="GET">
<INPUT TYPE="SUBMIT" VALUE="Sit in"
onClick="JavaScript:showname('<?php echo $uname;?>');
the "JavaScript" is a give away that this is not a php question, go to a
javascript
list (or maybe first try google) and ask them, don't forget to include
the definition of showname(), without it nobody can tell you why _it_ doesn't
work.
btw:
1. from what I can tell what you want to do is far from impossible.
2. on the PHP side of things, you have to make sure that $uname does not
contain any unescaped single-quotes before echoing it (if you want to be sure
that you javascript will not throw an error due to a syntax error)
return true;">
</FORM>
--- End Message ---
--- Begin Message ---
Hi there, I was wondering if anyone knows of any existing php/mysql
cms back-ends (no need for a front end).
I am just looking for one to dissect (for learning purposes) - and
would prefer to keep the presentation out of it for the sake of not
having to sort through a 1000 extra files.
Thanks in advance.
d
--- End Message ---
--- Begin Message ---
Hi there, I was wondering if anyone knows of any existing php/mysql cms
back-ends (no need for a front end).
I am just looking for one to dissect (for learning purposes) - and would
prefer to keep the presentation out of it for the sake of not having to sort
through a 1000 extra files.
http://www.opensourcecms.com/
--- End Message ---
--- Begin Message ---
Hi,
I am encountering a strange problem with a pop-up window. On my site, users
(very specialised, closed site with small numbers) have to click a link on
page x which pops up page y. Page x and y both contain pricing information
based on a functions.php include file. On page x, the data is being
displayed correctly. On page y, most of the data is not being displayed.
On page y, I've echoed the queries and they work fine when I paste them into
MySQLCC. However, if I do print_r($row), I get an ampty array. Echoing the
$result gives me Object id #3 (on page x this is Object id #6).
I have another popup window which is used to build xml output etc and the
queries (some using the same functions) seem to wortk there.
Any suggestions?
George
--- End Message ---
--- Begin Message ---
Sorry, I forgot to mention that I'm using PEAR::DB and Smarty, Server is
WinNT running Apache 2.0.52, and PHP 5.0.2. MySQL 4.0.5-beta-max-nt is
running on a separate server (NT also). All this is about 70 miles away and
I haven't seen the servers for over 3 years (oh how wonderful remote access
is!).
Cheers
> -----Original Message-----
> From: George Pitcher [mailto:[EMAIL PROTECTED]
> Sent: 2 May 2005 12:07 pm
> To: [email protected]
> Subject: [PHP] Strange problem with DB queries
>
>
> Hi,
>
> I am encountering a strange problem with a pop-up window. On my
> site, users
> (very specialised, closed site with small numbers) have to click a link on
> page x which pops up page y. Page x and y both contain pricing information
> based on a functions.php include file. On page x, the data is being
> displayed correctly. On page y, most of the data is not being displayed.
>
> On page y, I've echoed the queries and they work fine when I
> paste them into
> MySQLCC. However, if I do print_r($row), I get an ampty array. Echoing the
> $result gives me Object id #3 (on page x this is Object id #6).
>
> I have another popup window which is used to build xml output etc and the
> queries (some using the same functions) seem to wortk there.
>
> Any suggestions?
>
> George
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
Hi,
I need to use some XML functionality that will be available in PHP5.1.
When I use PHP development version from http://snaps.php.net/ for
Windows core of PHP works great. But once I load extension module (e.g.
php_xsl.dll, php_xmlreader.dll, php_soap.dll) PHP crashes --
immediatelly with Apache when I use server module, or when there is
first call to function in module when I use CLI.
Has anyone successfully used extensions under Windows with development
version of PHP?
TIA,
Jirka
--
------------------------------------------------------------------
Jirka Kosek e-mail: [EMAIL PROTECTED] http://www.kosek.cz
------------------------------------------------------------------
Profesionální školení a poradenství v oblasti technologií XML.
Podívejte se na náš nově spuštěný web http://DocBook.cz
Podrobný přehled školení http://xmlguru.cz/skoleni/
------------------------------------------------------------------
--- End Message ---
--- Begin Message ---
Exactly. You can really go as deep as you want with your array "fields".
On May 1, 2005, at 10:15 PM, Sebastian wrote:
i've created file upload scripts in the past that allows multi-upload
inputs
using the bracket [] array in form.
so now i have to create the same type of script but each file input
field
will also be followed by a text box for a "file caption" type thing.
what would i used for the input text box?
file: <input type="file" name="foo[]">
now for my text field?
<input type="text" name="??">
something like foo[caption][] ?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--- End Message ---
--- Begin Message ---
Hi,
We run PHP with SQL server no problems here. You never
mentioned it so I thought I would, if you're running on Linux you need
the FreeTDS library installed on the machine. If you are running on
Windows you need the SQL Server client tools installed on the machine
that PHP is on. Hope this helps.
Nate Tobik
(412)661-5700 x206
VigilantMinds
-----Original Message-----
From: Vernon Jenewein [mailto:[EMAIL PROTECTED]
Sent: Friday, April 29, 2005 2:11 PM
To: [email protected]
Subject: [PHP] Having problems connecting to MS SQL2000 server on PHP5
Hi,
Follwoing is a problem I'm having following some advice in a book called
"PHP5 in easy steps" written by Mike McGrath:
This is a connection that seems not to work according to the writer of
"PHP
5 in easy steps" :
<html>
<head> <title>MS SQL2000 Connection Test</title> </head>
<body>
<h2>
<?php
$connection = mssql_connect ( "MS_SQL2000" )
or die ( "Sorry - unable to connect to MS SQL2000" );
echo ("Congratulations, Vernon, - you connected to MS SQL2000") ;
?>
</h2>
</body> </html>
He originally wrote (for line 6) $connection = mysql_connect (
"localhost",
"root", "" )
or die ("Sorry - unable to connect to connect to MySQL");
All I am doing is trying to use MS SQL2000 which I have running on my
comptuer, along with Apache Server (1.3.33)and PHP5 (5.0.4) And get a
result that does not connect. Give it a try and you will see. I
created a
file in the htdocs folder of Apache and it is named mssqltest.php and
has
the above scripts. Rather than using the MySQL that the author has
suggested to use, I'm using my exisiting MS SQL2000 that is up and
running.
Also I have not had much success with Apache Server 2.0.54 as yet.. any
one
else?
Would be nice if authors would not assume that you ALWAYS want to use
MySQL
or any other database manager, and just put in a few examples from
different
angles.
thanks in advance if you have some ideas for me.
CHEERS!!
Vernon
Flintknapper Forums at:
http://scottieluvr.com/v-web/bulletin/bb/index.php
Vernon Jenewein
6658 116th Ave.
Fennville, MI 49408
269-227-8748
"You will know the truth, and the truth will set you free." (Jn 8:23)
[EMAIL PROTECTED]
[EMAIL PROTECTED] (secondary)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Hello,
<?php
if(isset($_GET['page']))
{include($_GET['page'] . ".php");}
else
{echo("Page Not Set.");}
?>
Should work if you use ?page=index
Might I suggest that what you are doing is a bad idea. Not only will it
look bad becuase of people seeing stuff like ?page=/review/review23.php
in the URL. Also its a security risk allowing people to call php scripts
from the URL.
Cheers
Richard
Thomas Bonham wrote:
Hello All,
First of I'm new to this a hop I'm doing this right.
If some one can help me with my web site page. I'm trying to make it
call a page and I get a error line 42. Error:
http://bonhamlinux.org/idex.php?page=links/index.php
The code that I'm trying to do this is the following:
<?php
if(isset($_GET ['page']))
{include($_GET ['page'].".php");}
else
{echo("Page Not Set.");}
?>
My site is: http://bonhamlinux.org
My email is: [EMAIL PROTECTED]
Thanks for all the help.
Thomas
--- End Message ---
--- Begin Message ---
Skrol 29 wrote:
I just can't work with PHP the usual way.
Mixing business source and interface source is something too bastard
for me.
Now that I know templates systems I totaly disagree to say that PHP is a
Template Engine. Ok, it has some basic template features, but they
are too
poor to use it this way seriously.
Mattias Thorslund wrote:
Who says PHP itself is a template engine? I think nobody.
Rasmus Lerdorf wrote:
I do.
[...]
The approach I tend to point people at is something I have been calling
a Template API. That is, when you build your application, you create a
template api to go along with it. In essence you are creating a
templating system for each application you write.
While the Template API approach you're describing is a good solution for
developing applications with Php and while it does separate business
logic from design logic in some way, I would call it a modularized
system rather than template system.
In your example, the application organisation is templated, but the
design is not nicely templated.
This has probably something to do with what we expect a Template System
to be. I think a good Template System for PHP should enable us to work
the way we work with L4G/RAD tools. That is:
- build and update the design with a WYSIWYG tool,
- change the makeup of the design without coding,
- change the position of the displayed data without coding,
- not touch design source from the code.
This way, business logic and design logic stay linked only by
technical entities chosen to display sets of data (listbox, checkbox,
table,...).
It's possible to have such a Template Engine; there is no technical
reason to not have it. It's just that the first generation of PHP
Template Engines missed that.
I'd like to have such a Template Engine not because I have no control
over the people creating templates, but most of all because that's a
very comfortable way to conceptualize and manipulate an application in
edit mode.
---------------------
Skrol29
www.tinybutstrong.com
---------------------
--- End Message ---
--- Begin Message ---
Mattias Thorslund a �crit :
Then I wonder what makes skol29 think PHP's "basic template features"
are "too poor" to be used seriously? I think PHP's "basic template
features" are phenomenal.
PHP is a nice and powerfull scripting langage oriented for Web
developement. Let's look at what's it can do as a Template Engine.
-> place data items in a template:
HTML ... <?php echo $myvar ?> ... HTML
-> repeat a zone with data items (*):
HTML ... <?php for ($i=0;$i<=$iMax;$i++) { >
HTML ... <?php echo $myvar[$i] ?>
HTML ... <?php } ?>
-> Hide or display a zone:
HTML ... <?php if ($test) { ?>
HTML ... <?php } ?>
-> include an external part or subtemplate:
HTML ... <?php include('subtemplate.php') ?> ... HTML
And that's it. I think you cannot do more without coding HTML with PHP
commands, which wouldn't be making a template anymore.
(*) Note that FOR and FOREACH are the only way for repeating a zone of a
template with basic PHP commands, and that's aleardy an algorithm.
While placing locators into a template shouldn't mean coding.
This is at the limit of template feature.
---------------------
Skrol29
www.tinybutstrong.com
---------------------
--- End Message ---
--- Begin Message ---
On Mon, 2005-05-02 at 13:02, Skrol29 wrote:
> Mattias Thorslund a �crit :
> > Then I wonder what makes skol29 think PHP's "basic template features"
> > are "too poor" to be used seriously? I think PHP's "basic template
> > features" are phenomenal.
>
> PHP is a nice and powerfull scripting langage oriented for Web
> developement. Let's look at what's it can do as a Template Engine.
>
> -> place data items in a template:
> HTML ... <?php echo $myvar ?> ... HTML
>
> -> repeat a zone with data items (*):
> HTML ... <?php for ($i=0;$i<=$iMax;$i++) { >
> HTML ... <?php echo $myvar[$i] ?>
> HTML ... <?php } ?>
>
> -> Hide or display a zone:
> HTML ... <?php if ($test) { ?>
> HTML ... <?php } ?>
>
> -> include an external part or subtemplate:
> HTML ... <?php include('subtemplate.php') ?> ... HTML
>
> And that's it. I think you cannot do more without coding HTML with PHP
> commands, which wouldn't be making a template anymore.
>
> (*) Note that FOR and FOREACH are the only way for repeating a zone of a
> template with basic PHP commands, and that's aleardy an algorithm.
> While placing locators into a template shouldn't mean coding.
> This is at the limit of template feature.
While I'm generally on the template side of the debate and more
specifically on the "use what's best for a given project" side of the
debate, I must argue that I see little problem with display logic in a
template, and that "foreach" is not an algorithm as much as it is an
expression. I mean sure there's some algorithm in the background to
facilitate the traversal, but then there's some algorithm in the
background to display these characters I've just typed and I'd hardly
say I'm programming to bring this response to you :)
Cheers,
Rob.
--
.------------------------------------------------------------.
| InterJinn Application Framework - http://www.interjinn.com |
:------------------------------------------------------------:
| An application and templating framework for PHP. Boasting |
| a powerful, scalable system for accessing system services |
| such as forms, properties, sessions, and caches. InterJinn |
| also provides an extremely flexible architecture for |
| creating re-usable components quickly and easily. |
`------------------------------------------------------------'
--- End Message ---
--- Begin Message ---
Hello,
I am using the following code.
<?php
$img_number = imagecreate(100,20);
$white = imagecolorallocate($img_number,255,255,255);
$black = imagecolorallocate($img_number,0,0,0);
$grey_shade = imagecolorallocate($img_number,204,204,204);
imagefill($img_number,0,0,$white);
$number = $_GET['text'];
Imagettftext($img_number, 10,0,4,15,$black,'arial.ttf',$number);
header("Content-type: image/jpeg");
$rotate = imagerotate($img_number, 270, 0);
imagejpeg($rotate);
?>
But I need to center the text in the image that is generated. As I am
using the same font and it is fixed at 10px I was thinking of doing
something like:
(Get Length of Text in Chars * Width of Average Char) DIV 2.
(Width of Image DIV 2) - Above = starting point on the x axis.
or can anyone think of a better way to do it?
Cheers
Richard
--- End Message ---
--- Begin Message ---
Hello Richard,
Monday, May 2, 2005, 4:47:42 PM, you wrote:
RC> But I need to center the text in the image that is generated. As I
RC> am using the same font and it is fixed at 10px I was thinking of
RC> doing something like:
RC> (Get Length of Text in Chars * Width of Average Char) DIV 2.
RC> (Width of Image DIV 2) - Above = starting point on the x axis.
RC> or can anyone think of a better way to do it?
There's nothing wrong with this method at all. When using a fixed
width font I would do it like this, it's pretty much perfect. When
using a True Type font I would use imagettfbbox() instead to get the
width of the text and then center that accordingly.
Best regards,
Richard Davey
--
http://www.launchcode.co.uk - PHP Development Services
"I do not fear computers. I fear the lack of them." - Isaac Asimov
--- End Message ---
--- Begin Message ---
I upgraded to php 5 from php 4.3.10 and now several classes are not working.
All I get is blank pages and no errors logged. If this has already been
discussed, please show me the door to the archives ;-)
+--------------------------------------------+
Mike Yrabedra
[EMAIL PROTECTED]
Your Mac Intelligence Resource
+--------------------------------------------+
W: http://www.macagent.com/
--- End Message ---
--- Begin Message ---
As far as I know PHP 4 classes are completely backwards compatible. with
PHP 5.
You might try looking at your config options, if register_globals went
from On to Off, that would cause your script to break.
I seriously doubt that anyone could help you without more information.
Chris
Mike wrote:
I upgraded to php 5 from php 4.3.10 and now several classes are not working.
All I get is blank pages and no errors logged. If this has already been
discussed, please show me the door to the archives ;-)
+--------------------------------------------+
Mike Yrabedra
[EMAIL PROTECTED]
Your Mac Intelligence Resource
+--------------------------------------------+
W: http://www.macagent.com/
--- End Message ---
--- Begin Message ---
Ok who's using mysqli? I'm moving over to the mysqli OO method. I'm
trying to perform an insert and having difficulty.
$sql = "INSERT INTO USERS (record_id, name_first, name_last) VALUES
(1, 'George', 'Dubbuyah')";
$mysqli->query($sql);
I have a followup SELECT that prints the rowcount so I can see if the
rows are increasing but they aren't. I figured this would be enough
for the insert, I even tried:
$mysqli->commit();
but their is no change. The SELECT is returning the correct amount of
rows. Any suggestions?
--
J
--- End Message ---
--- Begin Message ---
nevermind I got it :-/
My DATETIME was making me pay for something I did in a past life :P
John
On 5/2/05, JM <[EMAIL PROTECTED]> wrote:
> Ok who's using mysqli? I'm moving over to the mysqli OO method. I'm
> trying to perform an insert and having difficulty.
>
> $sql = "INSERT INTO USERS (record_id, name_first, name_last) VALUES
> (1, 'George', 'Dubbuyah')";
>
> $mysqli->query($sql);
>
> I have a followup SELECT that prints the rowcount so I can see if the
> rows are increasing but they aren't. I figured this would be enough
> for the insert, I even tried:
>
> $mysqli->commit();
>
> but their is no change. The SELECT is returning the correct amount of
> rows. Any suggestions?
>
> --
> J
>
--
J
--- End Message ---
--- Begin Message ---
Is it possible to use eregi instead of LIKE to filter mysql queries?
If so can someone do a quick example?
Many thanks,
R.
--- End Message ---
--- Begin Message ---
[snip]
Is it possible to use eregi instead of LIKE to filter mysql queries?
If so can someone do a quick example?
[/snip]
$sql = "SELECT foo, bar FROM table ";
$result = mysql_query($sql, $connection);
while($row = mysql_fetch_array($result)){
if(eregi('glorp', $row['foo']){
echo $row['bar'] . "\n";
}
}
Why you'd want to do it this way beats me, the overhead is a lot bigger
than doing it in the query.
--- End Message ---
--- Begin Message ---
Ross wrote:
Is it possible to use eregi instead of LIKE to filter mysql queries?
This would be in the MySQL manual.
http://dev.mysql.com/doc/mysql/en/pattern-matching.html
--
John C. Nichel
�berGeek
KegWorks.com
716.856.9675
[EMAIL PROTECTED]
--- End Message ---
--- Begin Message ---
Jay Blanchard wrote:
<snip>
Why you'd want to do it this way beats me, the overhead is a lot bigger
than doing it in the query.
</snip>
I _think_ he was asking if he could use some sort of pattern matching in
the query itself. Of course, it's Monday, and I may not have understood
the question at all. ;)
--
John C. Nichel
�berGeek
KegWorks.com
716.856.9675
[EMAIL PROTECTED]
--- End Message ---
--- Begin Message ---
[snip]
I _think_ he was asking if he could use some sort of pattern matching in
the query itself. Of course, it's Monday, and I may not have understood
the question at all. ;)
[/snip]
True. He was pretty specific about eregi though. Perhaps he'll let us
know when he does whatever it is he is doing.
--- End Message ---
--- Begin Message ---
you understood John
"John Nichel" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Jay Blanchard wrote:
> <snip>
>> Why you'd want to do it this way beats me, the overhead is a lot bigger
>> than doing it in the query.
> </snip>
>
> I _think_ he was asking if he could use some sort of pattern matching in
> the query itself. Of course, it's Monday, and I may not have understood
> the question at all. ;)
>
>
> --
> John C. Nichel
> �berGeek
> KegWorks.com
> 716.856.9675
> [EMAIL PROTECTED]
--- End Message ---
--- Begin Message ---
you understood John
"John Nichel" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Jay Blanchard wrote:
> <snip>
>> Why you'd want to do it this way beats me, the overhead is a lot bigger
>> than doing it in the query.
> </snip>
>
> I _think_ he was asking if he could use some sort of pattern matching in
> the query itself. Of course, it's Monday, and I may not have understood
> the question at all. ;)
>
>
> --
> John C. Nichel
> �berGeek
> KegWorks.com
> 716.856.9675
> [EMAIL PROTECTED]
--- End Message ---
--- Begin Message ---
[snip]
you understood John
[/snip]
Well, there you go. At least I gave a PHP answer on this, a PHP list.
;)
--- End Message ---
--- Begin Message ---
Jay Blanchard wrote:
[snip]
you understood John
[/snip]
Well, there you go. At least I gave a PHP answer on this, a PHP list.
;)
<snip>
You are my hero. ;)
--
John C. Nichel
�berGeek
KegWorks.com
716.856.9675
[EMAIL PROTECTED]
--- End Message ---
--- Begin Message ---
Had a look at it and much easier to use LIKE with wildcards. Was unsure
whether the query was case sensitive that is why I asked.
As it turns out it is not.
R
--- End Message ---
--- Begin Message ---
Ross wrote:
Had a look at it and much easier to use LIKE with wildcards. Was unsure
whether the query was case sensitive that is why I asked.
As it turns out it is not.
LIKE is case insensitive as well. Try casting to binary, this should work.
--- End Message ---
--- Begin Message ---
* Ross <[EMAIL PROTECTED]>:
> Had a look at it and much easier to use LIKE with wildcards. Was unsure
> whether the query was case sensitive that is why I asked.
Missed the earlier post, so I don't know if you're using MySQL or not
(other responses indicate you probably are). If you are, REGEXP in mysql
works quite nicely, and are relatively fast (though not as fast as LIKE)
when going through smaller sets of records -- I wouldn't use it for
large sets of records, however.
--
Matthew Weier O'Phinney | WEBSITES:
Webmaster and IT Specialist | http://www.garden.org
National Gardening Association | http://www.kidsgardening.com
802-863-5251 x156 | http://nationalgardenmonth.org
mailto:[EMAIL PROTECTED] | http://vermontbotanical.org
--- End Message ---
