$Array maken met IF

Niemand meer een idee??

Post je script eens even en tussen code tags ^^

Search.php :


<?
require_once("conn.php");
require_once("includes.php");

$query = array();


if(!empty($_GET[c]))
{
$query[] = "re2_listings.CategoryID = '$_GET[c]' ";
}

if(!empty($_GET[s]))
{
$query[] = "re2_listings.SubcategoryID = '$_GET[s]' ";
}

if(!empty($_GET[AgentID]))
{
$query[] = "re2_listings.AgentID = '$_GET[AgentID]' ";
}

if(!empty($_GET[search_country]))
{
$query[] = "re2_listings.country = '$_GET[search_country]' ";
}

if(!empty($_GET[search_state]))
{
$query[] = "re2_listings.state = '$_GET[search_state]' ";
}

if(!empty($_GET[search_city]))
{
$query[] = "re2_listings.city = '$_GET[search_city]' ";
}

if(!empty($_GET[search_PropertyType]))
{
$query[] = "re2_listings.PropertyType = '$_GET[search_PropertyType]' ";
}

if(!empty($_GET[MinPrice]))
{
$query[] = "re2_listings.price >= '$_GET[MinPrice]' ";
}

if(!empty($_GET[MaxPrice]))
{
$query[] = "re2_listings.price <= '$_GET[MaxPrice]' ";
}

if(!empty($_GET[rooms1]))
{
$query[] = "re2_listings.rooms >= '$_GET[rooms1]' ";
}

if(!empty($_GET[rooms2]))
{
$query[] = "re2_listings.rooms <= '$_GET[rooms2]' ";
}

if(!empty($_GET[bath1]))
{
$query[] = "re2_listings.bathrooms >= '$_GET[bath1]' ";
}

if(!empty($_GET[bath2]))
{
$query[] = "re2_listings.bathrooms <= '$_GET[bath2]' ";
}

if(!empty($_GET[before]))
{
$MyDate = strtotime("-$_GET[before]");
$query[] = "re2_listings.DateAdded >= '$MyDate' ";
}

if(!empty($_GET[school]))
{
$query[] = "re2_listings.NearSchool = 'y' ";
}

if(!empty($_GET[transit]))
{
$query[] = "re2_listings.NearTransit = 'y' ";
}

if(!empty($_GET[park]))
{
$query[] = "re2_listings.NearPark = 'y' ";
}

if(!empty($_GET[ocean_view]))
{
$query[] = "re2_listings.OceanView = 'y' ";
}

if(!empty($_GET[lake_view]))
{
$query[] = "re2_listings.LakeView = 'y' ";
}

if(!empty($_GET[mountain_view]))
{
$query[] = "re2_listings.MountainView = 'y' ";
}

if(!empty($_GET[ocean_waterfront]))
{
$query[] = "re2_listings.OceanWaterfront = 'y' ";
}

if(!empty($_GET[lake_waterfront]))
{
$query[] = "re2_listings.LakeWaterfront = 'y' ";
}

if(!empty($_GET[river_waterfront]))
{
$query[] = "re2_listings.RiverWaterfront = 'y' ";
}

if(!empty($query))
{
$MyQuery = implode(" and ", $query);

$MyQuery = "and ".$MyQuery;
}


////////////////////////////////////////////////////////////
////////// order by

$order = array();

if(!empty($_GET[orderby]))
{
$MyOrder = explode("|", $_GET[orderby]);

while(list(,$ov) = each($MyOrder))
{
if($ov == "DateAdded")
{
$order[] = " re2_listings.DateAdded desc ";
}

if($ov == "Price")
{
$order[] = " re2_listings.Price asc ";
}

if($ov == "address")
{
$order[] = " re2_listings.address asc ";
}

}
}
else
{
if(!empty($_GET[p]))
{
$order[] = " re2_listings.Price asc ";
}

if(!empty($_GET[r]))
{
$order[] = " re2_listings.rooms asc, re2_listings.bathrooms asc, re2_listings.garage asc ";
}

if(!empty($_GET[city]))
{
$order[] = " re2_listings.city, re2_listings.address, re2_listings.state ";
}

}


if(count($order) > '0')
{
$MyOrder = implode(", ", $order);

}

if(empty($MyOrder))
{
$MyOrder = " order by re2_agents.PriorityLevel desc, re2_listings.DateAdded desc";
}
else
{
$MyOrder = " order by re2_agents.PriorityLevel desc, $MyOrder";
}


if(!empty($_GET[Start]))
{
$Start = $_GET[Start];
}
else
{
$Start = '0';
}

$ByPage = '5';

$q1 = "select * from re2_listings, re2_agents, re2_priority where re2_listings.AgentID = re2_agents.AgentID and re2_agents.PriorityLevel = re2_priority.PriorityLevel and re2_agents.AccountStatus = 'active' $MyQuery $MyOrder limit $Start, $ByPage ";

$qnav = "select * from re2_listings, re2_agents where re2_listings.AgentID = re2_agents.AgentID $MyQuery";

$r1 = mysql_query($q1) or die(mysql_error());
$lrows = mysql_num_rows($r1);



if($lrows > '0')
{
$ListingTable .= "<table bgcolor=#E6E6E6 align=center width=550 border=0 frame=hsides rules=rows cellspacing=0>\n";
$ListingTable .= "<tr><td height=29 colspan=6>kopje dan</td></tr>";

// HIER DE KOPREGEL...
// $ListingTable .= "<tr><td colspan=6>KOPREGELTJE</td></tr>";
// $ListingTable .= "<tr><td colspan=7>hiers2</td><td></td><tr></tr>";
// $ListingTable .= "<tr><td colspan=6>startbeeld boven</td></tr>";
while($a1 = mysql_fetch_array($r1))
{
$ListingTable .= "<td height=26 valign=bottom colspan=6 background=images/src_image/head_550.gif><img src=images/trans_spacer_10.png><span class=src_head>$a1[country] $a1[city], $a1[state], $a1[address] </span></td>";
$ListingTable .= "<tr onMouseOver=\"this.style.background='#ADC4E9'; this.style.cursor='hand'\" onMouseOut=\"this.style.background='#E6E6E6'\" onClick=\"window.open('info.php?id=$a1[ListingID]', '_top')\">\n\t";

if($a1[PriorityLevel] > '1')
{
$sub = "<span class=RedLink>^{$a1[PriorityName]}</span>";
}

$ListingTable .= "\n\t<td bgcolor=#D2D2D2><img src=images/trans_spacer_10.png width=3></td><td width=130 height=98>";

// if(!empty($a1[image]))
// {
$ListingTable .= "<img src=\"re_images/$a1[image]\" width=130 height=98>"; // afbeeldingsgrootte in de resultpagina
//

// }

if(!empty($a1[image]))
{
$MyImages = explode("|", $a1[image]);


$ShowInfo .= "<table valign=top align=center width=\"500\" height=50>\n<tr>\n\t<td align=center valign=top width=\"500\" height=50>";


while(list(,$v) = each($MyImages))
{
$ShowInfo .= "<a href=\"info.php?id=$_GET[id]&i=$_GET[i]&f=$v\"><img src=\"re_images/$v\" width=50 height=50 border=0></a>&nbsp;&nbsp;&nbsp;\n\n\t";
}

$ShowInfo .= "</table><hr size=1 width=\"95%\" color=#336699><br>";


if(!empty($f))
{
$ShowInfo .= "<center><img src=\"re_images/$f\" width=50 height=50></center><br>";
}
else
{
$ShowInfo .= "<center><img src=\"re_images/$MyImages[0]\"></center><br>";
}

}
else
{
$ShowInfo .= "<br><center><img src=\"no_image.gif\"></center>";
}
//

include('iconselect.php'); // laadt de iconlijst in (met if statement! in de $icons)



//
$ListingTable .= "</td>\n\t";
        $ListingTable .= "<td width=305>".$a1['city'].", ".$a1['state'].", ".$a1['address'].$sub.$icons.$a1['LakeWaterfront'].$a1['NearPark']."</td>\n\t";
        $ListingTable .= "<td width=80>".$a1['rooms']." bedrooms, ".$a1['bathrooms']." ba";

        $MyPrice = number_format($a1[Price], 2, ".", ",");

        $ListingTable .= "</td>\n\t<td align=center width=100><b>$$MyPrice</td><td bgcolor=#D2D2D2><img src=images/trans_spacer_10.png width=3></td><tr>\n";
        $ListingTable .= "</tr>\n";
// image regels
$ListingTable .= "<tr><td colspan=6>einbeeld footer</td></tr>";
// $ListingTable .= "<tr><td colspan=6 height=26 background=images/src_image/ShowResults_01.gif>startbeeld header</td></tr>";
}

// FOOTER gevonden text
// $ListingTable .= "<tr><td colspan=7>hoihier</td></tr>";
$ListingTable .= "</table>";

$rnav = mysql_query($qnav) or die(mysql_error());
$rows = mysql_num_rows($rnav);

if($rows > $ByPage)
{
$ListingTable .= "<br><table align=center width=510>";
$ListingTable .= "<td align=center><font face=verdana size=2> | ";

$pages = ceil($rows/$ByPage);

for($i = 0; $i <= ($pages); $i++)
{
$PageStart = $ByPage*$i;

$i2 = $i + 1;

if($PageStart == $Start)
{
$links[] = " <span class=RedLink>$i2</span>\n\t ";
}
elseif($PageStart < $rows)
{
$links[] = " <a class=BlackLink href=\"search.php?Start=$PageStart&c=$_GET[c]&s=$_GET[s]&AgentID=$_GET[AgentID]&search_city=$_GET[search_city]&search_state=$_GET[search_state]&search_country=$_GET[search_country]&search_PropertyType=$_GET[search_PropertyType]&MinPrice=$_GET[MinPrice]&MaxPrice=$_GET[MaxPrice]&rooms1=$_GET[rooms1]&rooms2=$_GET[rooms2]&bath1=$_GET[bath1]&bath2=$_GET[bath2]&before=$_GET[before]&school=$_GET[school]&transit=$_GET[transit]&park=$_GET[park]&ocean_view=$_GET[ocean_view]&lake_view=$_GET[lake_view]&mountain_view=$_GET[mountain_view]&ocean_waterfront=$_GET[ocean_waterfront]&lake_waterfront=$_GET[lake_waterfront]&river_waterfront=$_GET[river_waterfront]&city=$_GET[city]&p=$_GET[p]&r=$_GET[r]\">$i2</a>\n\t ";
}
}

$links2 = implode(" | ", $links);

$ListingTable .= $links2;

$ListingTable .= "| </td>";

$ListingTable .= "</table><br>\n";

}
}
else
{
$ListingTable = "<br><br><center>No results was found!</center>";
}

require_once("templates/HeaderTemplate.php");
require_once("templates/SearchTemplate.php");
require_once("templates/FooterTemplate.php");

?>


en de include die ik meende te gaan gebruiken... :

<?

if($a1['LakeWaterfront'] === 'y' )
{
$icons .= <img src=images/icons/1.gif>;
}
if($a1['NearPark'] === 'y')
{
$icons .= <img src=images/icons/2.gif>;
}
?>

Die include is zowieso fout..
je moet strings wel tussen quotes of haakjes zetten.

<?
$a1['LakeWaterfront'] === 'y' )
{
$icons .= '<img src="images/icons/1.gif">';
}
if($a1['NearPark'] === 'y')
{
$icons .= '<img src="images/icons/2.gif">';
}
?>

hoi thijs

ik heb je code letterlijk in de include gezet...

<?
$a1['LakeWaterfront'] === 'y' )
    {
        $icons .= '<img src="images/icons/1.gif">';
    }
if($a1['NearPark'] === 'y')
    {
        $icons .= '<img src="images/icons/2.gif">';
    }
?>



Parse error: syntax error, unexpected T_STRING in /home/.fitz/snewpers/re.domain.name/iconselect.php on line 2

Ja er moest nog if voor vergeten te kopieren.
Maar kijk volgende keer eerst even eens goed naar je regels waar de fout zich voordoet en probeer te analyseren wat het zou kunnen zijn.

<?
if($a1['LakeWaterfront'] === 'y' )
{
$icons .= '<img src="images/icons/1.gif">';
}
if($a1['NearPark'] === 'y')
{
$icons .= '<img src="images/icons/2.gif">';
}
?>

sorry ja

ik zag het toen ik op plaats bericht klikte sorry

<?
echo "$naam"; // FOUT

echo $naam; // Goed

echo "Ik heet $naam blabla"; // FOUT

echo "Ik heet ".$naam." blabla"; // GOED
?> 

Hier ben ik het voor een groot deel mee eens, maar

echo "Ik heet $naam blabla"; is niet fout, alleen niet ideaal

EN

echo "Ik heet ".$naam." blabla"; vind ik minder goed

Ik doe:

echo 'Ik heet ' . $naam . ' blabla'; ja, dat maakt uit.

Je snapt het wel als je dit probeert.

echo 'Ik heet $naam blabla';

is het nou gelukt?? :P

lol nee...

krijg met de nieuwe code alleen maar parse errors (sorry thijs).

Wat ik tot nu toe heb is dat ie de eerste IF gedeeltelijk doet...

het zoekresultaat laat 5 rows zien, waanvan de eerste voldoet aan bij IF's (dus 2 maal de 'y'). De tweede row heeft alleen de eerste IF op yes staan, alle andere heben beide IF's op 'n' staan en zouden dus niets moeten laten zien.

het resultaat is echter:

row 1 (y + y) : laat alleen ikoon zien van de tweede IF
row 2 (y + n) : laat corect het eerste ikoon zien
row 3 (n + n) : laat hetzelfde resultaat zien als de laatste met een 'y', dus ook het eerste ikoon
row 4 en vijf zijn idem aan row 3....

ik snap het niet!!! HELP!!