Hi. My server has MySQL 3.23.58 installed, and I just migrated over from
RedHat 7.2 to ES 3.0.
Previously I was using the BINARY command to execute a case-sensitive search
for member user names like this:
SELECT * FROM mem WHERE BINARY user_name = 'SomeOne';
I now get an error from MySQL sta
Anyone ???
vv
> From: [EMAIL PROTECTED] (Monty)
> Newsgroups: php.db
> Date: Sun, 04 Jan 2004 13:48:56 -0500
> To: [EMAIL PROTECTED]
> Subject: BINARY not recognized ??
>
> Hi. My server has MySQL 3.23.58 installed, and I just migrated over from
> RedHat 7.2 to E
Date: Tue, 6 Jan 2004 05:22:26 +0800
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Re: BINARY not recognized ??
>
> On Tuesday 06 January 2004 03:51, Monty wrote:
>> Anyone ???
>
> www.mysql.com ???
>
> --
> Jason Wong -> Gremlins Associates -> www.grem
BINARY and
user_name in my statement.
> From: [EMAIL PROTECTED] (Cpt John W. Holmes)
> Organization: U.S. Army
> Reply-To: "CPT John W. Holmes" <[EMAIL PROTECTED]>
> Newsgroups: php.db
> Date: Mon, 5 Jan 2004 16:29:22 -0500
> To: <[EMAIL PROTECTED]>, &quo
Never mind, problem solved. I found the answer somewhere else - NOT the
MySQL online docs. They are really horrible!
> From: [EMAIL PROTECTED] (Jason Wong)
> Organization: Gremlins Associates
> Newsgroups: php.db
> Date: Tue, 6 Jan 2004 05:22:26 +0800
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-D
Because you guys are much smarter!! :)
> From: [EMAIL PROTECTED] (Jason Wong)
> Organization: Gremlins Associates
> Newsgroups: php.db
> Date: Tue, 6 Jan 2004 06:04:31 +0800
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Re: BINARY not recognized ??
>
> On Tuesday 06 J
what worked: WHEN BINARY(user_name)='Someone'
> From: [EMAIL PROTECTED] (Cpt John W. Holmes)
> Organization: U.S. Army
> Reply-To: "CPT John W. Holmes" <[EMAIL PROTECTED]>
> Newsgroups: php.db
> Date: Mon, 5 Jan 2004 17:05:11 -0500
> To: <[EMAIL PROTECTE
Thanks a lot for any input or feedback! I'm completely lost!
Monty
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
I have an Image table in a MySQL database that will be used to store the
location of all images used on my site. Some images will relate to an
Article table (article.id) and some images may relate to a Member table
(member.id).
As it's possible that there may be an article.id that is the sam
tabase with the content
itself?
Hope this makes some sense. Just trying to figure out the best way to tackle
this. All input is appreciated!
Monty
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
etter if all content was centrally
stored in one table to make searches better/easier...or am I expecting too
much from just one content table?
What to do, what to do!
> From: [EMAIL PROTECTED] (Court Shrock)
> Newsgroups: php.db
> Date: Thu, 7 Mar 2002 11:31:20 -0800
> To:
Hi Natalie, no, PDFs won't work. I need to display the content as an HTML
page.
> From: [EMAIL PROTECTED] (Natalie Leotta)
> Newsgroups: php.db
> Date: Thu, 7 Mar 2002 14:32:57 -0500
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] Best way to store/retrieve content??
>
> Could you use PDFs?
>
>
Is it possible to attach an image to a post here in order to better
illustrate a point? If so, how?? Thanks!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
all articles in one data table so searches can
be easily done on all articles.
Thanks!
Monty
> From: [EMAIL PROTECTED] (Peter Lovatt)
> Newsgroups: php.db
> Date: Thu, 7 Mar 2002 20:11:00 -
> To: "Monty" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
> Subj
ragraph
of text under of text under of text under
the image. the image. the image.
If this is a doable and good way to go, then my next question is, which PHP
string function would be the best to use for parsing custom codes (like
[IMG=) into actual HTML codes?
Thanks!
Is there a way to re-set the internal counter that automatically increments
"auto_increment" fields? While testing an app, I added a lot of test records
that I've deleted, so, I'd like to reset the counter back to the beginning
now.
Thanks.
--
PHP Database Mailing List (http://www.php.net/)
To
ate: Thu, 25 Jul 2002 14:41:49 +0800
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Resetting MySQL Auto_Index - How?
>
> On Thursday 25 July 2002 13:34, Monty wrote:
>> Is there a way to re-set the internal counter that automatically increments
>> "auto_increment"
fields into two tables. I
don't expect to have huge numbers of member records, perhaps under 5,000 to
start with.
Thanks!
Monty
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Is there an easy way to have MySQL return someone's age based on their
birthdate? For some reason I just can't figure this one out.
Thanks!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Is it more efficient to store record IDs in a MySQL database as an Integer
or a String? I like string IDs better because you can create meaningful
names, but, not sure if this means the DB has to work harder or not.
Thanks!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visi
20 matches
Mail list logo