Jump to content


Photo

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


  • Please log in to reply
1 reply to this topic

#1 kartikayg

kartikayg
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 23 March 2006 - 12:56 AM

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();
?>

#2 swatisonee

swatisonee
  • Members
  • PipPipPip
  • Advanced Member
  • 253 posts

Posted 23 March 2006 - 04:46 PM

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

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

$state=$_POST['state'];


Also,

change $result as follows to pinpoint errors.

$result=mysql_query($sql) or die (mysql_error());


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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users