Is there any special way for variable++?  
Index ‹ php-general
Author Message
typingcat
PostPosted: 2005-10-22 18:51:00 Top
php-general, Is there any special way for variable++? Say I have a table in a MySQL server
ID USERNAME COUNT
0 JOHN 2
1 JANE 3
2 HOMER 3
3 MOE 2

If I want to increase Homer's count by 1,
The plain way would be;
1)$TEMP=SELECT COUNT WHERE ID=2
2)$TEMP++
2)UPDATE .. SET COUNT=$temp...
I guess if there is any special way to increase the int value by one?
For increasing 1 is so commonly used (that's why c,c++,java,C# has the
operator ++).

 
Ewoud Dronkert
PostPosted: 2005-10-22 18:58:00 Top
php-general >> Is there any special way for variable++? email***@***.com wrote:

> Say I have a table in a MySQL server
> ID USERNAME COUNT
> 0 JOHN 2
> 1 JANE 3
> 2 HOMER 3
> 3 MOE 2

Generally, it's a bad idea to give a column a name that is also a sql
preserved word (count).

> If I want to increase Homer's count by 1,
> The plain way would be;
> 1)$TEMP=SELECT COUNT WHERE ID=2
> 2)$TEMP++
> 2)UPDATE .. SET COUNT=$temp...

No, you would let the database do the work:

UPDATE Tablename SET count=count+1 WHERE id=2

May need `` around count, because of problem mentioned above. See
http://php.net/mysql-query and
http://dev.mysql.com/doc/refman/4.1/en/update.html

> I guess if there is any special way to increase the int value by one?
> For increasing 1 is so commonly used (that's why c,c++,java,C# has the
> operator ++).

Yes, that operator also exists in PHP:
http://php.net/manual/en/language.operators.increment.php

--
E. Dronkert
 
jkimball4
PostPosted: 2005-10-24 4:50:00 Top
php-general >> Is there any special way for variable++? you can do this in the mysql itself depending on what server version
you are using. try update .. set count=count+1 where id=2 and
username="homer";

email***@***.com wrote:
> Say I have a table in a MySQL server
> ID USERNAME COUNT
> 0 JOHN 2
> 1 JANE 3
> 2 HOMER 3
> 3 MOE 2
>
> If I want to increase Homer's count by 1,
> The plain way would be;
> 1)$TEMP=SELECT COUNT WHERE ID=2
> 2)$TEMP++
> 2)UPDATE .. SET COUNT=$temp...
> I guess if there is any special way to increase the int value by one?
> For increasing 1 is so commonly used (that's why c,c++,java,C# has the
> operator ++).

 
 
 
Index ‹ php-general