Sanity Free Coding

Ahh, then I clearly misunderstood that part, so, the first title in title='$title' specifies the column? I tought it was a system that would tell the database to call the old title, then change it to the new title, as set in the row $title.

So, it seems that the error I've had is that I've double echoed it, it should be like your query up there says, as of where I would have the dollar sign before what is supposed to be the column name as well as having it in the updated content.

I will test it as soon as the FTP will allow me to connect again, damn this internet.

Butcher :

Ahh, then I clearly misunderstood that part, so, the first title in title='$title' specifies the column?

Butcher :

So, it seems that the error I've had is that I've double echoed it, it should be like your query up there says, as of where I would have the dollar sign before what is supposed to be the column name as well as having it in the updated content.

id | title | category| author | content1 | date
---------------------------------------------------
3  | foo   |  bar    |  me    |          |

so the update statement tell what columns need to be updated, and the new values to add.

update my_table set title="new foo", category="new bar"

will set every row's title column to "new foo", and every row's category column to "new bar". 

adding the WHERE clause, allows you to specify which row you want to change. 

it would be really difficult and inaccurate if the database just matched and replaced random column values based on values given in a query (you can sort of do this, but the syntax is quite a bit different), seeing as how its not uncommon for databases to hold gigabytes of data, you have to tell it what column you wish to update, and what the value it needs to update with, as well as what row you want this to affect.

Yes, I used XAMP for some time, to test it. I will reinstall

But, as far as it seems, it is now down to smaller details like what type of sign I use where, and if it is lower case or capital letters. The basic syntax I am using, should work, shouldnt it?

Hmmm, I've tested a lot with XAMP now, and it still does not work correctly. As far as I've understood, the syntax I am using should work, it goes like this:

I open the file "edit_news.php", and it successfully queries the database:

<?php
mysql_select_db ("danwew_news");
$result = mysql_query("SELECT * FROM news ORDER BY ID DESC LIMIT 4");

while($row = mysql_fetch_array($result))
  {
$row['id'];
echo "&nbsp;";
echo "<a href=\"select_news_edit.php?ID=$row[id]\">$row[title]</a>";
echo "<br />";
  }
?>

I click the link, which takes me to the file "select_edit_news.php", and again successfully queries the database:

<?php
mysql_select_db("danwew_news");
$sql = "SELECT * FROM news WHERE ID = '".mysql_escape_string($_GET['ID'])."'";
$result = mysql_query($sql);

while($row = mysql_fetch_assoc($result))
  {
  echo $row['id'];
  }
?>

Then, I press the submit button and it uses the "POST" function to send the information to the file "process_edit_news.php", which is where I think the problem is;

<? 
mysql_select_db("danwew_news") or die(mysql_error()); 
$id= mysql_real_escape_string($_POST['id']); 
$title = mysql_real_escape_string($_POST['title']); 
$category = mysql_real_escape_string($_POST['category']); 
$content1 = mysql_real_escape_string($_POST['content1']); 
$author = mysql_real_escape_string($_POST['author']); 
$date = mysql_real_escape_string($_POST['date']); 
$ip = mysql_real_escape_string($_POST['ip']); 

$query = "UPDATE news SET title='$title', category='$category', content1='$content1', author='$author', date='$date', ip='$ip', WHERE id='$id'";
echo $query;
?>

The syntax is correct according to all sites and tutorials I can find, it is put up with "column name='$new content'", and the column names correspond with the database (case sensitivity as well). And it is obvious that the $query should update the specified columns with the new content from the previous page, and that the function WHERE id='$id' should choose the row in the database that I just edited the content for. But why, oh why, wont it work?!

Ran it by the SQL query, and got this:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id='1'' at line 1

Last edited by Butcher (29 Mar 2007 1:30 pm)

Ran the query with the PHPMyAdmin query page again, and got the same message:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id=1' at line 1

And this time there were no quotes by the id as you can see.

Hot damned, it worked! I always tought that WHERE was considered a seperate part of the columns because it actually is a column... PHP sure is cunning.

Ok, will do , finally works. By the way, you wouldnt happen to know how I can get a music player on a site without needing plugins and making it triggerable? I looked at the code for background music (figured I could get a button to trigger it to start somehow), but it only works for IE and Netscape, and most other methods require a plugin. Problems with plugins are that they have a habit of not working on all browsers or being disabled on a lot.