FAILED TO INSERT DATA FROM FUNCTION();
HELLO, I HAVE A PROBLEM TO INSERT DATA FROM OUTPUT FROM FUNCTION()...
I WANT TO STORE THE OUTPUT IN DATABASE, BUT FAILED TO INSERT...
===============================================
BELOW IS MY FUNCTION() CODE, academiaTotal.php
===============================================
<?php
$page = 'fkpacademia.php';
//connect db
function totalMac_ac1(){
$query1 = "SELECT AVG(MAC) FROM academia1";
$result1 = mysql_query($query1) or die(mysql_error());
while($row1 = mysql_fetch_array($result1)){
echo "".number_format($row1['AVG(MAC)'],1);
$sql = "INSERT INTO fkpacademia (MAC) VALUES ('$row1['AVG(MAC)']')";
}
}
---?>
======================================
MY CALL FUNCTION fkpacademia.php
======================================
<?php require 'academiaTotal.php' ?>
<? totalMac_ac1(); ?>
**********************************************
MY PROBLEM NOW IS THE sql(INSERT, (AVG(MAC) output... )) NOT SUCCESS... NO DATA INSERTED IN fkpacademia table.. AND I WANT TO UPDATE ALWAYS (AVG(MAC) from academiaTotal )... (MEANS THAT fkpacademia only have 1 record of AVG(MAC)...)
hope anyone can help me...
Subject
Written By
Posted
FAILED TO INSERT DATA FROM FUNCTION();
March 20, 2011 05:07AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.