just one thing missing

itworks

hi, i'm developing this admin site where 10 judges have access to by login/password using session.

the main page is just a table with a column for the site url with a link then 10 columns (one for each judge) and then a total column. each row will be a submited site.

i have accomplished all of this so far and that for the user who has logged in to have a drop menu in his column for each row that still hasn't been voted.

now i need the most important part:

when the judge chooses all the votes from the drop menus for the sites and then hits the submit button at the end how do i cast the votes and put them into that judge column for that row(site) in the database.

it's a problem of assigning a name to each field so that i can do the update query in the next page.

thanks in advance!

ucbones

Hi,

Wouldn't have thought it would be too difficult:

once the form is submitted, on a process page, add something like...

 $link = mysql_connect("mysql_host", "mysql_user", "mysql_password")
     or die("Could not connect");
    mysql_select_db("my_database")
or die("Could not select database");
$sql="UPDATE tbl_name SET judgecolumn='$judgevalue' WHERE ID='$urlid'";
$mysql=mysql_query($sql);
if ($mysql){
echo "Vote added successfully";
}
else {
echo "Vote failed, database problem";
}

Where tbl_name is the name of the table your storing vote details, judgecolumn is the column you are using to store details for the relevant judge, $judgevalue is the name of the select field you are using, ID is the name of the column storing the ID of the URL, and $urlid is (rather obviously) the ID for the row which stores the votes for the url.

Hope that helps,

ucbones

itworks

thanks for your reply but that part is already made a long time ago and i didn't had any trouble with it, just a normal query thing, the problem (either i didn't explain good enough or you didn't understand) before that, how to assign an unique name or something to each drop menu for each row that contains a certain value chosen and how to receive that do i can then make this query.

thanks in advance!

Zack

in a drop menu, you have the code:

<option>Vote 1</option>
<br>
<option>Vote 2</option>

well add "values" to the option tags...

<option value="vote_1">Vote 1</option>
<br>
<option value="vote_2">Vote 2</option>

then the variable for option 1 is '$vote_1' and option 2 is '$vote_2'

itworks

i must be really dumb or maybe i should have completed that english course... :rolleyes:

did you read the first post?

i have 10 different columns and hundreds of different rows and i need a drop menu for each one, if i follow your though i will just insert the same value for the last one in all of the others, again:

i need to assign some kind of difference to each one.

but anyway thanks at least you tried to help, you just didn't understand what i wanted first.

leatherback

Hi,

I suppose you need something like:

<select name="test1">
  <option value="1">1</option>
  <option value="2">2</option>
</select>


<select name="test2">
  <option value="1">1</option>
  <option value="2">2</option>
</select>

Zack

then just give each drop-down menu a name, so its:


<option value="drop_1_value_1"></option>
<option value="drop_1_value_2"></option>

<option value="drop_2_value_1"></option>
<option value="drop_2_value_2"></option>

itworks

of course... why didn't i though of it?

just HAVE TO GUESS how many (from 0 to infinity) DROP MENUS TO PUT IN THE CODE, you're a genius...

it's a shome though that this is supposed to be dynamic (that's why we use PHP) and i want to create just one and then loop it, AND THAT'S WHAT I REALLY DON'T KNOW HOW TO DO, ASSIGN A NAME FOR EACH DIFFERENT DROP MENU OF EACH ROW.

Zack

get angry about it...

now that i understand what you want, im not gonna help anymore.

itworks

LOL, that's easy to say now :p

and like you were really helping, well i must say you were trying, i give you that :rolleyes:

leatherback

OK,

Here goes.

FIRST:
Everybody here is being nice enough to spend some time helping other people. Since we cannot understand what you <obviously?> cannot do.. perhaps you might spend some time thinking about why you are asking help. If it is complicated, make sure you describe the problem exactly. Dont start shouting.

SECOND:

This is something like what you COULD do.:

Each row with a URL for which has to be voted has an ID. You can use this ID to name the options:

Select * from table

blablabla

while ($row =@ mysqlfetcharray.....blablabla .....)
{
<select name=$row[id]>
<option value="1">1</option>
<option value="2">2</option>
</select>
}

Subsequently use that to submit:
for each $_post[]

insert into table ($judge) values ($value) where id = $key

Or something along those lines. With a bit more time I am sure you can figure it out. To be honest: I do not feel like spending a lot of time on a solid reply for you, if you start shouting about if two people misunderstand the problem...

Check the foreach function, the $_post function, and combining the 2, along the lines of above example, will give you the solution. Or come back later with some worked-out ideas, and try again. Ask nicely. People here are doing this for free, to help other people. Please remember that.

itworks

thanks a lot for taking the time to reply and for understanding what i ment.

i had tried that exact aproach but i must have done something wrong in the middle i think in the foreach part, that's why i posted this thread 'cause i thought that maybe i got it completly wrong and that wasn't the right track.

thanks, i think that with this i at least know that it is the right way to do it.

leatherback

OK,

Good luck.

I'll be online again next weekend, in case you want somebody who understands the situation ;-)