Not sure how to over come this,  the result of a database query keeps giving
me this:
<?php
/* Get Ip address, where they came from, and stamp the time */
if (getenv(HTTP_X_FORWARDED_FOR)){
    $ipaddy = getenv(HTTP_X_FORWARDED_FOR);
} else {
    $ipaddy = getenv(REMOTE_ADDR); }

$referrer = $HTTP_REFERER;
$date_stamp = date("Y-m-d H:i:s");

/* Start session, and check registered variables */
session_start();
if (isset($HTTP_SESSION_VARS['ipaddy']) ||
isset($HTTP_SESSION_VARS['referrer']) ||
isset($HTTP_SESSION_VARS['date_stamp'])) {
 $main = "Video clips stored in Database";

/* Insert client info to database table */
 require('/path/to/connection/class/con.inc');
      $table_sessions = "dev_sessions";
      $sql_insert = "INSERT INTO $table_sessions
(ipaddy,referrer,date_stamp) VALUES ('$ipaddy','$referrer','$date_stamp')";
      $result = @mysql_query($sql_insert,$dbh) or die("Couldn't execute
insert to database!");

/* Pull video info from database table into an array */
  $table_content = "dev_videos";
  $sql_content = @mysql_query("SELECT * FROM $table_content",$dbh);
     while ($row = @mysql_fetch_array($record)) {
        $id = $row['id'];
        $file_name = $row['file_name'];
        $file_size = $row['file_size'];
        $file_properties = $row['file_properties'];
        $file_codec = $row['file_codec'];
        $file_author = $row['file_author'];
     $result = @mysql_query($sql_content,$dbh) or die("Couldn't execute
query on database!");

/* loop through records and print results of array into table */
      $current .=
"<tr><td>$id</td><td>$file_name</td><td>$file_size</td><td>$file_properties<
/td><td>$file_codec</td><td>$file_author</td></tr>"; }
  } else {
  /* Start a new session and register variables */
  session_start();
  session_register('ipaddy');
  session_register('referrer');
  session_register('date_stamp'); }
?>
Just to make sure everything is working correctly I have echoed every
statement to the screen so I may see what's going on like so:
<?php echo $main; ?>
<table width="75%" border="1">
<?php echo $current; ?> // my results should be here but instead I get
Resource ID #2 printed???? wtf?
</table><br>
<?php echo $ipaddy; ?><br>
<?php echo $referrer; ?><br>
<?php echo $date_stamp; ?><br>
<?php echo $sql_insert; ?><br>
<?php echo $sql_content; ?><br>
<?php echo $id; ?><br>
<?php echo $file_name; ?><br>
<?php echo $file_size; ?><br>

Any help would be great!
Jas



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to