[SOLVED] mysql_query WHERE

[All4172]

What I'm wanting to do, is set up a mysql_query but based on two WHERE's. 

 

$result = mysql_query("SELECT * FROM article
WHERE visiblity LIKE 'notlive'");

 

Then if I have a $result from that query, I want to get a value in that same row from another cell called date but in the same row.  Is there a way to set up WHERE to say visiblity like 'notlive' get value from epoch date in table DATE.

[Barand]

To clarify, show us your table structures/definitions, some sample data and what you expect as output.

[All4172]

Table = article

 

fields = id, visiblity, date

 

idvisibiltydate

1live1181639193

2notlive1173638815

 

Based on the info above, if field visiblity is = notlive then I want to retrieve the data from date.  Hope that clarifies

[artacus]

This isn't two queries, its just two where clauses. You can have any number of where clauses and separate them with AND or OR as appropriate. Use ()'s when using OR's.

 

eg.

SELECT

FROM article

WHERE visibility = 'notlive' AND `date` BETWEEN ... whatever

[All4172]

The AND is what I needed.  For those that may find this later on when searching.  I ended up doing this:

 

$result = mysql_query("SELECT * FROM article
WHERE visiblity LIKE 'notlive' AND date>0");

while($row = mysql_fetch_array($result))
  {
  echo $row['date'];
  echo "<br />";
  }