Filter recordset

[dmrgraphics.com]

I have a table with 2 fields. I want to display a recordset on a page that displays the results of field 2. That is easy, I have done that, however I want to change the result to display the value from field 2 only if field 1 contains a certain value.

My recordset code looks like this:

<?php echo $row_Recordset1['field2']; ?></p>

This is probably really easy but I am having some trouble.

Thanks,
Dave

[JShor]

Try something like this:

<?php

if($row_Recordset1['field1'] == '**ENTER_CERTAIN_VALUE**') {

echo $row_Recordset1['field2']."</p>";

}

?>

HTH

[forum_amnesiac]

The other approach to this would be to do it in your Select statement.

$value="selection criteria";
$row = mysql_query("SELECT field2 FROM mytable WHERE field1=$value"); 

This way you only get the records that match the required selection criteria

[dmrgraphics.com]

Thanks, that worked good. What I need to do now is display a different set of values from the same table. One line shows the results of field 2 when field 1 is equal to one value. The next line will show the results of field 2 when field 1 is equal to a different value. My thought is that I would do this:

<?php

if($row_Recordset1['department'] == 'Childrens Church') {

echo $row_Recordset1['names']."</p>";

}

?>

 <?php

if($row_Recordset1['department'] == 'Welcome Ministry') {

echo $row_Recordset1['names']."</p>";

}

?>

This is not working for some reason?

[forum_amnesiac]

Try this

<?php

if($row_Recordset1['department'] == 'Childrens Church') {

echo $row_Recordset1['names']."</p>";

}else if($row_Recordset1['department'] == 'Welcome Ministry') {

echo $row_Recordset1['names']."</p>";

}

?>

[dmrgraphics.com]

It is still only showing the one set of records "Childrens Church".

[JShor]

This should be working ...

<?php

if($row_Recordset1['department'] == 'Childrens Church') {

echo $row_Recordset2['names']."</p>";

}

if($row_Recordset2['department'] == 'Welcome Ministry') {

echo $row_Recordset1['names']."</p>";

}

?>

is it not?

[dmrgraphics.com]

I noticed in th reply you RecordSet1 & RecordSet2. How should I create those record sets?

[JShor]

I meant this:

<?php

if($row_Recordset1['department'] == 'Childrens Church') {

echo $row_Recordset1['names']."</p>";

}

if($row_Recordset1['department'] == 'Welcome Ministry') {

echo $row_Recordset1['names2']."</p>";

}

?>

... changing names2 to whatever field you want to have displayed.

[dmrgraphics.com]

Yes, that is working now, one thing that I noticed I had not done is, I didn't have the dynamic text inside a repeat region, so it was just displaying the first result.

Thanks so much for your help,
Dave