SELECT * from content WHERE page_id = '$Id' help.

[runar56]

Hi.

I'm trying to fetch a single row where by the id of it is called by the browser. So if URL is internet.com/index.php?id=1, it will fetch a row where the column page_id is 1. This is my code:

<?
error_reporting(E_ALL); 

include('common_db.php'); 
db_connect('****'); 
mysql_select_db('****'); 

$result = mysql_query("SELECT * FROM content WHERE page_id = '" . $id . "'"); 

while ($row2 = mysql_fetch_assoc($result)) 
{
?> 
<font color="#FFFFFF"><?php echo $row2['page_content']; ?></font> 
<?php
}

?>

But it doesn't fetch the row. No error message or nothing. Any help much appreciated.🙂

[laserlight]

Test something like:

<?php
error_reporting(E_ALL); 

include 'common_db.php'; 
db_connect('****');
mysql_select_db('****')
	OR die(mysql_error());

if (isset($_GET['id'])) {
	$id = $_GET['id'];
	$result = mysql_query("SELECT * FROM `content` WHERE `page_id`='$id'")
		OR die(mysql_error());
	if (mysql_num_rows($result) == 1) {
		$row = mysql_fetch_assoc($result);
		echo $row['page_content'] . "<br>\n";
	} else {
		echo "No rows returned";
	}
} else {
	echo "No ID specified";
}
?>

[runar56]

Thank you very much it worked!🆒