Search the Community

Hey guys , I am currently trying to create a dynamic page layout using data that i am pulling from my database.(mysql) i have created the a href to show page.php?title=$title&id=$Id then i created the page.php where the code will be inserted to spit out the page after matching the ids this is where the problem ensues, i have created some conditionals At first, i had this code: <? $content = mysql_query("SELECT * FROM `content` ORDER BY rating, votes DESC LIMIT 0 , 30"); ?> <? if(isset($_GET['id'])){ $row = mysql_fetch_assoc($content); if (isset($row['id'])){ extract($row); } } if (!isset($_GET['movieid'])){ header("Location: i.php"); exit(); } print_r ($rows); //shows the entire array ?> but my problem that i was encountering was that any link i clicked was not producing a different ID to the URL, it was just spitting out the same array for every link i clicked on . i then tried hunting my $_GET and figured to find where the variables are coming from. and to change my SQL query to locate the correct variable i figured that the issue must be that my sql statement is not matching the $_GET to the field of the Database( 'id' ) , although that is the name of the field. i then changed it up to this simple code: $pageid = $_GET['id']; $title = $_GET['title']; $idQuery = mysql_query(" SELECT * FROM `content` WHERE 'id'=$pageid LIMIT 0 , 20"); if(isset($_GET[$id])){ $rows = mysql_fetch_assoc($idQuery); if (isset($rows['id'])){ extract($rows); } } print_r ($rows) // nothing is found i really wish to figure this out without being spoon fed the answer, but i have been stuck on this for a few nights and really could use some suggestions. thanks guys