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