jhollin1138

I figured out how to refresh an iframe when you close a pop-up window. I know it was easy, just had to stop and think about it. I just had to put the following in the pop-up window. ><form> <input type="button" onClick="opener.location.reload(); self.close()" value="Close"> </form> Now if I can only figure how to keep the pop-up always on top.

This might be an easy one, but for some reason I can't figure out how to do it. I am developing a web based application in PHP and MySQL. On one of the pages I want to have an iframe to display some information in a grid. I need to be able give the user the ability to add and change information displayed in the iframe by utilizing a pop-up window (I will be using Java of course to handle the pop-up). When the user closes the pop-up window, I need to refresh the iframe to display the changes. How do I get the iframe to refresh when the pop-up window is closed? On a side note, is there anyway to force the pop-up window to be always on top of the parent window similar to the way a Java alert is?

Actually I am migrating my existing phpBB forum to SMF. I had a birthday mod installed on my phpBB forum and wanted to bring this information over too. The phpBB birthday mod was storing data as the UNIX timestamp (well not directly) and SMF stores the data as a MySQL date stamp. I wanted to modify the existing conversion query for phpBB to SMF and discovered the problem with negative timestamps. I already wrote a PHP script that queries the phpBB database and updates the SMF database. I was just hoping to be able to modify the existing conversion script then to have to write a new one, which I did.

That is what I was afraid of. I also determined that UNIX_TIMESTAMP didn't support it either. Unfortunately, the query is currently inside MySQL and not coming from PHP. I might have rethink things.

I am trying to write a query but I have run into a snag. I am trying to convert an UNIX timestamp to something MySQL would like. Everything works great if the date is after epoch, but on dates before epoch it doesn't work. For example, I have this query. >SELECT FROM_UNIXTIME( -13391999 ) This should convert to "1969-07-30 00:00:01" however it converts to NULL. How do I convert UNIX timestamps before epoch inside a query?

No problem, thanks for the help!

Thanks for the help but as I said in my first post, I already had that checked. I ended up needing to go to the board permissions and changing it from "local" to "global".

I think I have figured out my problem. It looks like SMF handles permissions total different then phpBB does. I haven't been able to get it working yet, so in the meantime I had to revert back to phpBB.

I recently migrating my phpBB2 forum over to SMF. I want to allow "Guests" to view/download attachments. I was able to find "View attachments" under the permissions for "Guests" and I have it checked. However, when I view me SMF forum as a "Guest" I cannot see the attachments. Is there something I am missing?

I tried your script and it worked fine for me, I would verify your permissions.

I am a Mechanical Engineer. I design high-temperature (800-2200ºF) large (up to 12 feet in diameter) butterfly valves and slide gates for industrial applications (automotive plants, steel mills, chemical plants for example).

If you used cPanel to install it, you should be able to remove it from there. If you installed it manually, just delete the "folder" that contains phpBB and remove the MySQL database using cPanel.

@etriad: Thanks, for the tips, I'll look into them!

Here at work, we are currently using an old custom VB6 application for our data record system. In an effort to try and get things a little more modern and make some required changes, I have been writing a web based application in PHP. To get allot of the functionality I want (and need) I have used JavaScript. I have stumbled through JavaScript part by searching for something similar to what I need online and modifying the Java code to fit my needs. Now, I am not a programmer professionally (I am a Mechanical Engineer), I am self taught. When it comes to coding, I can hold me own and get things done, just takes me a little longer. With my background out of the way I can get down to my problem. I am about 75% done with the application I am working. I am really happy with what I have so far. Even a friend I have who works for a custom application company is impressed. Unfortunately I have hit a brick wall with the last 25%. To get the functionality I really need, I need to get heavy into Java. In researching for some Java that can help me, I have found out about AJAX. Although I could not find something that helps to solves my problems. I am looking for some good reference information to help me learn Java and AJAX. It does not have to be intended for a beginner, intermediate level would be fine. The reference(s) can either be a book or online. Does anyone have any recommendations?

I got it working using the following code for "popWin" and "closepopWin". >parent.frames["searchWin"].morewin=null; function popWin(linkName) { if(parent.frames["searchWin"].morewin != null) parent.frames["searchWin"].morewin.close(); parent.frames["searchWin"].morewin = window.open(linkName, "moreWindow", "width=755,height=600,menubar=no,resizable,toolbar=no,scrollbars"); setTimeout("morewin.focus();",200); } function closepopWin() { if(parent.frames["searchWin"].morewin != null) parent.frames["searchWin"].morewin.close(); } Where the name of the "iframe" I have is set to "searchWin". Thanks for the help!

That is what my problem is. The links that run "popWin" are in an "iframe". The link that will fire the "closepopWin" is on the parent page of the 'iframe". So that means that the parent page isn't seeing the variable set by the "iframe's" pop-up window. That would explain why the pop-up window will close and reopen with the new data when another link is selected in the "iframe". I have tested it by putting a link to "closepopWin" in the "iframe" and sure enough it worked. Anyway around this problem?

Thanks for taking a look. I can't seem to find any problems with my code. Here is a sample link I am using to run "popWin". ><a href="popWin('./index.php?action=open&id=579')"> <img src="./images/open.png" alt="O" name="open579" id="open579" style="border:0;width:15px;height:15px" /> </a> And here is the code I have that runs "closepopWin". ><a onclick="closepopWin();" href="?action=logout">Logout</a> I know the "closepopWin" code is working because if I change the code for "closepopWin" to: >function closepopWin() { if(morewin != null) morewin.close(); else alert('Nope, did not work!'); } the "alert" box pops-up. I thought maybe it was the fact I was using both the "href" and the "onclick". So I even tried to use this code (and only use the "href"), and it still didn't work. >function closepopWin() { if(morewin != null) morewin.close(); window.location.href = "?action=logout"; } I’m sorry I can’t provide a link to the page because it is a project that I am working and it contains some information I cannot disclose publicly. I know I am missing something; I just can't seem to find it.

I am using these two JavaScript function to Open and Close a Browser Window. >var morewin=null; function popWin(linkName) { if(morewin != null) morewin.close(); morewin = window.open(linkName, "moreWindow", "width=755,height=600,menubar=no,resizable,toolbar=no,scrollbars"); setTimeout("morewin.focus();",200); } function closepopWin() { if(morewin != null) morewin.close(); } The "popWin" function works fine as written. If the window is open, it will close the window and reopen the window with the new information selected. However, when the "closepopWin" function is selected, it doesn't work. I have even tried doing it this way, and it still doesn't work. >function closepopWin() { if(false == morewin.closed) morewin.close(); } I assume I am missing something since I am just learning JavaScript. Can anyone offer any suggestions?

Thanks, that does the trick. This is basically what I came up with. >$sql = "DESCRIBE tbl_name col_name"; if ( $query = mysql_query($sql) ) if ( $row = mysql_fetch_row($query) ) { print $row[4]."<br />\n"; } else print 'Error Reading Database!'."<br />\n";

Thanks, but that does not give me what I want. I actually want to query the table structure not the data in the table.

I am working on a script that will support a MySQL db, I am currently still learning MySQL. I am about 95% finished with the script but I have "painted myself into a corner." I have written the script to change the "default value" for a table column based the last thing the script has done when it is finished. The problem is, I would like to query the "default value" for the table column early in the script. I cannot find a way to do it. Can anyone help me?

Have a look at this page: Getting Rid of the Page Shift

Thanks, I'll give it a try.

I am looking a program to remove red-eye. I don't have a need for all the bells-and-whistle of Photoshop, I just need a red-eye tool. Does anyone know of a good program, hopefully freeware?

How about using Google? EDIT: Ignore this post. That is what I get for not reading the whole question first and posting while feeding our baby.