Update wont work on my server....

[ajdegans]

Hi folks, just a question.... a bit server config related

Does anyone know how it can be mysql doesnt accept all commands?

Im learning mysql and run into trouble when it comes to update a record (is it called that?) Then when i try the code on another server its just working fine...

Now the real problem is i dont know shit of configuring a webserver and ini files and all...

So if anyone has an idea .... 😕 i would be glad!

I figured you need some specification about my server!
http://www.zerocom.ath.cx/systems.php?act=server
It's all there.

Really hope some one can help me :queasy:

[bastien]

Show the code, its likely a code error, more so than a mysql error

[ajdegans]

<?php
   if(isset($_POST['submit']))
   {

  $title=$_POST['title'];
  $text=$_POST['text'];
  $index="UPDATE `a_index` SET `maintitle` = '$title', `maintext` = '$text' ";
  mysql_query($index) or die(mysql_error());
  print "Index pagina bewerkt. <a href='index.php'>admin pagina</a>.";

   }
   else
   {  

      $getindex="SELECT * from a_index";
      $getindex2=mysql_query($getindex) or die("Could not get index");
      $getindex3=mysql_fetch_array($getindex2);
      ?>
	  <form action='editindex.php' method='post'>
	  <input type='text' name='title' value='<?php $getindex3['title'] ?>' size='50'>
      <br>Put custom right block here(HTML allowed):<br>
      <br><textarea name='text' rows='30' cols='80'><?php $getindex3['text'] ?></textarea>
      <br>
	  <br><input type='submit' name='submit' value='submit'></form>
	  <?php
   } //end if isset
?>

This is it... But like i said on another server it seems to work...

[bastien]

try taking the backticks off the field names...otherwise code looks ok

if you're not dutch, you're not much

[ajdegans]

Originally posted by bastien
if you're not dutch, you're not much

what the?

[tsinka]

Hi,

which error do you get ?

Besides that the problem might be that the text might contain single quotes which would break up the SQL query.

Try to use mysql_escape_string:

if(isset($_POST['submit'])) {
  $title=mysql_escape_string($_POST['title']);
  $text=mysql_escape_string($_POST['text']);
  $index="UPDATE `a_index` SET `maintitle` = '$title', `maintext` = '$text' ";
  mysql_query($index) or die(mysql_error());
  print "Index pagina bewerkt. <a href='index.php'>admin pagina</a>.";
} 
....

Thomas

[ajdegans]

I get no error. thats the freaky thing...

It just does what its suppose to do, saying its updated but then i go look on the site and i see nothing... so its not updated.

Then i looked into phpmyadmin on the record and it appears to be empty....

then a big 😕 arrised.

I will try your idea though, later today
:p

[tsinka]

Another question ... is there only one record in the table ? I wonder if there's a WHERE clause missing to specify which record you want to update...

Thomas

[ajdegans]

heres the table:

a_index
|
|- maintitle (bigint 20)
|- maintext (longtext)
|- new_title (bigint 20)
|- new_text (longtext)
- new_date (date)

with the code posted earlier we should be able to update maintitle and maintext.... further code to update the other fields does not excist yet...

[tsinka]

Yes,

but if you have more than one record in the table and just execute

UPDATE a_index SET maintitle='$title',maintext='$text'

this query would update the maintitle and maintext of all records in the table which might not be what you want to do.

Thomas

[ajdegans]

so what do you suggest?

remember, im a total newbie on mysql..:mad:

[tsinka]

That definitively depends on the kind of application you want to develop. Tell me something about the application.

One way would be to add a primary key (auto_increment) field to the table. Each record would then have a unique id (1,2,3,....) and you can reference the record you want to update by using that field in your query like e.g.

UPDATE a_index SET maintitle='$title',maintext='$text' WHERE idfield='5'

But I need to know more about your application 🙂

Thomas

[ajdegans]

Ok, i understand 🙂

Well the idea is to create a website with an administrator area.

From that admin area the user should be able to update/change the text on the page...

As you maybe can see in the code i posted earlier its a input field and a text area. which are for the mainpage the title and text under that title...

So the supplied code wil not create new records, ONLY update that one excisting record...

I thought of a fairly simple db structure.
A table for the admin login
table for each page...
and some random info that can be used accross the site...so in this case there is like 8 or 9 tables i think... im adding more along with the code i finish...

Hope this clearafies a bit 😉

I understand the WHERE command specifies the records location?
So for some tables its not nessecary i think... just 2 rows (title and text)

[ajdegans]

this drives me fucking nuts!!!!

THE UPDATE WORKS

But, not on code i write/copy...

I tried something today. copying a excisting code which i tested first and foudn working...

Anyway, i copied the code altered it a bit to make it work in another table and such and dang update does not work anymore?

HOW CAN THIS BE?
Im sick and tired of damn ass mysql at this point. Why doesnt it just work! :mad: :queasy: :glare:

[tsinka]

How does the modified code look like ?

Thomas

[ajdegans]

i posted the modified code in my first post

gotta run now... work🙁

[tsinka]

Do you still have that update problem ?

[ajdegans]

not sure... i found a fault in the database... using bigint for a piece of text doesnt work. DUH!

Right now im not really experiencing any problems... but i was still testing it 🙂

Though i have a question. In order to use the UPDATE command successfull must there be excisting data in de record of the db?

So a empty DB row cannot be updated...

😕

Also i want to thank you for your attempted support 🙂

[tsinka]

UPDATE only works on existing records. Execute an INSERT query if you want to have data in the table that doesn't exist.

Records exist in tables, not in databases. And you can have more than one record in one table so make sure that you have a field that uniquely identifies the records in a table. You can add an auto_increment bigint field to the table to do that. That field will be incremented automatically each time you insert a new record.
You can then use that id if you want to update that record later, like

UPDATE thetable SET field1='value1',field2='value2' WHERE idfield='1'

google around to find tutorials on MySQL like this one

Thomas

[ajdegans]

yea i said it kinda wrong 😉 but we meant the same 🙂)

There was another problem... i tried to update things that didnt excist... ohwell 🙂 i guess i need to learn alot lol:queasy: