Re: [PHP] small and big letter in WHERE statement

[Angel Freire]

I'm guessing that you mean in a SQL sentence.

Well, depending on what SQL engine're you using it's case sensitive or
not.

MySQL don't take diferent case as diferent string, thats why is the
'binary' date type.

In that case you have two alternatives, or change the field type to
binary, or cast it in the where statement.

El lun, 14-06-2004 a las 14:36, QT escribió:
> Dear Sirs,
> 
> When I use where statement, I see that there is no meaning small and big
> letter. Without looking small caps or big, result comes back. But I want to
> match only small letters. How can I do that?
> 
> Best REgards

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] connecting remote host ..

[Angel Freire]

Reloadind database isn't necesary, a flush privileges should be ok.

El lun, 14-06-2004 a las 04:32, Manoj Nahar escribió:
> Hi Gowthaman,
> 
> For mysql to allow remove connecivity u have to make entry in mysql
> database in tables db, user and host giving the IP of remote PC from
> which u want to connect and username and password then reload the
> database and It will all work
> 
> Manoj
> 
> 
> On 14 Jun 2004 10:25:48 +0530, gowthaman ramasamy <[EMAIL PROTECTED]> wrote:
> > 
> > hello list,
> > My php script works fine with local mysql database.
> > however when try to use some remote database it fails and gives follwing
> > error ..
> > 
> > Warning: mysql_connect(): Unknown MySQL Server Host 'http' (2) in
> > /usr/local/apache2/htdocs/gowtham/forphp/db_qry_4repeat.php on line 86
> > 
> > the mysql_connect() syntax is as follows ..
> > $db=mysql_connect("192.168.1.109", "root", "password");
> > 192.168.1.109 is the ip (internal IP on LAN) of the machine hosting the
> > database.
> > 
> > thanx a lot in advance ..
> > 
> > --
> > Ra. Gowthaman,
> > Graduate Student,
> > Bioinformatics Lab,
> > Malaria Research Group,
> > ICGEB , New Delhi.
> > INDIA
> > 
> > Phone: 91-9811261804
> >   91-11-26173184; 91-11-26189360 #extn 314
> > 
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> > 
> >

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] cookie question...

[Angel Freire]

First I recomend you to read this page:
http://ar.php.net/manual/en/function.setcookie.php

For that example the code should be:

$_COOKIE['link1']

El sáb, 19-06-2004 a las 19:47, water_foul escribió:
> how do i read a cookie created by this code
> setcookie('link1',blah,time()+3600,'/');

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php