Help with my code (SQL QueryDisplay Results))

g0dzuki

Hi Everyone --

I'm trying to php code a page that will display the results of a record when you click on a link.

I have the page that displays all the records... here's the relevent code:

<td><font size=$FontSize><a href='view.php?id=$id'>$App</a></font></td>

(id is my primarykey)
Now, when you click on the value of $App i want it to display the detailed results in view.php

Here's view.php:

<?PHP

include "header.php";   

include "dbconnect.php"; 


$query = "SELECT * FROM data WHERE (
	(id ='$id'))";  

$result = mysql_query($query)  
		or die ("Query Failed");  

	$ID = mysql_result($result,  "id");
	$App = mysql_result($result, "App");
	$AppVersion = mysql_result($result, "AppVersion");		
	$Developer = mysql_result($result, "Developer");
	$RegNumber = mysql_result($result,"RegNumber");
	$RegName = mysql_result($result, "RegName");
	$Comments = mysql_result($result, "Comments");
	$OS = mysql_result($result, "OS");
	$Catagory = mysql_result($result,  "Catagory");			

	echo "$ID, $App, $AppVersion, $OS";


include "footer.php";   


?>
</body> 
</html>

The link will correctly display View.php but does not echo the values of my variables.

I know my code is wrong somewhere but I don't know enough of php to troubleshoot it very well.
Can anyone lend a hand?

Let me know if i'm not making any since either!

Thanks!!!

leatherback

Try this:

<?PHP

include "header.php";

include "dbconnect.php";

$query = "SELECT * FROM data WHERE id ='$id' ";  

$result = mysql_query($query)  
         or die ("Query Failed");

while ($row =@ mysql_fetch_array($result))
{
echo $row[iD];
echo $row[App];
echo $row[AppVersion];
echo $row[OS];
}

// Or between the {} of the while statement:

$Output .= "$row[iD] $row[App] $row[AppVersion] $row[OS]";

// and any other HTMl you might want to use

Hope this helps?
(Since I am off to bed now!)
J

g0dzuki

No luck with either suggestion. Header/Footer.php display but no data in between... no error either.

I'll keep experimenting... sweet dreams!

leatherback

Hi,

Lst mess before sleep ...;-)

Check Cap's (I saw id and ID in your list)
Check wether the includes have the proper elements identified
Echo the $query to check wether $id is parsed properly, and try the query in your mysql database directly. Does that return results?
Check the number of results returned ( $ number =@ mysql_num_rows($result));

that should do the trick

Else: Pst again. Maybe the rest of the world is stoill awake : Here it is 1 am, and I need to work tomorrow !!

g0dzuki

Making some progress!

the value of $id is not making it to the query from the URL.

My link is:

<a href='view.php?id=$id'>$App</a>

and in the URL will show up as:

view.php?id=25

but when I echo $query there is no value for 'id' However, when I manually give a value to id in view.php the data is displayed.

So i guess the question is this: How do I correctly get the $id value from the link to the SELECT query.

Thanks for your help, leatherback!

Anyone with ideas?

~ g0dzuki