PHP Tips

ini_set(‘display_errors’,1);

$con = mysql_connect(“192.168.1.100″,”codez”,”codez123″);

$database = mysql_select_db(“dealer_db”,$con);

$dirStateInput = $_GET['msg'];

$query = “SELECT * FROM dealerdetails WHERE state LIKE ‘”.$dirStateInput.”‘”;

$result = mysql_query($query,$con);

$num = mysql_num_rows($result);

$x = 1;

$output=”";

?>

<ul >

<?php

ini_set(‘display_errors’,1);

$con = mysql_connect(“192.168.1.100″,”codez”,”codez123″);

$database = mysql_select_db(“dealer_db”,$con);

$query =”SELECT DISTINCT(State) FROM dealerdetails”;

$result = mysql_query($query,$con);

while($State = mysql_fetch_array($result))

{

?>

<li ><a href=”dealers.php?msg=<?php echo $State['State']; ?>” class=”<?php if($dirStateInput==$State['State']){ echo “aboutnavactive”;}?>”><?php echo $State['State']; ?></a></li>

<?php }?>

</ul >