updating records being picky

[Lcousins]

Hi all,

I have a basic content management system running which includes the ability to add/edit/delete articles to the main page. These articles consist of a headline and content (both text type), a unique id and a (now) date function. I am encountering two problems -

1. Some articles get edited/ added fine, some dont. I believe it has something to do with length, though since im using 'text' type for both the main fields i dont understand why this would be a problem. Ive actually gone in through phpmyadmin and had no problem inserting exactly the same data manually.

2. on the occasions where the above does work, I have to manually refresh the page to get it to show up.

any ideas or solutions would be most appreciated, this is driving me crazy!

Luke

[thoand]

Maybe the form method needs to be changed,

If you think there are going to be posted large amounts of data to the server, always stick to the POST method,

eg.

<form action="...", method="POST">

regards,
Thomas A

[Lcousins]

hi,

thanks but unfortunately im already using 'post' with the form.. Im not sure if it will help but this is the editing form:

<form name="form1" method="post" action="editarticle.php?id=
<?
echo $id;
?>
">
        <p>The allows you to edit an article. Html code is allowed.</p>
 <?
$db = mysql_connect("host", "username", "password");
mysql_select_db("database",$db);
$result = mysql_query("select * from news where id='$id'",$db);
while($row = mysql_fetch_array($result)){
?>
        <table width="100%" border="0">
          <tr> 
            <td width="8%">Headline:</td>
            <td width="92%"><textarea name="headline" cols="100" id="headline">
<?
echo $row["headline"];
?>
	  </textarea></td>
          </tr>
          <tr> 
            <td height="144">Contents: </td>
            <td><p> 
                <textarea name="contents" cols="100" rows="6" id="contents">
<?
echo $row["content"];
?>
		  </textarea>
              </p></td>
          </tr>
          <tr><input name="id" type="hidden" value="
<?
echo $row["id"];
?>		  

		"> 
            <td><input type="submit" name="Submit" value="Submit"></td>
            <td>&nbsp;</td>
          </tr>
        </table>
      </form>
      <?
 }
 ?>

and this is the updating script:

?
$db = mysql_connect("host", "username", "password");
mysql_select_db("database",$db);
$result = mysql_query("update news set headline =('$headline'), content =('$contents') where id='$id'",$db); 

?>

as i said in the firstg post, it works fine for shorter edits but seemingly does nothing when a lot is entered...

luke

[thoand]

It looks ok, but you don't need to have the id in the action
just do:

action="editarticle.php"

I don't think that is your problem

in the updating script try to remove the parentheses

eg.

$result = mysql_query("update news set headline ='$headline', content ='$contents' where id='$id'",$db);

Thomas A.

[Lcousins]

Hi again,

thanks for the responce, unfortunately that is making no difference and checking through all my updating scripts none of them are working properly it appears. 🙁

m.

[thoand]

Check these:

1.
What is your post_max_size in your php.ini?
default is 8M, which is a lot.

2.
What fieldtype is content?
Use the TEXT type if it is going to store lot of asci data

best regards Thomas Andersen

[Lcousins]

Hi again, sorry for dragging this one back up, I still havent sorted it out but the question has changed.

Ive checked the PHP settings, my post_max_size is indeed at '8M'
and I am using 'TEXT' as my field type so I started putting in individual values to see what worked and what didnt.

Ive now narrowed it down to infact not being size but being --> ' <--

now whenever I use a ' in an article it doesnt come up, yet I can go into phpmyadmin and put in exactly the same article and it goes up fine.

So the altered question is now, can anyone tell me what is going wrong and is there a way to get round it?

thanks

Lcousins

[thoand]

If I get you right, I think the problem is that you have to escape your quotes befro inserting to the database:

try:

$newArticle = addslashes(stripslashes($article));

And add newArticle to the database

INSERT INTO my_table (id, article) VALUES (NULL, ".$newArticle." etc. etc. etc.);

regards Thomas