Richard Lynch wrote:
Just add another array for each with $artist as the key.while ($artist, $vote, $email) = mysql_fetch_row($results)){
I think you ment
while ( list($artist, $vote, $email) = mysql_fetch_row($results) ){
$votes[$artist] = $vote; $emails[$artist] = $email; } Although, actually, there is probably some better ways to do what you are doing, but with only the query to look at, it's hard to tell... On Mon, February 26, 2007 6:13 am, Steven Macintyre wrote:Hi all, I am working on a project for someone and with the brief I received before - I created a record per action with the following information; Artist[tab]artist[tab]artist[tab] etc as a entry for "artists" Then I have the same for titles etc ... What I have been doing is creating the array's and combining them ... with artist as a key and song as a value... Now ... they are requesting that I have the an additional 3 fields ... how would I now accomplish this? Bear in mind its php 4 and I am using a combine_array generic from the www.php.net site in lieu of array_combine. I have paste a sample record below; INSERT INTO ` votes_records` (`id`, `date`, `who`, `title`, `description`, `image`, `email`, `artists`, `titles`, `votes`, `weeks`, `twoweekpos`, `oneweekpos`, `debut`) VALUES (22, '2007-02-26 12:29:15', 1, 'Test Again', '', '', '', 'Artist 1Artist 2', 'Song 1Song 2', '1', '51', '20', '10', '2005/02/092005/02/09'); The net effect that I need to get - is take that information and display it per item so people can vote. S -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- Enjoy, Jim LucasDifferent eyes see different things. Different hearts beat on different strings. But there are times for you and me when all such things agree.
- Rush -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

