[RESOLVED] Insert table field into HTML form

rkeppert

I need to call a record from the db table and have it displayed for editing...

Basically what I have done is created a copy of the form used to input the data, and modified it to a new format to update the record...

I just can't seem to get the db table information to populate into the input fields

I have gotten no php or sql errors...

I'm guessing the code should look something like this:


value="<?php echo $row['lastname'] ?>"

however it just returns blank.

Any suggestions?

Thanks

Rob.

NogDog

There is nothing wrong syntactically with that snippet of code, so presumably the problem is elsewhere, either in the logic or some trivial mistake such as misspelling an array key or something similar.

classix16

if u use *_fetch_array($resultset)
then u can use this syntax:

value="<?php echo $row['lastname'] ?>"

but if u use *_fetch_object($resultset)
then u must use this:

value="<?php echo $row->lastname ?>"

this syntax is case sensitive

rkeppert

ok I still can't get it to work, so here is the connect code:


session_start(); // Turn on the session variables

ini_set('display_errors', true); // I want PHP Information On Screen
error_reporting( E_ALL ); // I want as much Debug Info I can get when I code

include ('db_conn.php');

$dbc = mysql_connect($servhost, $servuser, $servpwd);
if ( !$dbc ){
    exit( "Connection Failed" );
}
$dbnc = ($dbsname);
if(!mysql_select_db($dbnc, $dbc) ){
    exit( "DB Selection Failed" );
}


// see if SESSION have some such value, otherwise = '' = empty
$recnum_id2 = isset($_GET['recnum']) ? $_GET['recnum'] : '';

if( !empty($recnum_id2) ){
    $sql2 = "SELECT * FROM $tabname WHERE recnum = '$recnum_id2'";
}


// do the sql query and get result
$srchdn2 = mysql_query($sql2);
if($srchdn2 === false)
{
   user_error("Query failed: " . mysql_error() . "<br />\n$sql2");
   // output "nice" error to user, then exit() or whatever is appropriate
} 

// ARRAY to store the rows, if any
$all_rows2 = array(); // make an empty array

while($row2 = mysql_fetch_assoc($srchdn2)){
    $all_rows2[] = $row2; // store each row, if any
}