Location: PHPKode > projects > MeBiblio > meBiblio-0.4.8/admin/class_replace.inc.php
<?
	include "dblink.php";

	$sql = "UPDATE Journal_ID SET ".
	"Jlong='".$_POST['Jlong']."', ".
	"Jshort='".$_POST['Jshort']."', ".
	"JURL='".$_POST['JURL']."' WHERE JID=".$_GET['JID'];
print $sql;
//update DB
      $result = mysql_query($sql) or die("Invalid query: " . mysql_error());
//verify update
	$sql = "SELECT JID, Jlong , Jshort, JURL FROM Journal_ID WHERE JID = ". $_GET['JID'];
      $result = mysql_query($sql) or die("Invalid query: " . mysql_error());
        $field = mysql_fetch_row($result);


    	print "<table><tr> <td><a href=\"index.php?action=admin/journal_change_mask&JID=$field[0]\">$field[0]</a></td>
	<td>$field[1]</td>
	<td>$field[2]</td>  
	<td><a href=\"$field[3]\">$field[3]</a></td></table> "; 

print "<p><a href=\"index.php?action=admin/journal_delete&JID=".$field[0]."\">Delete this journal from the bibliography</a>";
Return current item: MeBiblio