elie Posted May 18, 2006 Share Posted May 18, 2006 i have stored arrayed fields into the database... i want to create a new page where i can call and retrieve these values stored from the database? please help...[code]<?phpinclude("config.php");$field_a = $_POST['field_a'];$field_b = $_POST['field_b'];$field_c = $_POST['field_c'];$field_d = $_POST['field_d'];$field_e = $_POST['field_e'];$field_f = $_POST['field_f'];$num = $_POST['num'];foreach($field_a as $key => $val) {$sql="INSERT INTO sample (field_a, field_b, field_c, field_d, field_e, field_f, code) VALUES ('".$val."','".$field_b[$key]."','".$field_c[$key]."','".$field_d[$key]."','".$field_e[$key]."','".$field_f[$key]."','$code')";mysql_query($sql) or die(mysql_error());}?>[/code] Quote Link to comment https://forums.phpfreaks.com/topic/9928-how-to-retrieve-values-stored-from-database-mysql/ Share on other sites More sharing options...
ober Posted May 18, 2006 Share Posted May 18, 2006 [code]$query = "SELECT * FROM sample";$result = mysql_query($query) or die(mysql_error());if($result && mysql_num_rows($result) > 0){ while($row = mysql_fetch_array($result)) { extract($row); echo "$field_a<br />"; echo "$field_b<br />"; // etc }}[/code] Quote Link to comment https://forums.phpfreaks.com/topic/9928-how-to-retrieve-values-stored-from-database-mysql/#findComment-36895 Share on other sites More sharing options...
elie Posted May 18, 2006 Author Share Posted May 18, 2006 thanks for the help ober!! [img src=\"style_emoticons/[#EMO_DIR#]/wink.gif\" style=\"vertical-align:middle\" emoid=\":wink:\" border=\"0\" alt=\"wink.gif\" /] Quote Link to comment https://forums.phpfreaks.com/topic/9928-how-to-retrieve-values-stored-from-database-mysql/#findComment-36910 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.