problem in my output

[phpjay]

why my remarks get all remarks from my table i want only display the data only selected ID heres my code

$result = mysql_query("SELECT `Remarks` FROM `$table2` WHERE ID = `$ID`"); 
while($row = mysql_fetch_array($result))
{

			$remarks = "$row[Remarks]";

			$explodeTilde = explode('_', $remarks);
				foreach($explodeTilde as $k => $v) 
				{
					$explodePipe = explode('|', $v);
					foreach($explodePipe as $k2 => $v2) 
					{
						$date_entered = date("m/d/Y", strtotime($v2));
						echo "<br>";
						echo $v2 . '';


					}
				}



}
  

  

[spiderwell]

in the WHERE part of the clause you have back ticks on the value of ID, remove those, I assume it is an integer value?

 

WHERE ID = $ID");

[phpjay]

i remove the where clause ID same problem again

[TeNDoLLA]

Don't see anything wrong in your code. Maybe you got multiple rows there with the same ID? Do you have any SQL command line program to test out the query? I have noticed it's a good practise to debug queries outside PHP in a program such as HeidiSQL or SQLYog or similar. Echo your query out before running it in PHP and copy&åaste this query to SQL command line and see results and try to figure why they are wrong. Can't help much more without knowing your data in db.

[phpjay]

i used this one instead of array

$row=mysql_fetch_assoc($result);