[mailto:[EMAIL PROTECTED]]
> Sent: Sunday, December 01, 2002 10:55 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Making field concat of autoincrement column and
> other values?
>
> I'm trying to make a customised session system (I could use PHP&
> I could concat when selecting, but it will be used in the where clause
> (it is neccesary to do it like this, I'm also md5ing it but forgot to
> mention that), and I'm guessing it would be bad for the server to have
> to concat and md5 in the where clause.
Yeah, I guess so. This all begs the que
> I'm trying to make a field in my database table a concat of an
> autoincrement value and some other values. I'm trying:
> insert into table set
> val1='val1',val2='val2',concatfield=concat('whatever',id,'whatever'),
> but it doesn't work. Is there another way, or will I have to update
the
> row
I'm trying to make a field in my database table a concat of an
autoincrement value and some other values. I'm trying:
insert into table set
val1='val1',val2='val2',concatfield=concat('whatever',id,'whatever'),
but it doesn't work. Is there another way, or will I have to update the
row directl