mad_php

main window B opens from a page deep in the site. Unfortunately the unonload event is run inside a header that is included throughout the site.

Hi, I have two windows i'm working with. When window B opens off the parent window A. Window A has to be open all the time while window B is open. If the user closes down window A, window B need to close also. I have a javascript function inside Window A that is launched on the onunload event. function closePopup(){ main.close(); } main is the name of window B. I keep getting error message when i load window A, it says main is undefined. So basically I want to be able to check to see window B is open before running main.close() Can anyone help me? Thanks --Mark

anyone?

Hello, I have a dell powervault tape backup connected by scsi to my debian server. I can access it ok, using the mt and tar commands, and think i have a backup working through webmin. But im limited as to what i can do with webmin. I'm a complete tape newbie, but was wondernig if there is better software out there to administer my tape backups. Is there a better way to browse and adminisiter my backups on the tape? Can anyone recommend any good software? Thanks --Mark

Hi i need help. I want to know how to install extension that give me the ability to open and read zip files Thanks

put double quotes inside header.

how do i pass a variable into a header function. ie header( 'Location: $address' ); it keeps coming up with http://mysite.com/directory/$address

Solved it SELECT a.user_id,u.username,u.email,u.firstname,u.surname,u.active, a.logtime FROM transaction_log AS a LEFT JOIN transaction_log AS b ON a.user_id=b.user_id AND a.logtime<b.logtime JOIN users AS u ON u.id=a.user_id WHERE b.logtime IS NULL AND u.guest = 1 ORDER BY a.user_id

Hi, I'm trying to to extract information from two tables. A users table and a log table. The log table logs all user logins. I'm trying to get a list of all users and when they last logged in. I've came up with the following query so far and it returns all log in times. I just want the last login time. SELECT users.id,users.username,users.email,users.firstname,users.surname, transaction_log.logtime FROM users,transaction_log WHERE users.id = transaction_log.user_id AND users.guest = 1 AND transaction_log.log_category_id = 1 ORDER BY transaction_log.id I've tried TOP 1, but it only returns one record instead of one per user. Also, can someone tell me how i can pull the results from the query analyzer in MS SQL to something like Excel. If you need more info let me know.

how do i check? here is my db.class.php <?php $dsn = 'mysql:dbname=db;host=localhost'; $user = 'user'; $password = 'password'; try { $dbh = new PDO($dsn, $user, $password); } catch (PDOException $e) { die('Connection failed: '.$e->getMessage()); } ?>

yes that closed quote is there. I dont know if the length of the rows are zero. How do i check for that?

ok. now we're getting somewhere. hahaha. I'm not getting any obvious errors so i'm suspecting the db connection parameter might be incorrect. Does persisting the connection have anything to do with whats happening to me? Here is my db connection parameters. $dsn = 'mysql:dbname=mydb;host=myhost; $user = 'username'; $password = 'password'; try { $dbh = new PDO($dsn, $user, $password); } catch (PDOException $e) { die('Connection failed: '.$e->getMessage()); }

this is a php forum. I'm having problems accessing the database. The SQL works, so i was forced to come to a php forum.

can you take my word for it that the SQL works correctly outside of the php?

$sql = 'call news_get_proc(:news_id)';