 |  |  |  |  |  |  |  |
need help using links like test.php3?id=2
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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
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
•
•
•
•
Originally Posted by 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
Ben
Application development, webhosting, and much more: www.webcentric-hosting.com
•
•
•
•
Originally Posted by liliafan
How are you trying to access the data? Do you have a code example?
Ben
[php]$query = "SELECT * FROM mobsters";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
echo "<li><font face=verdana size=-2><b><a href=http://www.mafia-files.com/test2.php3?ID=$row[ID]><?$row[Name]
</td></tr><tr><td>";
}
?>[/php]
Last edited by cscgal; Jun 10th, 2006 at 11:54 pm.
From the look of the code on the next page:
Should work.
HTH
Ben
PHP Syntax (Toggle Plain Text)
Should work.
HTH
Ben
Application development, webhosting, and much more: www.webcentric-hosting.com
•
•
Join Date: Jul 2004
Posts: 234
Reputation: 
Solved Threads: 8
Posting Whiz in Training
Try this.
[PHP]
<?php
$query = "SELECT * FROM mobsters";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
echo "<li><font face=verdana size=-2><b><a href=http://www.mafia-files.com/test2.php3?ID=$row['ID']>$row['Name']</a>
</td></tr><tr><td>";
}
?>[/PHP]
[PHP]
<?php
$query = "SELECT * FROM mobsters";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
echo "<li><font face=verdana size=-2><b><a href=http://www.mafia-files.com/test2.php3?ID=$row['ID']>$row['Name']</a>
</td></tr><tr><td>";
}
?>[/PHP]
What code are you actually using to fetch the ID on the next page?
Ben
Ben
Application development, webhosting, and much more: www.webcentric-hosting.com
[PHP]
$id = $_GET['id'];
[/PHP]
That's how you get $id on the following page.
$id = $_GET['id'];
[/PHP]
That's how you get $id on the following page.
Current languages this technical polyglot knows:
PHP
Languages this technical polyglot is working on:
C++
Java
XML
PHP
Languages this technical polyglot is working on:
C++
Java
XML
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.
$query = "SELECT * FROM mobsters where ID='{$_GET['ID']}'";
Huw.
•
•
•
•
Originally Posted by 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.
[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]
I think he means how to access it..You would do this:
PHP Syntax (Toggle Plain Text)
|
Other Threads in the PHP Forum
- Previous Thread: Please Help me
- Next Thread: You have not selected search details.
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest PHP Posts
- Today's Posts
- Unanswered Threads
ajax apache api array beginner binary body broken cakephp checkbox class cms code cookies cron curl database date date/time display dynamic ebooks echo email error file files folder form forms function functions google href htaccess html image include insert interactive ip javascript job joomla js limit link login mail mediawiki menu mlm mobile msqli_multi_query multiple mycodeisbad mysql navigation oop outofmemmory paging parse paypal pdf php problem procedure query radio ram random recursion regex remote script search server sessions sms source space sql stored subdomain syntax system table tutorial unicode update upload url validator variable video web webapplications websitecontactform xml youtube
