DELETE FROM table where....

[lead2gold]

[code]
          $result=db_query("SELECT softball_game.gid FROM softball_game WHERE softball_game.sid = '?'",$this->sid);
          while($row=mysql_fetch_array ($result)){
            $delresult = db_query("DELETE FROM softball_stats WHERE softball_stats.gid = '",$row['gid']);
          }

[/code]

I need to simplify the above code... is it possible?
like into one db_query()?

[michaellunsford]

It seems you're really looking for mysql query help. You might try posting on the mysql forum on this site -- I've gotten good answers there before -- most of which refer me to the reference manual -- but good answers just the same