Output Data from MYSQL...HELP!!!!

[kartikayg]

Hi ..i m new to php and need some help. What i am trying here is to sort out the enteries in MySQL database by state. I also have alternate row color when the table prints. WHen i try this what i see is an empty table with no values..

Please someone help me...

Here is my code:

$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name=""; // Table name

// Connect to server and select databse
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");


$state=$_POST['state'];
$sql="SELECT * FROM $tbl_name WHERE state='$state'";

//$sql = 'SELECT * '
//. ' FROM `nacontact` '
// . ' WHERE 1 AND `state` = \'$stat\'';
$result=mysql_query($sql);

// Define $color=1
$color="1";

while($rows=mysql_fetch_array($result)){
// If $color==1 table row color = #FFC600
if($color==1){ ?>
<tr class="tab_12">
<?php
echo "<td> ".$rows['fname']." ".$rows['lname']."</td>
<td>".$rows['city']."" ?> , <?php echo" ".$rows['state']."</td>
<td>".$rows['email']."</td>
<td>".$rows['phone']."</td>
<td>".$rows['country']."</td>" ?>
</tr>
<?php // Set $color==2, for switching to other color
$color="2";
}

// When $color not equal 1, use this table row color
else { ?>

<tr class="tab_13">

<?php echo "<td>".$rows['fname']." ".$rows['lname']."</td>
<td>".$rows['city']."" ?> , <?php echo" ".$rows['state']."</td>
<td>".$rows['email']."</td>
<td>".$rows['phone']."</td>
<td>".$rows['country']."</td> " ?>
</tr>
<?php
// Set $color back to 1
$color="1";
}

}
mysql_close();
?>

[swatisonee]

You have passed the code within the <? and ?> right because i dont see it in your script before .

[code]mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$state=$_POST['state'];[/code]


Also,

change $result as follows to pinpoint errors.

[code]$result=mysql_query($sql) or die (mysql_error());[/code]


And finally when you copy codes on the forum wrap it the way i have done above - easier to read.