Re: concat question
| From: | Miguel Cruz | Date: | Fri, 05 Jul 2002 07:27:57 +0000 |
| Subject: | Re: concat question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-105584@lists.php.net to get a copy of this message | ||
On Fri, 5 Jul 2002, Matthew K. Gold wrote:
> I'm having trouble including a concat column in my php. Here's the line
> I've tried to use:
>
> $query = "Select CourseNumber, CourseTitle, concat(ProfFName, /" /",
> ProfLName), InstitName, DiscName, Format from course, disc, instit, prof
> where course.DiscID = disc.DiscID and course.InstitID = instit.InstitID and
> course.ProfID = prof.ProfID order by CourseTitle";
>
> I think it has something to do with the double quotes and the escape
> characters I'm using...I'm able to show ProfFName and ProfLName
> separately...
You need to use backslashes ( \ ) and not regular slashes ( / ) to escape
quotes.
miguel