
May 6th, 2007, 09:45 PM
|
|
Contributing User
|
|
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 65
Time spent in forums: 1 Day 1 h 5 m 28 sec
Reputation Power: 4
|
|
|
Something wrong?
I've just done a simple update query and it's not updating my database? Could someone please have a look at my code and see what I've done wrong?
Code:
<?php
require( "dbconn.php" );
if( array_key_exists( 'header', $_POST ) ){
$selectOther = "SELECT * FROM sn_columnists WHERE writer = '". $_POST['writer'] ."'";
$finalOtherQuery = mysql_query($selectOther);
while ($other = mysql_fetch_assoc($finalOtherQuery)){
$date = $_POST['day'] . ' ' . $_POST['month'] . ' ' . $_POST['year'];
$insertQuery = "UPDATE `sn_articles` SET date = '" . $date . "', header = '" . $_POST['header'] . "', writer = '" . $_POST['writer'] . "', alias = '" . $_POST['alias'] . "', featured = '" . $_POST['featured'] . "', article = '" . $_POST['article'] . "', archive = '" . $_POST['archive'] . "', category = '" . $_POST['category'] . "', menu = '" . $other['menu'] . "' WHERE id = '" . $_POST['id'] . "' ";
$result = mysql_query( $insertQuery ) or die( "There was an error with my query! ".mysql_error()."<br>The query was: ".$insertQuery);
$submitted = '<p align="center"><strong>Your article has been edited sucessfully!</strong></p><p><a href="javascript:history.back()">Back</a></p><p><strong><a href="admin.php">Admin Main</a></strong> | <strong><a href="logout.php">Logout</a></strong></p>';
}
}
?>
Thank you 
|