need help using links like test.php3?id=2

[Specdro]

I have been tring for a month now to figure out why I can't program my site to open field information from a link that looks like http://www.blablabla.com/test.php3?ID=2
I can't seem to figure out how to open just the field thats ID is = to 2.
If anyone can help I would be greatful. Thank you.

-Specdro

[liliafan]

I have been tring for a month now to figure out why I can't program my site to open field information from a link that looks like http://www.blablabla.com/test.php3?ID=2 I can't seem to figure out how to open just the field thats ID is = to 2. If anyone can help I would be greatful. Thank you. -Specdro

How are you trying to access the data? Do you have a code example?

Ben

[Specdro]

How are you trying to access the data? Do you have a code example? Ben

this is the code I have to create the link but from there Im lost.

[php]$query = "SELECT * FROM mobsters";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))

{
echo "<?$row[Name]
";



}


?>[/php]

[liliafan]

From the look of the code on the next page:

<?php echo $ID; ?>

Should work.

HTH

Ben

[PoA]

Try this.

[PHP]
<?php
$query = "SELECT * FROM mobsters";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))

{
echo "$row['Name']
";
}
?>[/PHP]

[liliafan]

What code are you actually using to fetch the ID on the next page?

Ben

[kenleycapps]

[PHP]
$id = $_GET['id'];
[/PHP]

That's how you get $id on the following page.

[huwgomez]

Try this as the query on ur second page. worked for me. (Got this off Roberdin)

$query = "SELECT * FROM mobsters where ID='{$_GET['ID']}'";

Huw.

[rice_web]

Try this as the query on ur second page. worked for me. (Got this off Roberdin)

$query = "SELECT * FROM mobsters where ID='{$_GET['ID']}'";

Huw.

Don't forget an if(...) { ... } statement. Setup something like this:

[PHP]
$pageID = $_GET['ID'];

if(is_numeric($pageID) && $pageID > 0) {

$pageID = round($pageID);

$query = "SELECT * FROM mobsters where ID='{$_GET['ID']}'";

}
else {

print("Invalid Page ID");

}
[/PHP]

[evilfourzero]

I think he means how to access it..You would do this:

$id = $_REQUEST["id"];

[cscgal]

Hehe ... you just resurrected a two year old thread.