在Where子句中使用数组

Question

So what I need to do is find in my tables where id = id and name = name. I have tried this with no success.

$sql="SELECT * FROM $mysqltable WHERE id='$id' && name='$name'"

EDIT I found that I was missing a } bracket below this and the above code does work :/ Thank you everyone.

Answer 1

This is how i would have done it: Also try entering the table name instead of a variable.

$sql = "SELECT * From $mysqltable WHERE id='$id' AND name='$name'";

$result = mysql_query($sql) or die(mysql_error());