craig1978 Posted May 2, 2007 Share Posted May 2, 2007 Hi Guys, I'm sorry but to post this again but I am really struggling here. Being a newbie to all this it does take me a little longer to understand. I have currently coded a search form and results page. What I would like to do is link a particular result to a details page. I have tried using the GET method but all I get in the browser is a "No input file specified". I'm not sure why. Any ideas?? The ID number is displaying in the details.php page URL, but not sure if my code on details.php is GETting it properly. Here is the code for the details.php: <? include 'Config.php'; include 'OpenDB.php'; if (isset($_GET['ID_No'])); $ID_No = $_GET['ID_No']; // $result=mysql_query("SELECT * FROM PersonalTrainers WHERE ID_No = '$ID_No'"); // $row_result=mysql_fetch_assoc($result); $query = "SELECT * FROM PersonalTrainers WHERE ID_No = $ID_No"; $result=mysql_query($query); while ($row_result = mysql_fetch_assoc($result)) { echo "<center>$row_result['Thumbnail']</center>"; $Thumbnail=mysql_result($row_result,"Thumbnail"); $First_Name=mysql_result($row_result,"First_Name"); $Last_Name=mysql_result($row_result,"Last_Name"); $Email=mysql_result($row_result,"Email"); $Suburb=mysql_result($row_result,"Suburb"); $Postcode=mysql_result($row_result,"Postcode"); $Age=mysql_result($row_result,"Age"); echo "<center><$First_Name $Last_Name</b><br>Email: $Email<br>Suburb: $Suburb<br>Postcode: $Postcode<br>Age: $Age<br><hr><br></center>"; } include 'CloseDB.php'; ?> Thanks craig1978 Link to comment https://forums.phpfreaks.com/topic/49641-no-input-file-specified/ Share on other sites More sharing options...
DaveEverFade Posted May 2, 2007 Share Posted May 2, 2007 You don't have a { here: if (isset($_GET['ID_No'])); You would then also need to close this Link to comment https://forums.phpfreaks.com/topic/49641-no-input-file-specified/#findComment-243361 Share on other sites More sharing options...
jitesh Posted May 2, 2007 Share Posted May 2, 2007 if (isset($_GET['ID_No'])) $ID_No = $_GET['ID_No']; else $ID_No = 0; Link to comment https://forums.phpfreaks.com/topic/49641-no-input-file-specified/#findComment-243364 Share on other sites More sharing options...
craig1978 Posted May 2, 2007 Author Share Posted May 2, 2007 Hi, Thanks heaps for your time guys. Tried both of those suggestions but still the same error. I have no idea what's going on. craig1978 Link to comment https://forums.phpfreaks.com/topic/49641-no-input-file-specified/#findComment-243388 Share on other sites More sharing options...
DaveEverFade Posted May 2, 2007 Share Posted May 2, 2007 Can you post the error you're getting here please? Link to comment https://forums.phpfreaks.com/topic/49641-no-input-file-specified/#findComment-243391 Share on other sites More sharing options...
jitesh Posted May 2, 2007 Share Posted May 2, 2007 Your error please ? Link to comment https://forums.phpfreaks.com/topic/49641-no-input-file-specified/#findComment-243402 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.