[Resolved] grabbing specific mySQL data?

[satanclaus]

Ok I have a table which holds comments data. The table has 4 fields...ID, Name, email and comments.

Im trying to find out how I would be able to use a web address...say for example index.php?page=comments&q=5 where 5 is the ID of the comment to be displayed. surely someone will know.

I already know how to do the ?page=comments thing...thats not what Im wondering how do to. It's linking the value of q to the ID that is fetched from the table.

Thanks in advance!

[drawmack]

select * from comments where id = $_GET['q']

[satanclaus]

hmm...im having trouble putting that in the page.

heres my current page.

<?php
$db = mysql_connect("localhost","root","") or die("Problem connecting");
mysql_select_db("quotes") or die("Problem selecting database");
if (isset($_GET['q'])) 
  { 
	$query = "SELECT * FROM quotes WHERE ID = $_GET['q'];
	$result = mysql_query($query) or die ("Query failed");
	$numofrows = mysql_num_rows($result);

echo "<TABLE BORDER=\"0\" WIDTH="100%\">\n";
echo "<TR bgcolor=\"lightblue\"><TD><b>ID</b></TD><TD><b>Posted 	

By</b></TD><TD><b>Quote</b></b></TD></TR>\n";
	echo "<TD>".$row['ID']."</TD><TD>".$row['name']."</TD><TD>".$row['quote']."</TD>\n";
    echo "</TR>\n";
}
else {
$query = "SELECT * FROM quotes ORDER BY ID"; 
$result = mysql_query($query) or die ("Query failed"); 
$numofrows = mysql_num_rows($result); 

echo "<TABLE BORDER=\"0\" WIDTH=\"100%\">\n";
echo "<TR bgcolor=\"lightblue\"><TD><b>ID</b></TD><TD><b>Posted 

By</b></TD><TD><b>Quote</b></b></TD></TR>\n";
for($i = 0; $i < $numofrows; $i++) {
    $row = mysql_fetch_array($result); 
    if($i % 2) { 
        echo "<TR bgcolor=\"#F6F6F6\">\n";
    } else {
        echo "<TR bgcolor=\"white\">\n";
    }
    echo "<TD>".$row['ID']."</TD><TD>".$row['name']."</TD><TD>".$row['quote']."</TD>\n";
    echo "</TR>\n";
}
echo "</TABLE>\n";
}
?> 

I get the following error

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in d:\wamp\www\quote\quotes.php on line 6

[drawmack]

try closing the quotes on your query string