[RESOLVED] Id is not passing when clicking on the link

[vidz]

hey need fast help on this matter. In my veiwall.php there are links to click and edit the items. But the problem is id isnot parsing when i click them. This is how it display when i click on edit link.
address bar shows >>> http://localhost/metal/editchemical.php?id=

if i type id infront of = mark it works perfectly. This is my code for veiwall.php page. Hope u guys will help me

<?php
session_start();

if(!isset($_SESSION['SESS_LOGIN']) || $_SESSION['SESS_TYPE'] !='admin')  

{                                                                                 

  echo '<script language="javascript">'; 
  echo  'alert("Please login as ADMINISTRATOR to edit a user");';  

  echo  '</script>';                 

} 
else 

  include("config.php");

$tableName="chemical";		
$targetpage = "view_all_chemical.php"; 	
$limit = 5; 

$query = "SELECT COUNT(*) as num FROM $tableName";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];

$stages = 3;
$page = mysql_escape_string($_GET['page']);
if($page){
	$start = ($page - 1) * $limit; 
}else{
	$start = 0;	
	}	

// Get page data
$query1 = "SELECT generalname, Scientificname, quantity, reorder FROM $tableName LIMIT $start, $limit";
$result = mysql_query($query1);

// Initial page num setup
if ($page == 0){$page = 1;}
$prev = $page - 1;	
$next = $page + 1;							
$lastpage = ceil($total_pages/$limit);		
$LastPagem1 = $lastpage - 1;					


$paginate = '';
if($lastpage > 1)
{	




	$paginate .= "<div class='paginate'>";
	// Previous
	if ($page > 1){
		$paginate.= "<a href='$targetpage?page=$prev'>previous</a>";
	}else{
		$paginate.= "<span class='disabled'>previous</span>";	}



	// Pages	
	if ($lastpage < 7 + ($stages * 2))	// Not enough pages to breaking it up
	{	
		for ($counter = 1; $counter <= $lastpage; $counter++)
		{
			if ($counter == $page){
				$paginate.= "<span class='current'>$counter</span>";
			}else{
				$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}					
		}
	}
	elseif($lastpage > 5 + ($stages * 2))	// Enough pages to hide a few?
	{
		// Beginning only hide later pages
		if($page < 1 + ($stages * 2))		
		{
			for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)
			{
				if ($counter == $page){
					$paginate.= "<span class='current'>$counter</span>";
				}else{
					$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}					
			}
			$paginate.= "...";
			$paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
			$paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";		
		}
		// Middle hide some front and some back
		elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2))
		{
			$paginate.= "<a href='$targetpage?page=1'>1</a>";
			$paginate.= "<a href='$targetpage?page=2'>2</a>";
			$paginate.= "...";
			for ($counter = $page - $stages; $counter <= $page + $stages; $counter++)
			{
				if ($counter == $page){
					$paginate.= "<span class='current'>$counter</span>";
				}else{
					$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}					
			}
			$paginate.= "...";
			$paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
			$paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";		
		}
		// End only hide early pages
		else
		{
			$paginate.= "<a href='$targetpage?page=1'>1</a>";
			$paginate.= "<a href='$targetpage?page=2'>2</a>";
			$paginate.= "...";
			for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++)
			{
				if ($counter == $page){
					$paginate.= "<span class='current'>$counter</span>";
				}else{
					$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}					
			}
		}
	}

			// Next
	if ($page < $counter - 1){ 
		$paginate.= "<a href='$targetpage?page=$next'>next</a>";
	}else{
		$paginate.= "<span class='disabled'>next</span>";
		}


$paginate.= "</div>";

}


// get results from database
     //   $result = mysql_query("SELECT * FROM members") 
       //         or die(mysql_error());  

    // display data in table          
    echo "<table id='table'>";
    echo "<tr> <th>Name</th> <th>Code</th> <th>Quantity</th> <th>Reorder</th><th>Edit</th><th>Delete</th><th>Stock</th>  </tr>";

    // loop through results of database query, displaying them in the table
    while($row = mysql_fetch_array( $result )) 
	{

            // echo out the contents of each row into a table
            echo "<tr>";
            echo '<td>' . $row['generalname'] . '</td>';
            echo '<td>' . $row['Scientificname'] . '</td>';
            echo '<td>' . $row['quantity'] . '</td>';
			echo '<td>'. $row['reorder'] . '</td>';
            echo '<td><a href="editchemical.php?id=' . $row['id'] . '">Edit</a></td>';
			echo '<td><a href="delete_chemical.php?id=' . $row['id'] . '">Delete</a></td>';
			echo '<td><a href="stock_chemical.php?id=' . $row['id'] . '">Stock</a></td>';
            //echo '<td><a href="edituser.php?id=' . $row['id'] . '">Edit</a></td>';
            //echo '<td><a href="delete_user.php?id=' . $row['id'] . '">Delete</a></td>';
            echo "</tr>"; 

    } 
   echo "</table>"; 
echo $paginate;

?>

This is the error it shows
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[Bonesnap]

I'm not sure this is your issue (as you have posted a lot of irrelevant code and it's hard to navigate), but this line certainly has a problem:

$total_pages = $total_pages[num];

It looks like you forgot to put quotes around your array element. PHP will treat it as a constant but I'm going to assume you don't have a constant called num. If you had error reporting PHP would have let you know that.

Also the reason the IDs aren't showing up is simply because you're not selecting them:

$query1 = "SELECT generalname, Scientificname, quantity, reorder FROM $tableName LIMIT $start, $limit"; 

Looks like you're selecting everything but the IDs.

[vivek151189]

just echo your query and fil it in phpmyadmin you will know what isu is arising ?

[vidz]

@
You r correct. The problem is am not selecting id there. So how can i send id via link??

$query1 = "SELECT generalname, Scientificname, quantity, reorder,id FROM $tableName LIMIT $start, $limit";

now its working. Thank u guys 😃 😃