twebman84

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.

Thanks, I'm looking at it now. Much appreciated.

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

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.

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.

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.

Thank you. But if I use mod rewrite, can the URL be http://whatever.com/filename.php ? where filename = the uniqueID?

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

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.

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

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.

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?

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!

Thanks, Pikachu. I'm doing that now, but at first glance I don't see anything odd.

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.