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] 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] 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\" /] 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
Archived
This topic is now archived and is closed to further replies.