Jump to content

PHP and MYSQL help...


yknip

Recommended Posts

Hello everyone, need some help here..  :-[

 

Below are my codes..

 

-----------

$date = array("1001", "1002", "1003");

$sql="select ID from fid;";

$result = mysql_query($sql) or die("Query failed : " . mysql_error());

while($row = mysql_fetch_array($result, MYSQL_NUM)) {

  $test_id = $row[0];         

  foreach ($date as $datex){

    $sql2="UPDATE tbl1 SET date1=(SELECT date1n FROM dat".$datex." WHERE ID=".$test_id.")";                   

    mysql_query($sql2);

-----------

 

I have tables 'dat1001','dat1002' and 'dat1003'. I want to get some values from that table and store them in another table ' tbl1'.

 

It is updating but the values are zero.

 

Thanks in advance...

Link to comment
https://forums.phpfreaks.com/topic/262054-php-and-mysql-help/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.