Url Id ?

markmusicman

I am trying to access information in a row and display it using an id in the url for example http://www.markmusicman.com/php/link_test.php?id=1
Here is the code I currently am working with also I am very new to this and have been trying all sorts of stuff hopefully someone here can help me.

<?php include("dbconnect.php");
$result = mysql_query("SELECT * FROM videos where id='$id'")
or die(mysql_error()); $row = mysql_fetch_array( $result ); echo "".$row['text'];?>

If i put an id in the (where id=1) I can disply the info , but I want to be able to choose the id from the web page.

Any help would be greatly appreciated and be easy on me Im new.
Thanks
Mark

anoopd

dear mark
Its not clear from the post what you are supposed to do? Do u need links from where you can go to respective pages with respective ids? Please make it clear

markmusicman

So I have a bunch of rows in my database that all have an Id associated with them. I just want to be able to pick one of the ids and grab information from the table and display the results on a page usimg the URLs with ids on the end

example http://www.markmusicman.com/php/link_test.php?id=1
example http://www.markmusicman.com/php/link_test.php?id=2

I have tried all sorts off things and the only thing I was able to do is display results when using ("SELECT * FROM videos where id='1'")

I want to be able to use just one PHP page that I can reference with links with the added id=1 on the end. I plan on using a menu system to grab different info
Not sure if this helps you understand or not.
Mark

Weedpacket

Possibly Question One in the Newbies' FAQ could be relevant here. (Short answer: try $_GET; go back to the manual and see what it says about getting variables from outside PHP).

markmusicman

Thanks for the tip I was able to get it working (YES) Took me about 12 hours to figure out what I had to do. Thanks again
Mark