MySQL Forums
Forum List  »  PHP

FAILED TO INSERT DATA FROM FUNCTION();
Posted by: siti nuraini abd kadir
Date: March 20, 2011 05:07AM

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...

Options: ReplyQuote




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.