edoplaza

November 3, 2009

Hello,

I know it's possible to display records ordered by date, but what if I want to display only future dates counting from the present day? PHP should first calculate the present date and then display dates from there. How do I do that? With a conditional statement? is there a function for that?

Example:

I have these records stored in my DB:

record1 2009/10/02

record2 2009/10/05

record3 2009/10/08

record4 2009/10/18

record5 2009/11/04

record6 2009/11/10

record7 2009/12/07

If the present day is 2009/10/17 I just want to display:

record4 2009/10/18

record5 2009/11/04

record6 2009/11/10

record7 2009/12/07

but If the present day is 2009/11/01 I just want to display:

record5 2009/11/04

record6 2009/11/10

record7 2009/12/07

Any help will be appreciated,

Regards,

Eduardo

November 2, 2009

<?php echo $row_Rsprueba['fecha']; ?>

October 31, 2009

Events

<?php do { ?>

<?php echo $row_RsEventos['titulo']; ?>

Date:	<?php echo $row_RsEventos['fecha']; ?>
Place:	<?php echo $row_RsEventos['lugar']; ?>
Time:	<?php echo $row_RsEventos['hora']; ?>

<?php echo $row_RsEventos['comentarios']; ?>

<?php } while ($row_RsEventos = mysql_fetch_assoc($RsEventos)); ?>

home | administration | contact Copyright ? Germ?n Marcano 2009

October 29, 2009

Thanks, I guess I was tired last night...

Cheers

October 29, 2009

Ok, here we go again,

Why in FF the middle banner does not show the orange background while in IE, it does (which is the correct result).

Also, why do I get a 1 pixel horizontal white line between the footer and the content in both browsers?

ww w.eemmal.com

CSS:

ww w.eemmal.com/css/main.css

Thanks

Eduardo

October 29, 2009

Hi zevion,

Thanks, it worked perfectly.

Cheers,

Eduardo

October 28, 2009

Hi everybody,

The owner of w ww.laht.com claims that the rss feed doesn't always work properly. He says some users have sent him messages telling the rss is "full of errors". I don't see anything wrong there. How could I check that?

Thanks

Eduardo

October 28, 2009

Hi,

I am using one of Eric's horizontal menus in this new site:

http://ww'>http://ww w.eemmal.com/header.php

I'm almost done, but I don't know how to correct the drop down menu position.

I want the drop down menu to be exactly under the fixed menu, like 5 pixels down.

I've tried to put a top margin, to move the absolute position, but nothing works

css:

http://ww w.eemmal.com/css/main.css

Thanks,

Eduardo

October 28, 2009

Hi,

I am using one of Eric's horizontal menus in this new site:

http://ww w.eemmal.com/header.php

I'm almost done, but I don't know how to correct the drop down menu position.

I want the drop down menu to be exactly under the fixed menu, like 5 pixels down.

I've tried to put a top margin, to move the absolute position, but nothing works

Thanks,

Eduardo

October 27, 2009

Hi newseed,

I'm impressed. It worked perfectly. How can you find so easily those not so obvious mistakes? Do you have a program for that or just excellent eyes (and knowledge of course)?

Anyway, thank you my friend

Regards,

Eduardo

October 27, 2009

I worked! Thank you very much.

Just one more question

I don't see any errors on this page:

http://www.laht.com/whoswho.asp?ArticleId=201583&CategoryId=13973

But it has the same problem, the worong margin in FF

Thanks

Eduardo

October 26, 2009

Thanks. I'm not at home right now, I'll try that tonight.

Cheers,

Eduardo

October 25, 2009

Thanks for the answers. Actually my job is pretty much done, I was in charge to put the ad banners, and to fix some issues with Google Analytics. So, the new site will be not my problem.

The only issue I need to solve is the Firefox extra margin.

Look at this pages:

http://ww'>http://ww w.laht.com/Contacts.asp

http://ww w.laht.com/help.asp

In IE they look ok, in firefox (and chrome), there is a top margin. Why?

Please, any help will be appreciated

Cheers,

Eduardo

October 25, 2009

Hello Thelma,

Yes, what a mess. I talked to the director of the site, and he told my the code is 5 years old. ("it's been clunky for 5 years") That explains everything. I also told him to consider a new "refreshment" on the code. Divs instead of tables, etc. etc. The thing is that the whole site is huge, it's one of the most important journals in Latinamerica, completely written in English. You can check the director's cv...

Well, finally he told me he was very happy with my job, for his site is already earning some bucks with the adsense I added. But I told him I wouldn't touch the code anymore, I don't want to risk a major disaster...

October 25, 2009

Thanks for the advice,

I think I'll conctact the owner of the Journal and tell him his site is a complete mess. That site is enormous, and I don't know any asp, so, to bad for him, I won't rebuild the whole site. At least I was able to put the Google adsense banners.

I just need to know what I could do to fix those margins in firefox. Especially here:

http://ww'>http://ww'>http://ww'>http://ww'>http://ww w.laht.com/help.asp

http://ww w.laht.com/Contacts.asp

http://ww w.laht.com/whoswho.asp?ArticleId=201583&CategoryId=13973

And I don't really understand why it works here:

http://ww w.laht.com/article.asp?ArticleId=133399&CategoryId=10734

and

http://w ww.laht.com/index.asp

What is the difference with the not working sections?

Thanks

October 25, 2009

I have this issue with firefox and Explorer

Why this two pages:

http://w'>http://w ww.laht.com/help.asp

http://w ww.laht.com/Contacts.asp

Look ok in Explorer but wrong in Firefox? (huge margin at the top middle section)

October 25, 2009

I forgot to say that just the index page has more than 600 validation errors!!!!

October 25, 2009

Hello,

I have to "repair" an old website: ww w.lah t.com and it's been a nightmare to me.

The site is completely built with tables...not divs, no css... so it is specially cumbersome and painful to change anything.

Also, the site uses asp, I use php... imagine

But I have some few specific questions:

a) The client wants every page of this site indexed by Google analytics. I inserted the code on a include file, common to every page on the site. I did that 24 hours ago, and still nothing. I double checked to see if the code was the same as the one provided by Google, still nothing. Any ideas?

I noticed that if you type: www. laht. com or www. laht. com/Index.asp (notice the capital I), and www. laht. com/index.asp or even www. laht .com/INDEX.asp it works every time. How is this possible? I thought the index name had to be always in lower case. Is there a code I am missing somewhere? Maybe this: makes that possible? I'm completely lost.

Actually the client wants me to ?merge? the ww w.laht.com/index.asp page and the

ww w.laht.com page?Why does he think there are two different ?index? pages? How do I answer that?

I hope I will never have to work on an already built web site again, especially if my job consists in finding and fixing other people's bugs

Cheers,

Eduardo

October 2, 2009

Eric,

You just saved my life! Thank you, that is exactly what I need. I think I'll use CushyCms, it's the one I like the most.

Thank you very much again,

Eduardo

October 2, 2009

Thank you Eric,

I'll take a look...

Have a nice day,

Eduardo

October 1, 2009

Hello everybody,

I am building a new site for a music school. The client wants to update the "news" and the "upcoming events" sections very often. I can set up a little add/upload form ...no problem. The problem is that he wants also to upload some pictures for the "news" section (for example, after a concert or recital he would like to add some information with pictures and/or videos of the event). What would be the best approach to do that? Should I create a special form which an image upload section? But then, how would he know which picture will he put in this or that place of the page? It seems very risky to me if a client manipulates images and videos with a form.

On the other hand, he definitely doesn't want to pay extra money each time he wants to put new info or pictures, he wants to do it by himself.

Any suggestions? (Other than create a Joomla or MySpace site)

Thanks,

Eduardo

September 27, 2009

Yes, you are right too. I already fixed it. How do you like the pop up image effects? and the gallery? aren't they too flashy? The site is meant to be quite formal (not extremely, but quite)

By the way I'm using the php add/delete/update form you wrote. It's in the administration section and it works perfectly. The upcoming events and the events section display data from the DB, which is to be populated by the client...

Thanks again for that.

Cheers

Eduardo

September 27, 2009

Thanks Thelma,

I fixed the "CD's" problem. You are right that's a common mistake. Anyway, I'm glad you liked the site. The client did too...

Anyone else? I want some critics

September 27, 2009

Hello everybody,

This is my last work. It's a small site for a cello player here in Venezuela. I still have to work on the video section and add more photos to the gallery. I've tried to validate every page as much as possible.

Please tell me your critics so I can improve my skills.

Link:

ww w.germ anma racano.com

Best regards,

Eduardo

September 20, 2009

Just one last question,

What would be the best way to link all this to a css style sheet? I notice that in the view.php tables are not shown as a html format but inside a php code.

Thanks Eduardo

Sign In

Profiles

Forums

Events

Downloads

Gallery

Store

Posts posted by edoplaza

Events