[RESOLVED] Adding data to MySQL from a table

[jc87]

Hi guys -

I'm trying to utilise an 'ADD' button on a table of results, but I am having trouble inserting the data from that table.

This is my code so far - http://rafb.net/p/gWC2DF23.html

At line 78, it's not allowing me to insert that; $row[Food_Name].
(If I change it to Food_Eaten1 = 'test', it works fine)

I think it's because I'm using a while loop for the search, so when Add is clicked it's not recognising which line or array data I'm trying to add? I'm definitely missing something but can't think what.

Any help would be appreciated.

🙂

Thanks.

[Krik]

"$row[Food_Name]" is not defined. The "if", that he while loop is in, will not be ran when you click the ADD button. Best bet is to pass that data in a hidden input field when ADD is clicked.

<input type="hidden" name="foodname" value="<?php echo $row[Food_Name]; ?>">

[bradgrafelman]

Also note that $row[Food_Name] should be $row['Food_Name'].

[jc87]

Thanks guys, have now got it up and running :-)

[bradgrafelman]

Don't forget to mark this thread resolved (using the link under Thread Tools).