ID question....

[crawfd]

I am trying to interperet the link newsfull.php?id=30 which is parsed from another page to the script below, and list the ID row (1 row) with fields according to the records respective ID number. In the ex. link above ID 30. All I get is a blank page without any print. Please Help

<?

include("header.inc");

if(isset($ID)){

$linkID = @mysql_connect("localhost", "", "");
mysql_select_db("news", $linkID);

$resultID = mysql_query("SELECT ID, title, date, poster, mail, newsfull FROM ibwdnews WHERE ID = $ID", $linkID);

mysql_data_seek($resultID, $ID);

mysql_result($ID, $title, $date, $poster, $mail, $date, $newsfull);

$print = "

	<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\">
	<tr>
	<td width=\"100%\" bgcolor=\"#F8F8F8\">
	<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">
	<tr>
	<td><b>$title</b>  by $poster</td>
	<td>
	<p align=\"right\"><a href=\"mailto:$mail\">Email Me</a> | $date</td>
	</tr>
	</table>
	</td>
	</tr>
	<tr>
	<td width=\"100%\">$newsfull</td>
	</tr>
	</table>\n<br>\n

	";

echo $print;

}

?>
<?php include("footer.inc"); ?>

[YappyDog]

Well, your url has a parameter in it called id (lowercase). You are checking for $ID (uppercase). Those two don't match up.

Also, depending on your php version and how things are setup, you may need to retrieve the parameter into your variable from the GET array before you can use it. Like:

$id = $_GET["id"];

[crawfd]

YappyDog,

I added the variable line in the code. Then got query errors. I changed the functionality but still receiving these two erros.

Warning: Supplied argument is not a valid MySQL result resource in c:\apache\htdocs\luciddreaming\newsfull.php on line 14

Warning: Supplied argument is not a valid MySQL result resource in c:\apache\htdocs\luciddreaming\newsfull.php on line 16

---

<?

include("header.inc");

$id = $_GET["id"];

if(isset($id)){

$linkID = @mysql_connect("localhost", "", "");
mysql_select_db("news", $linkID);

$resultID = mysql_query("SELECT id, title, date, poster, mail, newsfull FROM ibwdnews WHERE id = $id", $linkID);

$numrows = mysql_result($resultID, 0, 0);

while (list($title, $poster, $mail, $date, $newsfull) = mysql_fetch_row($resultID)); {

	$print = "

	<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\">
	<tr>
	<td width=\"100%\" bgcolor=\"#F8F8F8\">
	<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">
	<tr>
	<td><b>$title</b>  by $poster</td>
	<td>
	<p align=\"right\"><a href=\"mailto:$mail\">Email Me</a> | $thedate</td>
	</tr>
	</table>
	</td>
	</tr>
	<tr>
	<td width=\"100%\">$newsfull</td>
	</tr>
	</table>\n<br>\n

	";

echo $print;

}
}
?>
<?php include("footer.inc"); ?>

[YappyDog]

So that is saying it doesn't think you have anything in $resultID.

I'd change things up a bit and build your query as a separate variable and then run it. The advantage of doing this is that you can also echo it out to see that what you are running is what you expect it to be. You can also run the query manually to check the results.

$query = "SELECT id, title, date, poster, mail, newsfull FROM ibwdnews WHERE id = $id";
echo "<li>query = $query<br>";
$resultID = mysql_query($query, $linkID);

Secondly, you are selecting six columns from the table, but only trying to receive five into your variables and you are doing them in a different order. Not sure if that will cause a problem once you get the query to return results or not.

[crawfd]

Yappy Dog,

I inserted the code after the echo in the query and got the returned results:

query = SELECT title, poster, mail, date, newsfull FROM ibwdnews WHERE id = 29

So it's reading the id properly, but I can't seem to get the sql statements working properly..

I changed the order of variables.

Now have the following but argh, still receiving an error.

---

<?

include("header.inc");

$id = $_GET["id"];

if(isset($id)){

$linkID = @mysql_connect("localhost", "", "");
mysql_select_db("news", $linkID);

$query = "SELECT title, poster, mail, date, newsfull FROM ibwdnews WHERE id = $id";

$resultID = mysql_query($query, $linkID);

while (list($title, $poster, $mail, $date, $newsfull) = mysql_fetch_row($resultID)); {

	$print = "

	<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\">
	<tr>
	<td width=\"100%\" bgcolor=\"#F8F8F8\">
	<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">
	<tr>
	<td><b>$title</b>  by $poster</td>
	<td>
	<p align=\"right\"><a href=\"mailto:$mail\">Email Me</a> | $date</td>
	</tr>
	</table>
	</td>
	</tr>
	<tr>
	<td width=\"100%\">$newsfull</td>
	</tr>
	</table>\n<br>\n

	";

echo $print;

}
}
?>
<?php include("footer.inc"); ?>

[YappyDog]

If you run your query statement manually does it return anything?

[crawfd]

When executing the script it returns one row, however it isn't executing the variables in the query, thus resulting in a table with empty areas. I posted my latest code in my previous message :-/