[SOLVED] Update MYsql and PHP

[TheFilmGod]

How can I update a whole row at a time. I know you can update each value one at a time, but I want to do the whole row, a lot like insert does it!

 

This is what I got so far:

 

$query="UPDATE DOCS SET notes=$notes where title=$title";

mysql_query($query); 

 

- I'm a noob.

[Jessica]

First of all, you need to use quotes around strings.

Secondly, it's

$query="UPDATE DOCS SET notes='$notes', column2='$col2' where title='$title'";

[TheFilmGod]

Thanks for the fast reply!

 

I had another question. I currently fell into a trap with my script.

 

Mysql table:

 

id | title | des | notes

 

I have the title of the row and I want to find out the id. So title = $title. How would I query the mysql table to find the row where title='$title' and then retrieve the id of that row?

[Jessica]

Have you heard of SELECT?

 

I think you need to read some basic MYSQL tutorials.

[TheFilmGod]

Have you heard of SELECT?

 

I think you need to read some basic MYSQL tutorials.

 

Yes I have. But its confusing. I just got in mysql and php. And I have this huge book that talks everything about php and when it gets to mysql it totally wings it. The mysql chapter takes like 20 pages. And the whole book is over 700.

 

This is what I think will work:

 

$id_row = mysql_query ( "SELECT * FROM docs WHERE title='$title'");
	mysql_fetch_assoc($id_row);

 

If that works I know how to go on from there. All I want to do is select the row where title='$title'

 

Sorry if I'm bothering you with such a newbie question, I'm just stupid...

[Jessica]

If the book you have doesn't answer your question, try another book, or google, or heck the DOCS.

Did you TRY your query?

[TheFilmGod]

Yup, the query should work. I'm going to finish the script and then check it out.