[Storing user position on webpage]

Almost got it, just need to figure out how to get jquery to move the user's window to a element based on its numerical position, it won't necessarily have an anchor

[Storing user position on webpage]

Yep, that's true, but I was wondering if it was possible to find the vertical position of an anchor, store it in a cookie, and then when needed move back to it

[Storing user position on webpage]

i have a link that sends users to another part of the page. How would i store the user's previous position so that they can go back to where they were?

[header csv, asks for password in excel]

here is my header

 

header("Content-type: application/");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
header("Content-disposition: filename=".$filename.".csv");
print $csv_output;

[header csv, asks for password in excel]

Hey, so Ive created an export data script that links to my mysql database and constructs a csv document (using headers) to export the data. This works fine in all browsers except IE, where it would actually ask the user for my mysql username and password to open the csv spreadsheet. Pressing 'cancel' allows the user to see the spreadsheet, but I'd like to open the csv file without this password nonsense in IE. Any solutions?

[getting specific dates in a month]

How do I, given a month and a year, find something like the 2nd friday of that month. Or find the last wednesday?

[creating dynamic link to .csv]

i finished the script and it worked

 

thanks man

[creating dynamic link to .csv]

I'm trying to write a php script that gets a table name for mysql and generates a .csv to download for the user. Like an 'export data' link. I know you can do this through phpmyadmin, but how can i make a link for my site?

 

Any hints?

[Is calling php scripts through the browser "healthy"?]

Hey, Im somewhat new to php and I was wondering if it was safe to execute php scripts that access my MYSQL database from the browser? I've password protected the files of course, but is there an internal way to do it?

[calculating %ch in MYSQL]

Suppose you have a table with two fields, Date and Value. I want to use php to calculate Year over Year percent change? How do I efficiently get the previous year's value as well as start exactly one year after my initial date (since you can't calculate %ch if there are no previous values)?

 

 

[need some basic navigation help]

right, so in jeopardy form-> How do you make a navbar scalable so it can adjust for different screen sizes?

How do I make css create a menu underneath the tabs?

How can I get the a:hover color to stay fixed when a user clicks it?

 

 

[need some basic navigation help]

I'm trying to create the navigation bar, but I need it so when someone clicks on a tab, the hover background remain fixed and a list of links will appear on the bottom.

 

Also I think my navbar is too narrow, but when I increase the width, the last tab doesn't come inline with the border.

 

Here is the css

 

@charset "utf-8";
/* CSS Document */
body {
width:750px;
margin-left:auto;
margin-right:auto;
text-align:center;

}
div#navbar {
border-top:1px solid;
border-left:1px solid;
border-right:1px solid;
height:2.5em;
margin-left:0px;
border-bottom:none;

}
div#navbar ul {
list-style: none;
padding: 0;
margin: 0;	   
}

div#navbar li {
float: left;
margin:0;
height: 2.5em;
line-height: 2.5em;
font-family:Georgia, "Times New Roman", Times, serif;
font-weight:bold;
font-size:15px;
border-right: 1px dashed;
}

div#navbar a:link{
background:#006666;
color:#FFFFFF;
}
div#navbar a:hover{
background:#006666;
color:#FFFFFF;
}

div#navbar a:active{
background:#006666;
color:#FFFFFF;
}
#navbar li a
{
outline-style:none;
outline-width:0;
float: left;
height:3.8em;
width: 9.92em;
display: block;
text-decoration: none;
text-align: center;
color:#666666;
} 
div#navbar li a#first2{

}
div#navbar li#last{
border-right:none;	
}
div#navbar li#first{

}
div#navbar li a:hover{
text-decoration:none;
color:#FFFFFF;
}
div#subheading {
height:20px;
width:750px;
background:#006666;
-moz-border-radius-bottomleft:5px;
-moz-border-radius-bottomright:5px;

}

 

html:

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<link type="text/css" rel="stylesheet" href="css/index.css" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Main Page</title>
</head>
<body>
<div id="logo"></div>
<div id="navbar">
<ul>
    <li id="first">
    	<a href="#" id="first2">u.s. macro</a>    </li>
    <li>
    	<a href="#">credit & banking</a>    </li>
    <li>
    	<a href="#">real estate</a>    </li>
    <li>
    	<a href="#">global macro</a>    </li>
   	<li id="last">
    <a href="#" id="last2" >getting started</a>    </li>
</ul>
</div>
<div id="subheading"></div>
<div id="dataFrame"></div>

</body>
</html>

 

you can see the output here: www.economiq.org/index2.htm

 

[splitting a php file?]

sweet, thanks!

[splitting a php file?]

I was wondering if it was possible to split a php file so one part would start off, then it would call a second php file, and then go back to the original file to finish processing.

 

I want to do this because there are certain sections of my phps that are repeated many times across files, it would be easier just to call one file instead of typing it all through.