insert function with limit

[Anonymouz]

Can I use insert with the same option as a query

example:

$query = "select optionCount from mpn_poll_data order by pollID desc , voteID asc limit 0,1";

---

$result = mysql_query("insert into mpn_poll_data
(optionCount)order by pollId desc , voteId asc limit 0,1 values ('$b')");

I want to insert something to this exact location in the table...is this possible?

[kevinsequeira]

well i dont think the syntax is right. why would you want to insert into a particular postion in the table [ im not sure if thats possible]

if you explain what you're trying to do then we can suggest something

reg
kevin

[Anonymouz]

I want to add up the 1 vote to a particular position in a database, when the data in the database contains 24 voters, and someone votes i add-up 1 and want to put the outcome (25) back in that position.

So that every time someone votes this number increases with 1.

with a query with the order by pollID desc, voteID asc limit 0,1 i can select this position in the database.

But can I use this order by and limit together with a insert?

Example (this doesn`t work):

$result = mysql_query("insert into mpn_poll_data order by pollID desc , voteID asc limit 0,1
(optionCount) values ('$b')");

[Anonymouz]

I realise now that i have to use the update function because there is already data in the database,

but is it only possible to use an updatefunction in combination with the where 'value' option?

I still need an alternative option for the order by and limit