Jump to content

twebman84

Members
  • Posts

    37
  • Joined

  • Last visited

Everything posted by twebman84

  1. Here's my entire code, it grabs data just fine. I want to only show the $nameNick result if that field has a value in the database. How can I accomplish that? <?php mysql_connect("localhost", "user", "password"); mysql_select_db("dbname"); $sql = mysql_query("SELECT * FROM master WHERE playerID = 'smithal01' "); while($row = mysql_fetch_array($sql)){ $playerID = $row['playerID']; $nameFirst = $row['nameFirst']; $nameLast = $row['nameLast']; $nameGiven = $row['nameGiven']; $nameNick = $row['nameNick']; echo "<h1 class='playerTitle'>$nameFirst $nameLast</h1>"; echo "<p class='playerInfo'>$nameGiven $nameLast<br />$nameNick </p>"; } ?> Thanks in advance for taking the time to click through.
  2. I'd like to create a page that has a drag-and-drop ranking system similar to this: http://mlb.mlb.com/news/power_rankings/index.jsp I want the visitor to be able to rank something from a set list and then submit thei rankings and have it combined with the rankings already in the database to give an overall rankings list. Can this be done using Javascript? Anyone seen a script out there that does this? Thanks
  3. IMO, rather than spend time and resources on building a web site that does all this, the better solution would be to build an app. Everyone (especially parents) have smart phones. The app could pull the logbook data, etc. from the DB and serve it just as well for the user. And be more accessible ANYWHERE the parent is.
  4. Yes, I have. I apologize for not being as up on this as you are. This is my current HTACESS file: #RewriteCond %{REQUEST_URI} ^/baseball-player/(.*)$ /baseballplayer/?playerid=$1 So the URL looks like this: http://domain.com/baseball-player/?id=uniqueID Those pages aren't showing up AT ALL in Google. No indexing at all. I'd prefer the URL to be: http://domain.com/baseball-player/uniqueID.php Am I crazy? Is this not possible or even preferable? Does Google "crawl" these URLs? If so, HOW? Only if there are links to them? Thanks, and I'd be happy to work with you on this project, because it's wasting a lot of time. I already had one developer work on it and it didn't come out the way it was supposed to.
  5. The reason I ask is that Google still seems to favor pages WITHOUT query strings in their URL. They say they don't, but I haven't seen evidence of that. Currently I am using mod rewrite and the page URLs are like this: http://whatever.com/whatever/?id=uniqueID ... and those pages are getting buried on Google, in fact they aren't even being crawled.
  6. Thank you. But if I use mod rewrite, can the URL be http://whatever.com/filename.php ? where filename = the uniqueID?
  7. Some years ago I found a program that allowed me to do this. I can't find it now. Here's what I am trying to accomplish: I need to create hundreds of PHP web pages that will have only one thing changed in their code, a variable ID that is stored in an Access DB (or in a mySQL DB< I suppose). So that the PHP web page is sort of like this: <?php Some PHP $player = 'uniqueID'; Some HTML ?> Each page will need that uniqueID to be filled with one of the several hundred uniqueIDs in the database. How can I do this? It's sort of like a mail merge, and I know I had a program that did this for me, but can't for the life of me remember what it is. Is there another programmatical way to accomplish this? The key is each PHP web page needs to have a unique URL corresponding to the uniqueID. Thanks
  8. I made a new table, which has this structure: | playerID | G_c | G_1B | G_2b | +-----------|--------|----------|--------| | aaron01 | 0 | 10 | 600 | | allen01 | 0 | 550 | 35 | So how do I return the field NAME that contains the highest numerical value? I don't want the value itself, I want the FIELD NAME.
  9. Here's my table, which is named appearances: playerID | G_C | G_1b | G_2b | G_3b | G_ss | G_lf | G_cf | G_rf | G_p | G_dh | aaronha01, 0, 0, 0, 0, 0, 0, 0, 150, 0, 0 aaronha01, 0, 0, 0, 30, 0, 0, 10, 110, 0, 0 willite01, 0, 0, 0, 0, 0, 141, 3, 1, 0, 0 willite01, 0, 0, 0, 0, 0, 122, 33, 2, 1, 0 and so on This table shows the games played by certain baseball players in their seasons at certain positions (each record is a different season). For example, the first record shows that the player with an id of aaronha01 played 150 games at G_lf (left field). And so on. For each player (unique playerID) I want to find the position they played the most games at. So, I want to find the sum of all the fields for each unique playerID and then retrieve the column (position) with the highest number in it. I then want to convert that field name to something useful for displaying via PHP. For example if G_ss is the column with the highest total for that unique playerID I want the query results to show "shortstop" not "G_ss" If someone can help me with this, I will have some work for them. I am looking for someone to build a data entry interface for me to be able to update this database myself. Thanks
  10. I want to offer my site visitors the opportunity to use some of my content on their sites. For example, a Quote of the Day or This Date in History snippet that they can place on their site. I want to host and manage the content on my site and allow the visitors to syndicate it on their sites easily. The key word here is "easily". I don't want to do this through RSS, which can be tricky for entry-level webmasters and bloggers. I want to be able to offer a line of code, say in Javascript, that the visitor can copy and paste into their site (Wordpress widget etc.) and have my content appear there. Does anyone have any starting points for how to do this? I have several years of experience with PHPP, MySQL, CSS, HTML, etc., but I don't want to re-invent the wheel. I've done something similar in JSP, but not using PHP.
  11. I would like to add a color mixer (not a color selector) on a client's site. It would be like this one: http://www.dur-a-flex.com/Home/ColorPicker Does anyone know where to find a script like this, or if they know a developer who could build it?
  12. I would like to publish the sports standings (MLB, NHL, NFL, NBA) on a client website. I have not been able to find an RSS feed for standings from any of the leagues themselves. There are "widgets" and "Google gadgets" that do it but they don't look very good and they don't allow me to format them very well. Is there a way for me to grab the standings from a web page using PHP? Or does anyone know of a source that provides this information via RSS? Thank you!
  13. Thanks, Pikachu. I'm doing that now, but at first glance I don't see anything odd.
  14. Home page doesn't tell me anything of what your site is ABOUT. Big failure there. You need to have clear action items. You have a sign-up form, but what am I signing up for? Very annoying that I have to create an entire profile just to see your website.
  15. First, congratulations on your first full site design and development. That's a lot of work, I know. I concur with an earlier comment that the background doesn't seem to fit with health foods. My biggest problem is that there are NO PRODUCTS readily visible. It takes too many steps for me to see your products. I'd suggest having a few featured products on the home page, probably 3-6 - in rows of three across. A thumbnail, title, price, and buy button. How many potential customers are going to "request a price"? We want as much information as possible NOW so we can make a purchase. Also, your product titles are misleading. What does "Antipasto Baby Roma Tomato 250" mean? And what am I getting? Don't make the mistake so many retailers make: assuming your customer knows your products. Good luck!
  16. SITE: http://blog.detroitathletic.com/ Load it in Google Chrome and notice how the header loads above the browser window, like it's scrolled up. The topNav menu lays over the wrong part of the site. But if you mouse over the header graphic the header slides down and the topNav aligns properly. See the attached graphic, it shows what I mean. The topNav menu (Blog Home, Tigers, Lions, etc. should be aligned over the darker strip about 40 pixels above)/ What is the problem here? The site loads fine in all other browsers. I have included the CSS for the elements I'm using in the header. #topNav { position: absolute; top: 95px; left: 650px; color: #fff; font-weight: 700; font-family: Georgia; } #topNav a { color: #FFF; font-size: 16px; font-weight: bold; padding-right: 20px; } #topNav a:hover { color: #FFFF33; } #phone { position: absolute; top: 119px; left: 215px; color: #FFF; font-size: 14px; font-weight: bold; font-family: Georgia; } #header { min-width: 990px; padding: 0; } #branding { width: 1000px; margin: 0 auto; padding: 0; background: url(/wp-content/themes/arras/images/bg-header.jpg) no-repeat; } .logo { max-width: 590px; float: left; padding: 0px 0 25px 10px; } Here's the code from the header file: <div id="header"> <div id="branding" class="clearfix"> <div class="logo"> <a href="http://www.detroitathletic.com/servlet/StoreFront"><img src="http://beta.com.s60787.gridserver.com/wp-content/uploads/2011/11/logo1.png"></a> </div> <div id="topNav"> <a href="/index.php">Blog Home</a> <a href="/category/detroit-tigers/">Tigers</a> <a href="/category/detroit-lions/">Lions</a> <a href="/category/detroit-red-wings/">Red Wings</a> <a href="/category/detroit-pistons/">Pistons</a> <a href="http://www.detroitathletic.com/servlet/StoreFront">Shop</a> </div> <div id="phone">1-877-604-4490 (10am - 5pm EST)</div> </div><!-- #branding --> </div><!-- #header -->
  17. The skte is http://gtaparkinsonsgroup.org.s60787.gridserver.com/ Notice that there is a lot of blank space under the three call-to-action boxes on the page. Those boxes are positioned relative. Then there ar eno elements under that, just closing the CONTAINER div and closing BODY and HTML. Why the empty space?
  18. Yes, since I posted this, it's been migrated to the staging area for launch to be live soon. The address is now http://gtpie.com.s60787.gridserver.com Thanks for taking time to comment.
  19. freelance84, thanks for your candid appraisal. the client wants the two scrollers on the home page. i agree, one is probably enough. i will look a the topnav, i know it highlights everything regardless of the page. i was lazy and didn't change that in the CSS. good point, though.
  20. Looks like every other forum site out there, but there's not much you can do about that. Change the color scheme, that bright and glossy color of blue is rarely good for an entire site.
  21. How are you "different than the rest? Expound on that. The text on the red ribbon that lays over top the properties and says "For Sale" - the words need to be centered better so they don't brush up against the edge. I think the logo and name of the realtor gets completely lost where it is - layered on top of the images in your header. I couldn't tell what the name of the realtor was at all, had to look for it. I'd pue the logo and name where you have the phone #, put the phone # where you have your tagline, and either lose the tagline or put it elsewhere on the header. A search box is very important on any realty site. You don't have one anywhere on your home page or on your header. I'd suggest a search option prominent on the header and consistent throughout the site. Put a home link on your header, in addition to the HOME option on your menu. Many times I instinctively wanted to click where the phone # is to get home. (Another reason the logo should be up there.) How do I get to your listings? Do you have listings? I guess I have to click the images in your scroller on the home page. That's very hard to understand. Also, when I'm off the home page I don't know how to get to listings. "Search foreclosures" doesn't mean anything to me. Is that your listings? I like the colors and the look and feel. I see it's a WP theme. FYI - there are better WP themes for real estate out there that come with very robust search features, listings features. In today's environment you must have Facebook and Twitter share buttons on every listing. I understand you're using a third-party provider for the listings, but there may be better options out there. I hope you take this critique to heart, not meant to be disparaging. Good luck!
  22. The beta site is here: http://alpha.com.s60787.gridserver.com/ Any and all criticism is welcome. Thanks!
  23. The URL is http://imabuy.com I'm using a centered DIV to contain the content, and all of it is nicely within that DIV. But there's a scroll bar at the bottom of the browser and the site also scrolls vertically, because of unwanted space to the bottom and right of my content. I've looked at this for a long time, but can't figure out what I'm missing. Any help appreciated. Container is the DIV that holds it all: #Container { width: 900px; margin: auto; align: center; } Wrapper is inside that: #Wrapper { clear: both; width: 980px; padding: 20px 0 0 0; margin: 0; } Here's the DIV where I have the background image of the drive-in movie: #home-drive-in { } The logo and the text links are all separate items setting on top of the background, for example: #imabuy-logo { position: relative; left: 10px; top: -560px; z-index: 101; }
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.