Member Avatar for phpDave

Hi,
I trying to user 3 AND operators in one Select Statement. It's not working.
Is this even posable.
If not, any suggestions?
Here is the code:

$query_Recordset1 = "SELECT * FROM user JOIN message WHERE message.user2 = '$user2' AND message.user_id = '$user2' AND email = '$email'";

Thanks!

  • 3 Contributors
  • 2 Replies
  • 86 Views
  • 4 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for broj1

Multiple ANDs are legitimate and should work OK. However usually tables are joined on some matching fields so your query should also contain ON keyword. Do you get any errors running the query in phpmyadmin?

Member Avatar for pritaeas

SELECT * FROM user JOIN message

A JOIN requires an ON to link both tables correctly.

Edited by pritaeas
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.