Re: UPDATE doesn't work

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thank Jason! It counts now.

So if i want to make something like

Most view tutorial is $row[title] <<<<<< How can i do this?


Regards,

----- Original Message ----- 
From: "Jason Wong" <php-db@gremlins.biz>
To: <php-db@lists.php.net>
Sent: Wednesday, February 05, 2003 1:44 PM
Subject: Re:  UPDATE doesn't work


> On Wednesday 05 February 2003 12:50, Le Hoang wrote:
> 
> > 
> > // Add 1 view to the view column
> > 
> > $v = $row[view];
> > $vplus = $v+1;
> > $view = mysql_query("update photoshop_tutorial where id=$id set
> > view=$vplus"); // Problem here!
> 
> You should ALWAYS check the result of a call to mysql_query():
> 
>  if ($view === false) { echo "Fatal error: " . mysql_error(); }
> 
> 
> Your problem is that the SQL for update is incorrect and it should be:
> 
>   "UPDATE photoshop_tutorial SET view = $vplus WHERE id = $id"
> 
> You can also do the increment inside the SQL so:
> 
>   "UPDATE photoshop_tutorial SET view = view + 1 WHERE id = $id"
> 
> -- 
> Jason Wong -> Gremlins Associates -> www.gremlins.biz
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications Development *
> ------------------------------------------
> Search the list archives before you post
> http://marc.theaimsgroup.com/?l=php-db
> ------------------------------------------
> /*
> Tell a man there are 300 billion stars in the universe and he'll believe you.
> Tell him a bench has wet paint on it and he'll have to touch to be sure.
> */
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux