AV1611
-
Posts
997 -
Joined
-
Last visited
Posts posted by AV1611
-
-
wouldn't I still need to capture the value in that field to another table then check if it's been changed every time ANY record is updated to see if
1. The record was ever closed
2. When the closure ocurred
???
-
I'll have to read the man on your solution, but would there now be a field called TIMESTAMP (or would it be dtm )?
That field would be overwritten each time the record is altered, so how do I know if the table is altered?
I guess I still don't see the answer :/
-
Sorry, perhaps I was not clear.
I need to know if there is a way to get MySQL via query to tell you when a record was last modified. Not the date within the table. There may be a change to the record that doesn't involve changing the date that was entered.
-
I have a program that's been in place for a while. Basically, it tracks jobs.
Once the job has been completed, a field is populated with a date. At that point the presence of a date is how the job is "statused"
To the question, without changing the workflow, is there a way to pull from mysql the date of last change/edit of a record? if there is, I could simply compare the two dates daily with a cron job to send an email to show that a change was made to a job that was previously marked as closed. I really hope this makes sense. I am only interested it sending an email (or other notification) that a job has changed SINCE THE DATE IT WAS CLOSED. I don't care about the date beyond that.
I'm open to other ideas, but am trying to keep from doing too much recoding of the app.
Thanks.
-
If the question is actually, is it possible to "steal" a name, then AFAIK it's not. At least I hope not. That would tear at the very fabric of the Internet.
-
Sorry to waste your time. Two more sips of coffee revealed that I forgot to put limit 100 at the end, so I actually had the full list, not the last 100
Doh!
-
I have a table with this schema:
idx name ip
data is like this:
1 john 1.1.1.1
2 fred 2.2.2.2
3 john 1.1.1.1
4 john 2.3.3.4
etc.
The point being that there are many duplicated of name/ip pairs.
This query is SUPPOSED to grab the last 100 distinct names from the list, (for a pulldown list) but doesn't:
Select distinct `name` from table order by `idx` desc;
What am I missing? It gives 100 names, but they are not the last on the list...
-
I fixed it by putting the banner in the body but I will never understand why IE puts concurrent div's in a padding/margin container with a gap.....
???
-
NOTE: This site is a work in progress so mind the mess!
This site is perfect in FF but has a gap between the body and the bottom of the menu. I will never understand where it comes from. I have margin/padding set to 0 everywhere. Can someone tell me how to get IE to not put the gap?
Thanks.
-
I am really asking two different questions, but it seems to be answered here.
The system I am working with uses unix time, but I have to create a form that uses a point of time in the future, so I need to use human dates in the form but unix time in the output to a .csv file.
Thanks for the help.
-
See any problem here?
<?php$ut= strtotime("+1 week");
echo $ut; //gives me the unix time of 1 week from this second of time
echo "<br />";
$date=getdate($ut);
echo $date['month'].' '.$date['mday'].' '.$date['year'];//gives me the date of the above timestamp (I do not care about time)
?>
-
I can't seem to think straight today.
I need to do two things:
convert a unix timestamp to human readable:
for example, if I have
UNIX time 1201976015
I want it do output 02/02/2008 6:13pm GMT.
I can write the script, I just can fire out the function
Second:
For a given day/month/year, what's the function to output the unix time for +7 days? Thanks.
-
-
On further review, it would seem that I am asking the wrong question.
The menu stays highlighted when you tab through it so I guess a:active is working.
I guess I want something different:
when I click a link, it reloads the page with index.php?page=3 so is there a way to make the "page 3" link stay highlighted when on page 3? If this requires JS just say so, I will stop here. If this can be done with CSS, please at a minimum tell me it can be done, and help me if you might...
Thanks.
-
Maybe I don't understand what a:active does then?
If I click HOME, then HOME should stay with the alternate background. Same goes for others links. I want the current link to be "active". Is that not what a:active does? That's not what it's doing.
I'm on my linux box with ff 2.0.0.10
it doesn't work on my M$ ie 6.1 either.
here is a change to my CSS to make sure there is no misunderstanding...
li{list-style: none;
}
li a
{
background-color: white;
background: url(images/buttonback.jpg);
background-repeat: repeat-y;
display: block;
list-style: none;
margin: 2px;
text-align: center;
color: black;
font-size: 18px;
padding: 1px 0px;
text-decoration: none;
}
li a:link
{
background-color: white;
background: url(images/buttonback.jpg);
background-repeat: repeat-y;
display: block;
list-style: none;
margin: 2px;
text-align: center;
color: black;
font-size: 18px;
padding: 1px 0px;
text-decoration: none;
}
li a:visited
{
background-color: white;
background: url(images/buttonback.jpg);
background-repeat: repeat-y;
display: block;
list-style: none;
margin: 2px;
text-align: center;
color: black;
font-size: 18px;
padding: 1px 0px;
text-decoration: none;
}
li a:hover{
background: url(images/buttonback2.jpg);
background-repeat: repeat-y;
display: block;
padding: 1px 0px;
color: red;
}
li a:active{
background: url(images/buttonback2.jpg);
background-repeat: repeat-y;
display: block;
padding: 1px 0px;
color: red;
}
-
Sorry, I knew that. Changing it to this still doesn't help. I'm a back to my original question: how do you get a:active to work? I've never been able to do it.
Here's the site I'm working on:
http://tranquilpenguin.com/~osprey/trustwisconsin
Changed to:
li, li a, li a:link, li a:visited
{
background-color: white;
background: url(images/buttonback.jpg);
background-repeat: repeat-y;
display: block;
list-style: none;
margin: 2px;
text-align: center;
color: black;
font-size: 18px;
padding: 1px 0px;
text-decoration: none;
}
li a:hover, li a:active{
background: url(images/buttonback2.jpg);
background-repeat: repeat-y;
display: block;
padding: 1px 0px;
color: red;
}
-
I recently converted my layout style from table to div. I found learning it much easier by doing this:
create empty div's and specifiy height and width with inline css, also setting a background-color for each. By using this, I was able to visualize the floats and blocks and so forth. Once I got the site the way I wanted, it's just as easy as replacing the css placeholders with real objects. It didn't solve everything, but it sure helped me get used to letting go of tables.
-
I can never get a:active to work.
the background changes on hover, but when the link is clicked, it reverts to normal, not active. How do you make it work???
(only the hover works)
<style type="text/css">
li, li a
{
background-color: white;
background: url(images/buttonback.jpg);
background-repeat: repeat-y;
display: block;
list-style: none;
margin: 2px;
text-align: center;
color: black;
font-size: 18px;
font-weight: bold;
padding: 0;
text-decoration: none;
}
li a:active, li a:hover{
background: url(images/buttonback2.jpg);
background-repeat: repeat-y;
display: block;
color: red;
}
-
The bottom one is a bit abstract. The text reflection is totally not consistent with a glass button either. I thought all the abstract things worked together to make a nice, if not reality-flawed, button.
-
WOW
That is an incredible bit of coding.
Anyone know the real story on tables for layout? everyone says not to use them, but everyone does.
Should I never use them, or should I only use them lightly?
Thanks.
-
-
-
When I was a kid I took a course in speed math. It change my life.
I wrote a site with PHP to someone emulate that course. It may seem silly, but if you stay with it, you can make a big impact in your ability to do math in your head, especially in an age when we rely on computers to do our math for us.
Here's the link if anyone cares.
http://tranquilpenguin.com/school/
Any before anyone comments... the background is dynamically created with php gd2 every time the home page reloads... sometimes it's pretty and sometimes it's pretty ugly
I never finished the cosmetics, but the site works great.
-
As part of my overall desire to get current with web development, I decided it was time for me to figure out how to make glassy buttons and such. to that end, here are my first 4 ever serious attempts. This was all done entirely in GIMP. They are in chronological order, top to bottom, left to right.
Please critique: I really want them to look great.
checking for changes
in PHP Coding Help
Posted
I guess you answered my question.
I know how to how to capture the record and send an email by comparing. It's a lot of work, but I've done it before.
What I really want to know is this:
Is there some variable that I can query from MySQL directly that will tell me the last time a record was edited?
I think that's the right question.