SQL problem

Oops! The perils of not maximizing the window - I did not see leakim971's answer. My apologies....

where does name come from?, you must specify where name comes from ie m.name else it won't work

I also noticed you got a field_1 (dunno why you named it that but hey) that also needs a table to read from.

The reason for this is because you have a join so the field names no longer associate themselves with one table and unless MySQL is told which table to read from for the fields it will read nout. This always annoys me when I make these errors I wish MySQL had better error reporting

Third post, just a code snippet, this is leakim's solution modified a little so accomodate the table naming:

$converge_info = $this->query("select m.member_id, m.member_group_id, m.email,
        m.members_pass_hash, m.members_pass_salt, m.field_1 as chapter from ibf_members m
                join ibf_pfields_content pf on pf.member_id = m.member_id  
                where m.name = '$this->username'");

                                              

1:
2:
3:
4:

It's not the sql because I have tested the sql and it returns the values that I want. There is something going on with the syntax for some reason. Maybei it's the php version?

The sql is returning data because with all the other validation I have arond the code I verified that it seeing if a login is incorrect via username and password.

I tested the sql on my server where the code is running. From the database the query returns rows just fine.

This is what I have right now and the sql works. The error is coming from line 1 of the sql command:

$converge_info = $this->query("SELECT m.member_id, m.member_group_id, m.email,
     m.members_pass_hash, m.members_pass_salt, field_1 as chapter from ibf_members m
     join ibf_pfields_content pf on pf.member_id = m.member_id  
     where m.name = \"" . 	$this->username ."\"");

                                              

1:
2:
3:
4:

I really puzzled now, That works perfect, just quickly made up the table and it works gives me the data in php fine:

$converge_info = "SELECT m.member_id, m.member_group_id, m.email,
     m.members_pass_hash, m.members_pass_salt, field_1 as chapter from ibf_members m
     join ibf_pfields_content pf on pf.member_id = m.member_id  
     where m.name = \"" .       $username ."\""; 
$result = $db->getRow($converge_info);

                                              

1:
2:
3:
4:
5:
6:

can you by any chance show the rest of the function/page?, I'm making a wild guess but I think it could be:

a. broken function having a knock on effect
b. you look like your using an abstract layer, maybe you are fetching data from the resulting query incorrectly. If your using php::DB then making an incorrect loop to scroll through an query function can result in a SQL error on that query...

If the data is grabbing fine when you run the query in say, phpmyadmin or console then my only guess is that its gotta be the php around the function.

Ok, I figure it. There was another column name that I needed to change. What happen was that we just upgraded our invision board and the new version merged some tables make our custom app not to work right. Mis named a couple of columns. Thanks for the help people!!

of course there is also:

c. You accidentally have changed $this->username to an object instead of say a string. Replace your $this->username with just a string variable of something like I have if that don't work you know you haven't accidentally assigned it to an object. So the last line would now equal (or something close):

where name = 'bob'");

I know it seems something that impossible but sometimes it does happen.