[PHP] Problem updating post on a basic weblog system

2002-09-12 Thread Jesse Lawrence

Hello all,

I've got a bit of a code problem that's been baffling
me for a while now.

I'm working on a basic weblog system for personal use,
using MySQL.  I've got the new post and delete a
post aspects working fine, but for some reason, I
can't get the update a post part happening.  

What happens is I select a post to update, and then
the post comes up in a textarea box.  You then make
your update, and submit.

Doing this calls the following function:

 function updateBlog($input,$edit_blog) { 


 include 'db_connect.php';
$update_query = update $table set blog='$input'
where id='$edit_blog';
if(mysql_db_query ($database, $update_query,
$link)) {
   print Successfully Edited!!;
}else{
print no;

}   

 The variables being passed to the function are:
  $input = The body of the post
 and
  $edit_blog =  id # of post

At this point everything appears to have been a
success.  The Successfully Edited!! confirmation
appears, and everything seems fine, but when I look at
my database, nothing has been updated or changed in
any way.

Does anyone have any suggestions or help they could
lend me?  I've been facing this problem for a while
now, and can't seem to get my head around it.

You can view the entire code here:
http://soniceast.d2g.ca/~jalaw/blog/admin.txt

Thanks a bunch for any help,

Jesse Lawrence
 

__ 
Post your free ad now! http://personals.yahoo.ca

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP] Problem updating post on a basic weblog system

2002-09-12 Thread Chris Wesley

code snippet
   if ($post == post) {
  postBlog ($post,$input,$title);
   }elseif ($post == edit){

  updateBlog ($input,$edit_post);  //   BINGO!
   }
/code snippet

Just looking at the code you posted to your site, there's only one thing
obvious to me: You want to use $edit_blog in that call to updateBlog
instead of $edit_post?

g.luck,
~Chris

On Thu, 12 Sep 2002, Jesse Lawrence wrote:

 Hello all,

 I've got a bit of a code problem that's been baffling
 me for a while now.

 I'm working on a basic weblog system for personal use,
 using MySQL.  I've got the new post and delete a
 post aspects working fine, but for some reason, I
 can't get the update a post part happening.

 What happens is I select a post to update, and then
 the post comes up in a textarea box.  You then make
 your update, and submit.

 Doing this calls the following function:

  function updateBlog($input,$edit_blog) {


  include 'db_connect.php';
 $update_query = update $table set blog='$input'
 where id='$edit_blog';
 if(mysql_db_query ($database, $update_query,
 $link)) {
print Successfully Edited!!;
 }else{
 print no;

 }

  The variables being passed to the function are:
   $input = The body of the post
  and
   $edit_blog =  id # of post

 At this point everything appears to have been a
 success.  The Successfully Edited!! confirmation
 appears, and everything seems fine, but when I look at
 my database, nothing has been updated or changed in
 any way.

 Does anyone have any suggestions or help they could
 lend me?  I've been facing this problem for a while
 now, and can't seem to get my head around it.

 You can view the entire code here:
 http://soniceast.d2g.ca/~jalaw/blog/admin.txt


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php