Date: 01/05/06 (PHP Community)    Keywords: mysql, database, sql, web

Okay, stumped.

if ($_GET['id'] == "") { $link = mysql_connect("localhost","iop","iopweb") or die ("Could not connect"); mysql_select_db("iop") or die("Could not select database"); $select_string = "SELECT `id`,`name` FROM internships WHERE `approved` != \"yes\" ORDER BY `post_date` DESC"; $result = mysql_query($select_string); while ($current = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "<a href=\"internships_edit.php?id=" . $current['id'] . "\">" . $current['name'] . "</a><br />"; } //end of first clause of get_id if statement } else { echo $_GET['id'] . "<br /><br />"; $query_id = $_GET['id']; echo $query_id; $select_string_specific = "SELECT * FROM internships WHERE `approved` != \"yes\" AND `id` = " . $query_id . " ORDER BY `id` DESC"; echo $select_string . "<br />"; $result_spec = mysql_query($select_string_specific); // Print out the information while ($current = mysql_fetch_array($result_spec, MYSQL_ASSOC)) { echo "<td><b>ID</b>: <input type=\"text\" name=\"this_id\" value=\"" . $current['id'] . "\"/><br /><b>Name:</b> <input type=\"text\" name=\"this_name\" value=\"" . $current['name'] . "\"/><br /><b>Post Date:</b> " . $current['post_date'] . "<br /><b>Title:</b> " . $current['title'] . "<br /><b>Deadline:</b> " . $current['deadline'] . "<br /><b>Description:</b> " . $current['description'] . "<br /><b>Application Requirements:</b> " . $current['app_requirements'] . "<br /><b>City:</b> " . $current['city'] . "<br /><b>Contact Name:</b> " . $current['contact_name'] . "<br /><b>Contact Address:</b> " . $current['contact_address'] . "<br /><b>Contact Email:</b> " . $current['contact_email'] . "<br /><b>Contact Phone:</b> " . $current['phone'] . "<br /><b>Contact Fax:</b> " . $current['fax'] . "<br /><b>URL:</b> " . $current['url'] . "<br /><b>Link to Application:</b> " . $current['app_link'] . "<br /><b>Job yes/no:</b> " . $current['job'] . "<br /> <b>State:</b> " . $current['state'] . "<br /><form action=\"internships_approve.php\" method=\"post\"><input type=\"hidden\" name=\"approved\" value=\"yes\"> <input type=\"hidden\" name=\"submitted\" value=\"yes\"><input type=\"hidden\" value=" . $current['id'] . " name=\"id\"><input type=\"submit\" value=\"Click to Approve\"></form></td>"; } }

Everything works fine until the else portion is reached. At that point, the query that is echoed works just fine if I paste it into my MySQL db, but it acts like an asshole here, apparently, because I get the old "not a valid resource" error message that we all live for. It should only be selecting one record, the one with the corresponding ID number (there are no duplicate IDs) and then displaying the information associated with that ID number after obtaining the ID number from the url as a $_GET. (I know there's some unnecessary variable re-setting in here - I was trying anything I could.)

I can't figure this out. It's something so simple, I bet, and that's why I'm not seeing it because I've been swearing at it for over 30 minutes now.

Any help is appreciated.

Source: http://www.livejournal.com/community/php/389386.html