Welcome to WebmasterWorld Guest from 126.96.36.199 , register , free tools , login , search , pro membership , help , library , announcements , recent posts , open posts Become a Pro Member
Insert a value from an array into MySQL php, array, MySQL, select, insert brandozz msg:4468930 3:50 pm on Jun 24, 2012 (gmt 0) Hi all, Wondering if anybody can help me out with something. I'm pulling a value from a table using the following query: $q = "select MAX(id) from rma"; $result = mysql_query($q); $data = mysql_fetch_array($result); echo $data; I have this query working, it pulls that largest id number from the table called rma. Now I want to take the value stored in $data and insert it into a different table. Any thoughts on how this can be accomplished? Simply inserting the variable $data into my insert statement doesn't work.
brandozz msg:4468946 4:41 pm on Jun 24, 2012 (gmt 0)
I was able to get this fixed. I forgot to add the  to the insert query: $sql = "INSERT INTO table SET ref_id='$data';