Question?

[tuffguy24]

Hello,

I am very new at this and I'm doing this as a fun learning thing. So far, I've been able to pick up on a lot of the PHP stuff when using it with a MySQL database. I only have a book and what I know is from that book, but I've also found a lot of answers to some of my questions (roadblocks) just by reading messages in this forum.

My question is...How can I take the results from an array and have them be the input text on another form? For instance, if I want to find a record in my database of baseball cards, I do a search for "David Bell". So, I get a result that shows me the record of the card(s) I have of David Bell. My result shows me that I have one record of a card of David Bell from last years SF Giants, but this year David Bell is playing for the Philadelphia Phillies.

I want to be able to have the results from the search show up in another form so that the results would be the input text on the new form so that I can be able to either delete or modify the record? Ideally, I would want to have two buttons on the bottom so that if I just wanted to change the team name, I could go to the "team" field and type over SF Giants and replace it with Phillies and hit a modify button and have the query submitted to the database or just simply have all the results from the search be in the fields so that I could just simply hit the delete button and query the database to remove the record.

Can someone help me out with this?

Thanks in advance.

[Pig]

Query the information from your database, and load them into an array with mysql_fetch_assoc. Then display the form with the array components as the values for each item.

eg:
echo("
<input type=text value=\"$row[some_field]\">
");

note the escaped quotes: value=\"blah\"
always use quotes around your values.