At 11:42 -0600 6/12/02, Jas wrote:
>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)) {
$record isn't defined anywhere. Do you mean $sql_content?
> $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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
