Array from Database

Anon

Ok I am just fumbling along here and cannot seem to figure out how to do this.

Desired Outcome:
To add an image to an uploads folder and pass along two variables verifying where this image will be pulled. This is all via a web page administration option.

First I connect to the database and a list is generated in this format

Radio Button - Image Name [Camera Image}

The camera image shows if the Image Name already has an uploaded image that it is assigned to.

My problem is how do I pass an array value and then read it from a database pull. Here is the code:

$result = mysql_db_query ("Database", "select Title, WebPageID, SubLevelID FROM $table ORDER BY WebPageID ");
while ($row = mysql_fetch_object($result)) {

print "<font color=\"#000000\" face=\"verdana, arial, helvetica\" size=\"1\">";
print "<tr><td valign=\"middle\" width=\"20\"><input type=\"radio\" name=\"Choice[]\" value=\"$row->WebPageID[$row->SubPageID]\">";
print "</tr><td>$row->Title<img src=\"camera.jpg\">";
print "</td></tr></font>";

Basically I am trying to send 2 seperate values in one array called choice. I have found a lot of docs on how to create and pull from an array. I however have not found much on web generated and database generated arrays.

Thanks,
Bill

[deleted]

One of your problems may be that you are quoting variables when you print them.
This is bad, stop doing it.

Second, database cannot contain PHP arrays, only strings and interegers (and som alternatives like blob and inet, which are fancy versions of strings and integers)

So my first question would be:
What are you storing, and how do you think you are storing it.

and my second question:
What exactly are you trying to retreive?

A forum, a FAQ, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

Anon

I think my explanation botched up what I was doing. Let me try again.

I am pulling two numbers from the database a WebPageID and SubPageID. These determine what page the image shows up on. I want to assign them to a list of radio buttons. The name of the radio button is Choice[] with a value of $row->WebPageID[$row->SubPageID] this way each one is unique. Then when the form is submitted I want the database to save WebPageID and SubPageID as two seperate values that are just directions.

The site I have designed is only 3 pages. All those pages pass a WebPageID and a SubPageID. The database shoots out the html for that specific page so each page has its own features.

Does that make sense.....I just cannot figure out how to create an array with a radio button then pass it in a form and insert those two numbers into there correct location.