I have a field in my people table called 'client' and it stores a text string using varchar. But when I get the data from the table and print it using PHP it prints the number 1 for every record, but for all of the other data retrieved for the other fields in the same record it prints out the correct data.

For example, this is the query I am using:

PHP Code:

$peopleIds =& $db->query("SELECT * FROM people P, organisation O, organisationPeople OP WHERE P.personId = OP.personId AND O.organisationId = OP.organisationId AND OP.organisationId = '$_GET[id]' ORDER BY P.first_name ASC");
        checkDBError($peopleIds);
 
while($peopleIds->fetchInto($peopleId))
    {
          $peopleId['firstName']; // Prints the first name
          $peopleId['client']; // Prints 1 for every record
    } 


Any ideas?

Thanks,

I fixed this by changing the name of the client field to ISclient and it now displays the data stored for that field. I'm guessing client is a reserved word in MySQL?

No, but here is a great link to check in the future

http://dev.mysql.com/doc/refman/5.0/...ved-words.html

Maybe a type-0?

organisation

organization

I know I am American and we have a funny way of spelling so maybe it's different there.

Thanks for the link CharR, I didn't come accross that one I don't think it's the spelling of the word organisation because it prints out the data from that field as long as it's not called action I had a similar problem a few weeks ago when I called a field phone and then changed it to phoneNum and it worked lol maybe it's something to do with how the server is setup?

I'd suggest that "client" could have been an ambiguous field name because of the use of * instead of a fieldlist.

Originally Posted by chrishirst

I'd suggest that "client" could have been an ambiguous field name because of the use of * instead of a fieldlist.

Chris is probably right, if you had 2 or more tables with the "client" column in it then that would happen. Using SELECT * is almost always a bad idea.

chrishirst, ChadR the query did have SELECT * Thanks for your comments, I didn't know that using SELECT * could make problems

Select * is nothing but problems!