Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by SurfScape

  1. SurfScape

    I have an array, I want to check fo

    Thanks that worked like a charm, I had to format the data, the array I showed was after the data was reposted to the form for another error. Values could be 40 and Null so, here it is. Much Thanks again. foreach ($_POST['data'] as $v) { $v = sprintf( "%01.2f", $v...
  2. SurfScape

    I have an array, I want to check fo

    I have an array, I want to check for errors before placing in my db. [data] => Array ( [E001] => 40.00 [E021] => 2.25 [E022] => 1.16 [E01S] => 0.00 [E012] => 0.00 [E09B] => 0.00 ) Now, these values can...
  3. SurfScape

    Help with query

    Never mind I figured it out, left the points in the game table.
  4. SurfScape

    Help with query

    so what are you saying have points in both places game and point table, one constantly updating the other, get game info from game tbl and standings from point table?
  5. SurfScape

    Help with query

    Actually in the game_mastertbl the home_points and away_points columns were something I added in for testing, with these columns I can get the desired query result, but had difficulty adding (SUM) the points for the teams and displaying standings, this is why I went to a points table. It made...
  6. SurfScape

    Help with query

    I have 3 tables (actually alot more, but three for this query): # # Table structure for table `game_mastertbl` # CREATE TABLE game_mastertbl ( id int(11) NOT NULL auto_increment, game_id varchar(20) NOT NULL default '', tourney_id int(11) NOT NULL default '0', division_id int(11) NOT...

Part and Inventory Search

Back
Top