[Target frame with PHP Include()]

The only way you can do this is to put the php include inside the proper section of HTML code (I'm not real familiar with frames, so I couldn't tell you exactly how to do it).

[[SOLVED] Is a query for this even possible?]

While it is possible to pull all the info in a single query, it would be a bit easier to do it in two queries, and you're still going to have to use PHP to sort all the data out...

 

First get all the team names and find out how many games there were...

Then, find the number of wins for each team

Put all the wins in an array, using the team names as the keys

Sort the array in reverse order (so the team with the most wins will be first)

Use a foreach loop to calculate the losses for each team and display the info

 

Basically, something like this:

$query = mysql_query("SELECT home_team FROM table ORDER BY home_team ASC") or die(mysql_error());

$num_games = mysql_num_rows($query);
$team_data = array();

while($teams = mysql_fetch_assoc($query))
{
    $current_team = $teams['home_team'];

    // Find all the wins... This is tricky...
    $query2 = mysql_query("SELECT COUNT(home_result) AS home_wins, COUNT(away_result) AS road_wins FROM table WHERE (home_team = '$current_team' AND home_result = 'Win') OR (away_team = '$current_team' AND away_result = 'Win') or die(mysql_error());

    // Calculate the wins
    $wins = mysql_result($query2, 0, 0) + mysql_result($query2, 0, 1);

    // Now that we have this info...
    $team_data[$current_team] = $wins;
}

arsort($team_data);

foreach($team_data AS $name => $games_won)
{
    // Figure out how many games they lost
    $games_lost = $num_games - $games_won;

    // Put whatever code you want here to output this info...
}

 

There might be a way to do all that in one query, but it's easier to do it in two queries.

[[SOLVED] Query Empty Issue]

You have a typo in your code - $sq1 instead of $sql

[Database modeling!]

You might also find the Information Schema helpful

[PHP Designer 2007]

I love PHP Designer 2007

[[SOLVED] HOW TO HAVE A TOP AND BOTTOM BORDER ONLY ON A TABLE?]

Your best option would be to use CSS. See http://www.w3schools.com/css/css_border.asp for more info.

[mySQL to Access database on Clients system]

To communicate between the two, you will need to use either a third-party database class (such as ADODB) or one of the PHP extensions that supports both Access and MySQL (such as ODBC or PDO).

 

I'm not real sure how you connect to Access databases from PHP, but basically what you'll need to do is this:

 

Pull the data from MySQL into PHP variables

Pass the data (using those variables) to Access after modifying it (if needed).

 

I honestly don't understand why this is necessary - I realize that Access isn't really designed for web databases, but why do you need both Access and MySQL?

 

Also, Microsoft Excel will open CSV files, so that might be an easier way to do things.

[mysql help Table '*****.categories' doesn't exist]

"spleblem_games3.categories" means it's trying to look for a "categories" table in the "spleblem_games3" database. Can you post the code you're using?

[Many rows or many fields?]

I don't think having 24 columns vs 24 rows would make much of a difference in terms of table size (you're still storing the same data).

 

However, I would recommend doing one row per hour rather than one row per day. 24 columns would make things really confusing, and you'd need other columns besides one for each hour (one to uniquely identify each row, one to keep track of which day it was, etc.).

[Inseting data]

Make sure you're either replacing the line breaks with <br /> (PHP's nl2br() function will do this), or that you're using double quotes around the value:

 

echo '\n'; - literally displays \n

echo "\n"; - outputs a linebreak

[pg_connect() not working for me]

PHP needs to be compiled with "--with-pgsql" for pg_connect() (and other PostgreSQL functions) to work. Either your host doesn't support PostgreSQL, or they forgot to compile PHP with PostgreSQL support (in which case they should be willing to recompile PHP to fix this issue).

[Database design flows?]

I would suggest having a couple additional tables:

 

Customers - A table containing information about all your car owners:

Customer_ID

First_Name

Last_Name

Address

City

State

Zip

Home_Phone

Work_Phone

Other_Phone

 

Cars - A table containing information about all the cars:

Car_ID

Customer_ID

Year

Make

Model

Color

 

Then, modify your logs table like this:

 

ID

Customer_ID

Car_ID

Service_desc

Date_service

 

Or, if you'd like to take it one step further, come up with a list of unique service codes (short text strings that uniquely identify each service) and add a services table:

 

ID_Service

Service_Code

Service_Desc

 

Then you could replace "service_desc" with "Service_code" and have even less info.

 

This will help you minimize the duplicate info stored in particular tables, while increasing flexibility.

[mySql and Visual basic]

Googling for "mysql visual basic vista" (without the quotes): http://www.codeproject.com/useritems/VBnet_to_mySQL_Server.asp

[Stopping Pasting into a textfeild.]

No matter what you do, there will always be a way around it, and it will only annoy and frustrate your users.

[Browser specific Conditionals assistence]

The conditionals were invented by Microsoft, and therefore will only work for Internet Explorer. You will need to check the user agent string to handle other browsers.

 

 

 

[PHP BB Code problem]

 

Replace "url_to_image" with the actual URL to the image.

 

(If you're wondering how I did that, I used a special tag called "nobbc" - anything within the nobbc tags will not get parsed as bbcode).

[Please someone, RGB to CMYK conversion help needed in ImageMagick]

I would suggest asking on the ImageMagick forums. ImageMagick is a separate graphics library that doesn't have anything to do with PHP.

[[SOLVED] changing default mysql socket for php]

The setting is mysql.default_socket, not mysql.default.socket. Also, make sure you reboot Apache after making changes to php.ini.

[[SOLVED] SUM help on a join]

Add GROUP BY players.player_id to the query (after the WHERE clause) and it will work.

[mysqli substitute]

MySQLi is only available with PHP 5.0.0 or higher, so if your host doesn't have it, they're most likely not running PHP5. Ask them to make sure they're running the latest versions of PHP (5.2.3) and MySQL (5.0.45).

 

The only other extension that offers the same advanced features is the "PDO" (PHP Data Objects) extension, but this has pretty much the same requirements as MySQLi, so if your host doesn't have MySQLi, then chances are PDO won't work either.

[[SOLVED] Okay, another...]

First: Subtract the last active timestamp from time().

 

Then, check it against various values:

 

Less than 60 = seconds

Less than 3600 = minutes

Less than 86400 = hours

Less than 604800 = days

Etc.

 

$active = time() - $last_active;
if($last_active < 60)
{
    $last_active_string = $last_active . ($last_active == 1) ' second' : ' seconds';
}
elseif($last_active < 3600)
{
    $last_active = (int) ($last_active / 60);
    $last_active_string = $last_active . ($last_active == 1) ' minute' : ' minutes';
}
elseif($last_active < 86400)
{
    $last_active = (int) ($last_active / 3600);
    $last_active_string = $last_active . ($last_active == 1) ' hour' : ' hours';
}
elseif($last_active < 604800)
{
    $last_active = (int) ($last_active / 86400);
    $last_active_string = $last_active . ($last_active == 1) ' day' : ' days';
}
...

 

That's pretty basic, but should give you a good idea.

[how do i display these queries? question from a noob..]

There are several problems with that code...

 

$query = "" - this will always set $query to an empty string.

Because you're not using ".=", $query will always get overwritten each time.

You can only have one WHERE keyword in a query - any other conditions must be appended using AND.

You can't just stick NULL in a query by itself.

 

It's relatively easy to fix all of those issues, but the fix mainly depends on whether or not only one variable will be set at a time.

[Parse Error In Hyperlink]

<?php
$ref[0] = "gen 1:12";
$ref[1] = "exo 2:31";
foreach($ref as $value){
echo '<a href="www.find.net/CP/Search/rsearch.php?submit=true&searchtype=All+Words&search=&wholeword=Whole+words+only.&table_display=true&lookup='.$value.'">'.$value.'</a>';
};
?>

[1&1 Hosting: Are they any good?]

1&1 has a reputation for being one of the worst hosts in the industry. Avoid them at all costs.

 

One of the biggest issues is that they're overselling - there is absolutely no way they can afford to offer 300GB of space and 3TB of bandwidth for $20 a month - the largest hard drive I can find online is 3TB (3000GB) - and that costs $6000. If you do a little googling, you'll find all kinds of horror stories about poor customer service, unannounced changes, etc. I know someone who was hosted with them years ago. It got to the point where the entire site would go down with "CPU Limits Exceeded" errors as soon as there were 10 users online (the forum was integrated with the site). I finally convinced him to move away from 1and1, and he hasn't run into that problem at all since then - even though the forum is much busier now than it was at the time.

[[SOLVED] case sensitive]

MySQL is not case-sensitive, so yes, it will still get found no matter how they type it.