Jump to content

I dont understand this.. This script works but wont echo to screen


Phpwho

Recommended Posts

I have this code working, but it just wont print to the screen.

My editors can not find any errors either!

Help Please!!

 

<?php
$PID = $_POST['Personal_ID'];
$con = @mysql_connect("cefdata","root","");
if (!$con)
  {
  die('Could not connect: ' . @mysql_error());
  }
$query = "INSERT INTO clockers.clocked (Personal_ID, First_Name, Last_Name, Division) SELECT Personal_ID, First_Name, Last_Name, Division FROM clockers.employees WHERE Personal_ID='{$PID}'";
$results = @mysql_query($query);
while ($reg = @mysql_fetch_array($results))
       {        
            $clockerid =  $reg["Personal_ID"]; 
            $fname =  $reg["First_Name"]; 
            $lname =  $reg["Last_Name"];                         
            $depart = $reg["Division"];
echo $fname . " " . $lname;
echo "<br />";
  }
@mysql_close($con);
?>

No luck... This way makes the print out but wont write to the database:

 

<?php
$PID = $_POST['Personal_ID'];
$con = @mysql_connect("cefdata","root","");
if (!$con)
  {
  die('Could not connect: ' . @mysql_error());
  }
$query = "INSERT INTO clockers.clocked (Personal_ID, First_Name, Last_Name, Division) SELECT Personal_ID, First_Name, Last_Name, Division FROM clockers.employees WHERE Personal_ID='{$PID}'";
$yellhi = "SELECT Personal_ID, First_Name, Last_Name, Division FROM clockers.employees WHERE Personal_ID='{$PID}'";
$results = @mysql_query($yellhi);
while ($reg = @mysql_fetch_array($results))
       {
            $clockerid =  $reg["Personal_ID"];
            $fname =  $reg["First_Name"];
            $lname =  $reg["Last_Name"];
            $depart = $reg["Division"];
echo $fname . " " . $lname;
echo "<br />";
  }
@mysql_close($con);
?>

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.