MySQL WHERE Clause Help

[DriedSponge]

I know this is probably really simple but I'm having troubble figuring out how to select a row from a MySQL db where multiple columns equal a certain value. Here's what I have, I'm using PHP PDO:

$query = SQLWrapper()->prepare("SELECT postid,Images FROM ImagePost WHERE gid = :gid, Title = null, Category = null,Caption=null");

Any help would be apprciated! Thank you!

[elpiop]

16 minutes ago, DriedSponge said:

I know this is probably really simple but I'm having troubble figuring out how to select a row from a MySQL db where multiple columns equal a certain value. Here's what I have, I'm using PHP PDO:

$query = SQLWrapper()->prepare("SELECT postid,Images FROM ImagePost WHERE gid = :gid, Title = null, Category = null,Caption=null");

Any help would be apprciated! Thank you!

Use AND instead of comma

SELECT
  postid,
  Images
FROM
  ImagePost
WHERE
  gid = :gid
  AND Title = null
  AND Category = null
  AND Caption = null

 

[DriedSponge]

45 minutes ago, elpiop said:

Use AND instead of comma

SELECT
  postid,
  Images
FROM
  ImagePost
WHERE
  gid = :gid
  AND Title = null
  AND Category = null
  AND Caption = null

 

Perfect, thank you!