Re: PHP webpage like MySQL, PART 2

Matt Hedges wrote:

<html> <head><title>Update Sister Info.</title></head> <body> <?php $host="host"; $user="user"; $password="pw"; $database="db"; $id=1; Why $id=1, you want to edit any sister info

$connection = mysql_connect($host,$user,$password)

       or die ("couldn't connect to server");

$db = mysql_select_db($database,$connection)

       or die ("Couldn't select database");

if (@$first == "no") {

        $query = "UPDATE table SET

FirstName='$FirstName',MiddleName='$MiddleName',LastName='$LastName',GradYea r='$GradYear',Email='$Email',MarriedName='$MarriedName' WHERE id='$id'";

        $result = mysql_query($query)
             or die ("Couldn't execute query.");
        echo "Thank you! Information entered. <a href=actives.php>View

Actives</a><br>";

        exit();

} else {

    $query = "SELECT * FROM table WHERE id='$id'";
    $result = mysql_query($query)
         or die ("Couldn't execute query.");
    $row = mysql_fetch_array($result);
    extract($row);

} /* Display user phone in a form */ echo "<br><p align='center'>

       <font size='+1'><b>Please check the sister below and correct if

necessary.</b></font>

       <hr>
       <form action='updatesister.php?first=no' method='post'>

should be <form action='updatesister.php?first=no&id=$id' method='post'>

        <div align='center'>
        <table width='50%' border='0' cellspacing='0' cellpadding='2'>
        <tr><td align='right'><B>$id</br></td>
           <td align='center'><input type='text' name='FirstName' size='20'

maxlength='20' value='$FirstName' > </td>

           <td align='center'><input type='text' name='MiddleName' size='20'

maxlength='20' value='$MiddleName' > </td>

           <td align='center'><input type='text' name='LastName' size='20'

maxlength='20' value='$LastName' > </td>

           <td align='center'><input type='text' name='GradYear' size='20'

maxlength='20' value='$GradYear' > </td>

           <td align='center'><input type='text' name='Email' size='20'

maxlength='20' value='$Email' > </td>

           <td align='center'><input type='text' name='MarriedName'

size='20' maxlength='20' value='$MarriedName' > </td>

        </tr>
        <tr><td></td><td align='center'>
           <br><input type='submit' value='Update Sister'></td>
        </tr>
        </table>
       </form>";

?> </body> </html>

Visit this page as updatesister.php?id=#id#