Location: PHPKode > projects > BBViewer > BBViewerApp/bbviewer/admin/editvideo.php
<?PHP

require('/library/webserver/auth.inc'); 
require('config.php');
require('connect.php');

?>

<TITLE><?php echo $domain ?> - Edit Picture</TITLE>

<? INCLUDE("admintop.inc")?>

<IMG SRC='../images/new_admin.gif' BORDER='0' style="POSITION: absolute; TOP: 0px; LEFT: 0px; Z-INDEX: 25">
<IMG USEMAP="#babybrynteson" SRC='../images/new_title.gif' border='0' style="POSITION: absolute; TOP: 70px; LEFT: 0px; Z-INDEX: 25">


<div style="POSITION: absolute; TOP: 125px; LEFT: 5px; width: 650px; Z-INDEX: 25">

<h3>Edit Pictures In Database:</h3><p>

<?php

// query the DB

$sql = "SELECT * FROM video WHERE id=$id";

$result = mysql_query($sql);	

$myrow = mysql_fetch_array($result);

if ($submit) {

//process form

$sql2 = "UPDATE video SET short='$short',videotype='$videotype',filename='$filename',filenamelow='$filenamelow',message='$message',postdate='$postdate',thumbname='$thumbname' WHERE id=$id";

$result = mysql_query($sql2);

echo "Thank you.  Your information has been updated.\n";

	
} else {

//display form

?>

<form method="post">

<table width=500px border=0>

<tr>

<td>Short Description:

<td><input type="text" id="text" name="short" value="<?php echo $myrow["short"] ?>">

<tr>

<td>Picture Type:

<td><input type="text" id="text" name="pictype" value="<?php echo $myrow["videotype"] ?>">

<tr>

<td>Filename High:

<td><input type="text" id="text" name="filename" value="<?php echo $myrow["filename"] ?>">

<tr>

<tr>

<td>Filename Low:

<td><input type="text" id="text" name="filename" value="<?php echo $myrow["filenamelow"] ?>">

<tr>

<td>Thumbnail Name:

<td><input type="text" id="text" name="thumbname" value="<?php echo $myrow["thumbname"] ?>">

<tr>

<td>Postdate:

<td><input type="text" id="text" name="postdate" value="<?php echo $myrow["postdate"] ?>">

<tr>

<td>Description:

<td><textarea rows="5" cols="55" id="text4" name="message" value="none"><?php echo $myrow["message"] ?></textarea>

</table>

<input type="Submit" name="submit" value="Enter Information">

</form>

<?php

}  //end if

?>

<? INCLUDE("../bottom.inc")?>

</div>
Return current item: BBViewer