globberstack.com / topdog / Voted Questions http://www.globberstack.com Linux, Apache, MySQL & PHP Community Questions & Answers Tue, 17 May 2011 09:02:59 -0400 en <![CDATA[MySql Table Insert if not exist otherwise update]]> http://www.globberstack.com/Questions/mysql-table-insert-if-not-exist-otherwise-update-1/ http://www.globberstack.com/Questions/mysql-table-insert-if-not-exist-otherwise-update-1/ Tue, 17 May 2011 09:02:59 -0400 topdog Questions http://www.globberstack.com/Questions/mysql-table-insert-if-not-exist-otherwise-update-1/ 
UPDATE AggregatedData SET datenum="734152.979166667", 
Timestamp="2010-01-14 23:30:00.000" WHERE datenum="734152.979166667";


It works if the datenum exists, but I want to insert this data as a new row if the datenum does not exist.



UPDATE



the datenum is unique but that's not the primary key



Originally asked by: iUngi on Stack Overflow

1 Vote(s) ]]> <![CDATA[2 columns works local, not on site]]> http://www.globberstack.com/Questions/2-columns-works-local-not-on-site-1/ http://www.globberstack.com/Questions/2-columns-works-local-not-on-site-1/ Thu, 27 Jan 2011 09:53:52 -0500 topdog Questions http://www.globberstack.com/Questions/2-columns-works-local-not-on-site-1/ I am trying to float 2 lists next to each other, each in it's own div.
My code works when I am in dreamweaver where I have a simple layout of just the main content section of the web page, but when I add it to the site where all sorts of other stuff from the CMS etc gets involved it shows one list div below the other.
I have tried absolute values in em and percentages
What am I doing wrong?
problem page is here
http://museum.spps.org/sitecouncil.html

code that works locally

CODE
.post-content {float:left; width:40.333em; overflow:visible;}
.2col-left {float:left; width:48%; overflow:visible; padding:0 2% 0 0;}
.2col-right {float:right; width:48%; overflow:visible; padding:0 0 0 2%;}

<div class="post-content" >
<div class = "2col-left">
<h4>Staff:</h4>
<ul>
<li>Tyrone Brookins</li>
<li>Katherine Snyder</li>
<li>Laurie Kruempel</li>
<li>Michaele Caron</li>
</ul>
</div>
<div class = "2col-right">
<h4>Parents:</h4>
<ul>
<li>Philip Friedlund</li>
<li>Amber Cochran</li>
<li>Jenny Hicks</li>
</ul>
</div>
<div class="clearboth"><!-- --></div>
</div>


3 Vote(s) ]]> <![CDATA[Consolidate multiple MySQL databases into one preserving referential integrity]]> http://www.globberstack.com/Questions/consolidate-multiple-mysql-databases-into-one-preserving-referential-integrity-1/ http://www.globberstack.com/Questions/consolidate-multiple-mysql-databases-into-one-preserving-referential-integrity-1/ Thu, 02 Sep 2010 08:32:11 -0400 topdog Questions http://www.globberstack.com/Questions/consolidate-multiple-mysql-databases-into-one-preserving-referential-integrity-1/

I'm wanting to consolidate numerous MySQL databases, all with the same schema definition, into a single database. If I have a dump file from each database, how will I import them all into the same database without their primary keys and foreign keys clashing?



Is there a fairly simple way to do this, or will I need to write some custom code that understands the data and creates a consolidated set of records 'manually'?



Originally asked by: jondow on Stack Overflow

1 Vote(s) ]]> <![CDATA[Site Redesigned With Help From You Guys]]> http://www.globberstack.com/Questions/site-redesigned-with-help-from-you-guys/ http://www.globberstack.com/Questions/site-redesigned-with-help-from-you-guys/ Thu, 22 Oct 2009 09:12:30 -0400 topdog Questions http://www.globberstack.com/Questions/site-redesigned-with-help-from-you-guys/ I'm looking for feedback on my redesigned website

Thanks so much everyone for helping me out with some problems I had, but now I can officially say my site

www.techinfo-4u.com is up and running,

I've redesigned it using Wordpress...

1 Vote(s) ]]> <![CDATA[Setting My Floating Div To The Correct Area]]> http://www.globberstack.com/Questions/setting-my-floating-div-to-the-correct-area/ http://www.globberstack.com/Questions/setting-my-floating-div-to-the-correct-area/ Tue, 20 Oct 2009 15:03:11 -0400 topdog Questions http://www.globberstack.com/Questions/setting-my-floating-div-to-the-correct-area/

CODE
#layer1 {
    position:absolute;
    left: 75%;
    top: 250px;
    visibility: hidden;
    width: 200px;
    height: 75px;
}


Now for my screen this puts to where i need it but on screens with different resolutions it is not.
Basically what I was thinking is if i could set the left property to 50% + 340px. This way when it loads, it will put the div 10px off the left side of my main div.

First of all is this even possible? and if so how would i accomplish this.

1 Vote(s) ]]> <![CDATA[running phpmyadmin using wamp server]]> http://www.globberstack.com/Questions/running-phpmyadmin-using-wamp-server/ http://www.globberstack.com/Questions/running-phpmyadmin-using-wamp-server/ Tue, 20 Oct 2009 14:42:31 -0400 topdog Questions http://www.globberstack.com/Questions/running-phpmyadmin-using-wamp-server/
#1045 - Access denied for user 'root'@'localhost' (using password: NO)

i already have xampp installed on my computer, i want to learn smarty templates...

1 Vote(s) ]]> <![CDATA[question about smarty templates]]> http://www.globberstack.com/Questions/question-about-smarty-templates/ http://www.globberstack.com/Questions/question-about-smarty-templates/ Tue, 20 Oct 2009 14:35:38 -0400 topdog Questions http://www.globberstack.com/Questions/question-about-smarty-templates/
in the index.php file when i use the following and access
http://localhost everything works fine and i am able to display the value of variables defined in index.php
...

2 Vote(s) ]]>