edoplaza

Hi again. Yes I know. But in my case, efficience will come after learning. I'm just a beginner in PHP . I'll try to to adapt what you suggest into my code. Thanks! Eduardo

I am trying to insert some values into the different fields of an update form: > </pre> <table>Titulo: Fecha: Lugar: Hora: Comentarios: </table> <br><br><br The only one I have problems with is the text area. It doesn't work. Where should I put the "value"? Thanks Eduardo

Well, after many tests, I found it! You can see it here: http://ww'>http://ww w.germanmarcano.com/indexEnglish.php compare it to http://ww w.germanmarcano.com/eventos/indexEnglish.php On the second link you can see the list of full events. On the other hand, on the first link, the "upcoming events" section is only displaying the first 3 events, counting from the present date... Here is the code (just the important part): <?php $counter=0; do { $exp_date = $row_RsEventos['fecha']; $todays_date = date("Y-m-d"); $today = strtotime($todays_date); $expiration_date = strtotime($exp_date); if (($expiration_date > $today) && ($counter<3) ){ ?> <?php echo $row_RsEventos['titulo']; ?> Date:<?php echo $row_RsEventos['fecha']; ?>Place:<?php echo $row_RsEventos['lugar']; ?>Time:<?php echo $row_RsEventos['hora']; $counter++; ?> Details... <?php } } while ($row_RsEventos = mysql_fetch_assoc($RsEventos)); ?> Now I just need to convert the yyyy-mm-dd format into a more friendly mm-dd-yyyy one. Cheers, Eduardo

Hello, Thanks for your answer. I'll give it a try. Meanwhile I came up with this: <?php do { ?> <?php $exp_date = $row_Recordset1['date']; $todays_date = date("Y-m-d"); $today = strtotime($todays_date); $expiration_date = strtotime($exp_date); if ($expiration_date > $today) { echo $row_Recordset1['date']; } ?> It works perfectly. The only thing to do now is to show only the first 3 records of that selection: let's say I have 20 records in total. Events from 1 to 7 are "past" events. Events from 8 to 20 are "upcoming" events. With my code, php will display only records 8 to 20. Now I just need to display only the first 3 records of those upcoming events: 8 9 10 Fot that, I was thinking about adding and extra condition with a counter, something like: $counter=0; if (($expiration_date > $today) ) && ($counter <4)) { echo $row_Recordset1['date']; $counter=$counter+1; } What do you think? I'll try that later on my page. Thanks Eduardo

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

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

Home Biography Critics Repertory CDs Live Recordings Videos Publications Gallery Events Contact 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

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

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

Hi zevion, Thanks, it worked perfectly. Cheers, Eduardo

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

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

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

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

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

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

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

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...

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

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)

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

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

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

Thank you Eric, I'll take a look... Have a nice day, Eduardo

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