Re: extracting id from db from a form field

Oh I forgot.. ... WHERE errorcode='".mysql_real_escape_string($errorcode)."'); Best, Karl On May 27, 2011, at 2:48 PM, Karl DeSaulniers wrote:

Hi David, Try this.. if(!isset($_POST['ErrorCode'])) { die('You did not enter an error code!'); } else { $errorcode = $_POST['ErrorCode']; $sql = mysql_query("SELECT * FROM Sheet1 WHERE errorcode='".$errorcode."' "); if($sql && mysql_numrows($sql) > 0) { $row = mysql_fetch_array($sql); for($i=0; $i<mysql_numrows($sql); $i++) { echo ("Error Code: ".$row[$i]['errorcode']."<br />"); echo ("Error Definition: ".$row[$i]['definition']."<br />"); echo ("<br />"); } } else { die('No Error Code found in database'); } } Have not tested this, and there may be a better "short-hand" way of writing this, but hope it gets you on your way... Best, Karl On May 27, 2011, at 2:11 PM, David McGlone wrote:

Hello everyone, I need a little help. I've never tried to extract from a db in the manner I'm trying. It's pretty simple and straightforward I believe, but for some reason I can't figure out how. What I have is a form with 1 simple field, and this field takes the ID of the row I want returned. Here's my code so far. --index.php-- echo '<form action="result.php" method="post"> Enter Error Code:<br /> <input type="text" name="ErrorCode" /><br /> <input type="Submit" name="submit" value="Submit"> </form>' ; -result.php- $errorcode = $_POST['ErrorCode']; echo $errorcode; $sql = mysql_query("SELECT errorcode,definition FROM Sheet1"); while ($row = mysql_fetch_array($sql)) { echo "$row[errorcode]<br />"; echo "$row[definition]<br />"; } So far this is as far as I've got. I can successfully post the number entered into the form field, but I'm having trouble making use of the number. With this code, my idea was to turn the posted number from the form into a variable and use that as a reference to extract that row number from the db, but my attempts are unsuccessful. I've also unsuccessfully attempted to use a WHERE clause in my SELECT to only display the row that is posted. I hope all this makes sense. Regards, David M. --PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Karl DeSaulniers Design Drumm http://designdrumm.com --PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Karl DeSaulniers Design Drumm http://designdrumm.com