Member Avatar for davy_yg

// this works

sql = "SELECT * FROM image_upload WHERE location='article' AND image_id='7'";

// this works

sql = "SELECT * FROM image_upload WHERE location='article' AND image_id='9'";

// this does not work

sql = "SELECT * FROM image_upload WHERE location='article' AND image_id='7' AND image_id='9'";

// I wonder why?

  • 2 Contributors
  • 1 Reply
  • 149 Views
  • 4 Minutes Discussion Span
  • Latest Post Latest Post by DaveAmour
Member Avatar for DaveAmour

Because image_id cannot be both 7 and 9 right?

What is it you want to achieve?

Maybe

sql = "SELECT * FROM image_upload WHERE location='article' AND (image_id='7' Or image_id='9')";

Edited by DaveAmour because: Extra help
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.