Turned out to be a data problem after all - a single, unreadable (at
least to me) just after each linefeed character.
That explains everything.
To all those who helped out, my sincerest thanks.
Brett
>I just tested the following on a table I have with a "name" field
>(prj_id in my case):
>
>
> Unfortunately, the problem is not in any one script. It is a
> universally repeatable error and happens even when using MySQL in the
> command line.
>
> I tried the suggested SQL query below, but it returned the same
> result as before. (Only the first record.)
> SELECT name,keywords,descr
I just tested the following on a table I have with a "name" field (prj_id
in my case):
select prj_id from master_projects where prj_id like "R%" LIMIT 0, 30;
Works perfectly in the mysql shell;
>Unfortunately, the problem is not in any one script. It is a universally
>repeatable error and
Unfortunately, the problem is not in any one script. It is a
universally repeatable error and happens even when using MySQL in the
command line.
I tried the suggested SQL query below, but it returned the same
result as before. (Only the first record.)
SELECT name,keywords,description from da
Is it only pulling up the first record in a script that you are writing
(like in a PHP script) or does it also exhibit this behavior if you enter
your query from the mysql command line interface?
If it is the former, I would imagine there is a problem with your script.
HTH
Sam Masiello
Softwar
