PHP & MYSQL Problem (Should be simple) Help Needed

BuLLDoG · 10-29-2009, 04:06 PM

Hi everyone,

I have two tables I want to access data from:

$tbl_name = itp
$tbl_name2 = s_contact

I have a query like this:

PHP Code:

  $query = "SELECT * ".

 "FROM $tbl_name, $tbl_name2 ".

    "WHERE $tbl_name.position = $tbl_name2.pos ".

    "AND $tbl_name2.username =".

    " '".

    "$usern".

????: NamePros.com http://www.namepros.com/programming/619866-php-mysql-problem-should-simple-help.html
    "'"

This query works perfectly, but I want to improvise on this query and include a NOT LIKE statement.

So for example, in the s_contact I have a field called 'completed_itp' it includes row ids for example it looks like this:

35, 12, 2, 5

I want my query now to include a statement to say don't bring back itp.id if they are included in the s_contact.completed_itp.

Hope you understand what I mean.

Thanks in advance, any help on this would be greatly appreciared

**Eric** · 10-29-2009, 04:40 PM

PHP Code:

  $query = "
    SELECT * FROM $tbl_name, $tbl_name2
????: NamePros.com http://www.namepros.com/showthread.php?t=619866
    WHERE $tbl_name.position = $tbl_name2.pos 
        AND $tbl_name2.username = '$usern'
        AND $tbl_name2.completed_itp NOT IN(35,12,2,5)
";

http://dev.mysql.com/doc/refman/5.0/...unction_not-in

BuLLDoG · 10-29-2009, 04:45 PM

Hey thanks Eric for your response, but that is typing the NOT IN values in manually. Although, l think you have pointed me into the right direction.

Cheers

amoeba · 10-30-2009, 05:29 PM

Can you post your table structure with some sample data (e.g. query browser screenshot)? I think there might be some confusion about what exactly you're trying to do.

10-29-2009, 04:06 PM	THREAD STARTER #1 (permalink)
BuLLDoG NamePros Regular Join Date: Aug 2003 Location: England Posts: 934	PHP & MYSQL Problem (Should be simple) Help Needed Hi everyone, I have two tables I want to access data from: $tbl_name = itp $tbl_name2 = s_contact I have a query like this: PHP Code: `$query = "SELECT * ". "FROM $tbl_name, $tbl_name2 ". "WHERE $tbl_name.position = $tbl_name2.pos ". "AND $tbl_name2.username =". " '". "$usern". ????: NamePros.com http://www.namepros.com/programming/619866-php-mysql-problem-should-simple-help.html "'"` This query works perfectly, but I want to improvise on this query and include a NOT LIKE statement. So for example, in the s_contact I have a field called 'completed_itp' it includes row ids for example it looks like this: 35, 12, 2, 5 I want my query now to include a statement to say don't bring back itp.id if they are included in the s_contact.completed_itp. Hope you understand what I mean. Thanks in advance, any help on this would be greatly appreciared __________________ Free iPhone \| Free Facebook Likes

10-29-2009, 04:40 PM	#2 (permalink)
Eric Tech Support Join Date: Mar 2005 Posts: 4,944	PHP Code: `$query = " SELECT * FROM $tbl_name, $tbl_name2 ????: NamePros.com http://www.namepros.com/showthread.php?t=619866 WHERE $tbl_name.position = $tbl_name2.pos AND $tbl_name2.username = '$usern' AND $tbl_name2.completed_itp NOT IN(35,12,2,5) ";` http://dev.mysql.com/doc/refman/5.0/...unction_not-in

10-29-2009, 04:45 PM	THREAD STARTER #3 (permalink)
BuLLDoG NamePros Regular Join Date: Aug 2003 Location: England Posts: 934	Hey thanks Eric for your response, but that is typing the NOT IN values in manually. Although, l think you have pointed me into the right direction. Cheers __________________ Free iPhone \| Free Facebook Likes

10-30-2009, 05:29 PM	#4 (permalink)
amoeba NamePros Regular Join Date: Sep 2005 Location: ~$ Posts: 656	Can you post your table structure with some sample data (e.g. query browser screenshot)? I think there might be some confusion about what exactly you're trying to do. __________________ [ syzygy ] [ free public DNS service ]

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)