PHP Forum

**elena1234** · 03-03-2010, 06:32 AM

please let us know where is prob.

Quote:

<?php
$db_name="ram";
mysql_connect("localhost","root","");
$db=mysql_select_db($db_name);

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Branch</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script type="text/javascript" src="script.js"> </script>
<style type="text/css">

</style>
</head>

<body>
<table width="775" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td><hr size="1" nosdaeh></td>
</tr>
<tr>
<td>
<form action="" method="post" name="" id="">
<table width="600" border="1" align="center" cellpadding="2" cellspacing="2">
<tr>
<td><input name="topcheckbox" type="checkbox" class="check" id="topcheckbox" onClick="selectall();" value="ON">
Select All </td>
<td colspan="3" align="center"><a href="form.php?mode=add">Add New Branch</a></td>
</tr>
<tr>
<td><strong><a href="javascript:goDel()">Delete</a></strong></td>
<td><strong>Branch Name </strong></td>
<td><strong>Short Name </strong></td>
<td><strong>Update</strong></td>
</tr>
<?

while($row=mysql_fetch_array( $result=mysql_query("select * from tbl_products"))) {
?>
<tr>
<td><input name="<? echo $row['sn']; ?>" type="checkbox" class="check"></td>
<td><? echo $row['branchname']; ?></td>
<td><? echo $row['shortname']; ?></td>
<td><a href="<? echo 'form.php?sn='.$row['sn'].'&mode=update'; ?>">Update</a></td>
</tr>
<? } ?>
<tr>
<td><strong><a href="javascript:goDel()">Delete</a></strong></td>
<td><strong>Branch Name </strong></td>
<td><strong>Short Name </strong></td>
<td><strong>Update</strong></td>
</tr>
</table>
</form></td>
</tr>
</table>
</body>
</html>

**wayfarer07** · 03-03-2010, 08:34 AM

and the problem you're having is?

**NullPointer** · 03-03-2010, 11:53 AM

This line:

PHP Code:


			
while($row=mysql_fetch_array( $result=mysql_query("select * from tbl_products")))

At each iteration of the while loop this entire line is evaluated. This means that your query is executed and set to the variable $result each time. Try:

PHP Code:


			
$result=mysql_query("select * from tbl_products");

while($row=mysql_fetch_array( $result))

Also, don't use short tags; use <?php instead of <?

One more thing, as Abel pointed out. Be specific about your problem. What error messages are you getting? What is the expected and actual result of your code?