Jump to content

Hellp with failing code


j4ymf

Recommended Posts

Hello i have been running a fantasy football site for 7 years with this code but it is failing now with an error,  Why!

 

can anyone please help because its been so long since ive used php

 


<?php
function build_league_table($teamname) {

$connection = mysql_connect($host, $user,$password) or die ("Couldn't connect to server.");
$db = mysql_select_db($database, $connection) or die ("Couldn't select database.");

$sql = "SELECT a.id, a.name, a.team, a.price, a.points, c.NEW_POINTS, ";
$sql .= "IF (c.NEW_POINTS IS NOT NULL , a.points - c.NEW_POINTS, a.points) AS 'REAL_TOTAL', ";
$sql .= "IF (c.NEW_POINTS IS NOT NULL, 'SUB', 'NOTSUB') AS 'SUBQ' ";
$sql .= "FROM teams b, dreamteam a ";
$sql .= "LEFT OUTER JOIN subs2 c ON c.NEW_ID = a.ID ";
$sql .= "AND b.team_name = c.team_name ";
$sql .= "WHERE b.team_name = '$teamname' "; 
$sql .= "AND a.id ";
$sql .= "IN (b.player_1, b.player_2, b.player_3, b.player_4, b.player_5, ";
$sql .= "b.player_6, b.player_7, b.player_8, b.player_9, b.player_10, b.player_11) ";
$sql .= "ORDER BY a.id ";   // change to .team

$result = mysql_query($sql) or die ("Error when building the team league table!  (function 2)");



if ($myrow = mysql_fetch_array($result)){

 

many thanks jason

Link to comment
Share on other sites

hello

 

yes i do have a column called team_names in my teams table.

 

in my editor the text is red on this line

$sql = "SELECT a.id, a.name, a.team, a.price, a.points, c.NEW_POINTS, ";

 

thank you for your time jason

Link to comment
Share on other sites

Post a database table structure dump of the `teams` table.

 

If using phpMyAdmin, choose table, goto Export , un-check everything but 'Structure', make sure you DO NOT check 'Save as File'.  Copy and paste what is printed to the screen.  Post it here.

Link to comment
Share on other sites

thankyou

 

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

 

CREATE TABLE teams (

  TEAM_NAME varchar(50) collate latin1_general_ci NOT NULL default '',

  TEAM_ADMIN int(2) NOT NULL default '0',

  PLAYER_1 int(3) NOT NULL default '0',

  PLAYER_2 int(3) NOT NULL default '0',

  PLAYER_3 int(3) NOT NULL default '0',

  PLAYER_4 int(3) NOT NULL default '0',

  PLAYER_5 int(3) NOT NULL default '0',

  PLAYER_6 int(3) NOT NULL default '0',

  PLAYER_7 int(3) NOT NULL default '0',

  PLAYER_8 int(3) NOT NULL default '0',

  PLAYER_9 int(3) NOT NULL default '0',

  PLAYER_10 int(3) NOT NULL default '0',

  PLAYER_11 int(3) NOT NULL default '0',

  PRIMARY KEY  (TEAM_NAME)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

 

Link to comment
Share on other sites

some one else has told me to turn these around which has got rid of the error but it still cant build the table!

 

$sql .= "WHERE b.team_name = '$teamname' ";

$sql .= "AND b.team_name = c.team_name ";

 

confusing it has worked for so long until now!

Link to comment
Share on other sites

a friend come to my help,

 

this is how we ended up!

 

$sql = "SELECT a.id, a.name, a.team, a.price, a.points, c.NEW_POINTS, ";
$sql .= "IF (c.NEW_POINTS IS NOT NULL , a.points - c.NEW_POINTS, a.points) AS 'REAL_TOTAL', ";
$sql .= "IF (c.NEW_POINTS IS NOT NULL, 'SUB', 'NOTSUB') AS 'SUBQ' ";
$sql .= "FROM teams b";
$sql .= "	INNER JOIN dreamteam a ";
$sql .= "		ON a.id IN (";
$sql .= "				b.player_1, b.player_2, b.player_3, b.player_4, b.player_5, ";
$sql .= "				b.player_6, b.player_7, b.player_8, b.player_9, b.player_10, b.player_11) ";
$sql .= "	LEFT OUTER JOIN subs2 c ON c.NEW_ID = a.ID AND b.team_name = c.team_name ";
$sql .= "WHERE b.team_name = '$teamname' ";
$sql .= "ORDER BY a.id"

 

thanks for everyones help today - jason

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

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