Re: RE: [PHP] Newbie Question
| From: | Bill Adams | Date: | Thu, 08 Nov 2001 23:18:08 +0000 |
| Subject: | Re: RE: [PHP] Newbie Question | ||
| References: | 1 | Groups: | php.db php.general |
| Request: | Send a blank email to php-db+get-14163@lists.php.net to get a copy of this message | ||
Jay Fitzgerald wrote:
> displays fine now -- thanks for that help so far -- but the problem now
> (this may be normal, but I am not sure) is when I connect to the db and
> "select * from jobs;" the db is writing the entries like this:
>
> ===================
> mysql> select * from jobs;
>
> +----+----------+----------+--------+---------+---------------------------------+----------+----------+--------+----------+
> | id | position | opendate | salary | appdate |
> duties | examples | training | skills | benefits |
>
> +----+----------+----------+--------+---------+---------------------------------+----------+----------+--------+----------+
> | 1 | test | test | test | test | 1
> 2
> 3
>
> 4
> 5
> 6
>
> 7
> 8
> 9 | test | test | test | test |
>
> +----+----------+----------+--------+---------+---------------------------------+----------+----------+--------+----------+
> ===================
>
> is this in fact normal?
Yes.
Since you have \n (and possibly \t, others) in the field, mysql is displaying them on the select.
b.