[SOLVED] MySql Select WHERE something & something else.

[Michdd]

How do I use a MySql Query that selects from the database where 2 separate things hold true.

[redarrow]

 

Trie this from a database but using 2 tables and field_names.

<?php

// database connection...

$sql="select * from table1 as a,table2 as b where a.what_ever='true' and b.what_ever='true'";

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

while($data=mysql_fetch_assoc($res)){

echo $data['what_ever'];
}

?>

[Michdd]

 

Trie this from a database but using 2 tables and field_names.

<?php

// database connection...

$sql="select * from table1 as a,table2 as b where a.what_ever='true' and b.what_ever='true'";

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

while($data=mysql_fetch_assoc($res)){

echo $data['what_ever'];
}

?>

I want to do something that will select something from the DB where a name='something' and somethingelse>'29'

[corbin]

SELECT * FROM table WHERE name = 'something' AND somethingelse > 29;