panquetofobia
-
Content Count
29 -
Joined
-
Last visited
-
the problem is with the count(*) query. everything else works fine. @MC what's the difference in performance between header('Location: main.php'); and header("Location: main.php"); ??? i know there r some easy ways... but i learned php using google. it doesn't please read my comments below. hope u'll find out the solution .. $code = md5($code); // IS THIS CORRECT?-> yes it is. no problem with this line.if(@$codigo != $code) header('Location: main.php');elseif($deporte . $rama . $enc_reg . $centro_trabajo == '') header("Location: reg1.php?codigo=$code&\x3benc_reg=$enc_reg");else{ //PRINCIPAL - MAIN?><link href="/css/base.css" rel="stylesheet" type="text/css" /><body style="background: url(/img/regbg.gif) no-repeat fixed top right;"><p><img src="./imgs/paso3.gif" border="0" alt=""></p><p>Gracias por identificarse <strong><?php echo $enc_reg; ?></strong></p><p>Registro de Jugadores de <?php echo $deporte . ' ' . $rame; ?> para el Centro de Trabajo <?php echo $centro_trabajo; ?></p><?php }$fecha = date('Y-m-d');$sqlcheck = "SELECT integrantes_restantes FROM equipos WHERE Centro_de_Trabajo = '$centro_trabajo' AND Deporte = '$deporte'";$querycheck = mysql_query($sqlcheck) or die(mysql_error());$A = mysql_fetch_object($querycheck);@$merror .= "Hasta $A -> integrantes_restantes jugadores por registrar.";if(@$ddok) // enviado - submitted{ if(@$ape1 . $ape2 . $nombre . $no_ficha . @$sit_cont . @$sub_sit_cont . $anios . $talla == '')  @$merror .= '<p style="color: #990000' . "\x3b" . ' font-weight: bold' . "\x3b" . '">Por Favor Llene el Formulario completamente.</p>'; else // lleno - filled {  // sql ya registrado ó sancionado?? - sql registered or punished??  $sqlcheck = "SELECT COUNT(*) FROM sancionados, participantes WHERE sancionados.No_Ficha = '$no_ficha' AND participantes.No_Ficha = '$no_ficha'"; // here's the problem.  $querycheck = mysql_query($sqlcheck) or die(mysql_error());  // IS THERE SUPPOSE TO BE $A = mysql_fetch_object($querycheck); HERE? -> no, i take the object from the first mysql_fetch object. works fine. no problem here.  if($A -> integrantes_restantes == 0) // no hay lugares libres? - no positions left?  {  @$merror .= '<p style="color: #990000' . "\x3b" . 'font-weight: bold' . "x3b" . '">JUGADOR SANCIONADO, IMPOSIBLE REGISTRAR. <img src="/imgs/error.gif" alt=""></p>';  echo '<meta http-equiv="refresh" content="3' . "\x3b" . 'url=index.php" />';  }  else // no registrado ni sancionado. hay cupo. - neither registered nor punished. positions availables  {  $situancionc = $sit_cont . ' ' . $sub_sit_cont;  $sql = "INSERT INTO participantes VALUES (0, '$nombre', '$ape1', '$ape2', '$no_ficha', '$situancionc', '$talla', '$anios', '$deporte', '$rama', '$centro_trabajo', '$enc_reg', '$fecha')"; this query works, but its function depends on the count(*) query above.....  $query = mysql_query($sql) or die(mysql_error()); // registro de jugador - storing player info  $sql = "UPDATE equipos SET integrantes_restantest = (integrantes_restantest - 1) WHERE Centro_de_Trabajo = '$centro_trabajo' AND Deporte = '$deporte'"; //works fine.  $query = mysql_query($sql) or die(mysql_error());  @$merror .= '<p>Jugador ' . $nombre . ' ' . $ape1 . ' ' . $ape2 . ' <strong>Registrado</strong> <img src="/imgs/oki.gif" alt=""></p>';  } }}form_jugadores(@$desp, $code, @$enc_reg, @$merror, @$deporte, @$rama, @$centro_trabajo);} // WHAT IS THIS CLOSING?- the end of the firt 'else'// FIN PRINCIPAL - END MAIN // <{POST_SNAPBACK}> greetings from MÊxico.
-
hello guys. the problem with this script is that the insert query dosen't function properly as it depends on the result of a count(*) query. the update query works fine.... here's some code: $code=md5($codea);if(@$codigo!=$code)// no autenticado - not authenticated{ header ("Location: main.php");}elseif($deporte=="" || $rama=="" || $enc_reg=="" || $centro_trabajo==""){ header ("Location: reg1.php?codigo=$code&enc_reg=$enc_reg");}else //todo bien - everything is ok{// PRINCIPAL - MAIN // echo "<link href=\"./css/base.css\" rel=\"stylesheet\" type=\"text/css\" />"; echo "<body style=\"background-image:url(./imgs/regbg.gif)\x3b background-repeat: no-repeat\x3b background-position: top right\x3b background-attachment:fixed\x3b \">"; echo "<p><img src=\"./imgs/paso3.gif\" border=\"0\" alt=\"\"></p>"; echo "<p>Gracias por identificarse <b>$enc_reg</b></p><p>Registro de Jugadores de $deporte $rama para el Centro de Trabajo $centro_trabajo </p>"; $fecha=date("Y-m-d"); $sqlcheck="SELECT integrantes_restantes FROM equipos WHERE Centro_de_Trabajo='$centro_trabajo' and Deporte='$deporte'"; $querycheck=mysql_query($sqlcheck); $A=mysql_fetch_object($querycheck); @$merror.="Hasta $A->integrantes_restantes jugadores por registrar."; if (@$ddok)//enviado - submitted { if(@$ape1=="" || $ape2=="" || $nombre=="" || $no_ficha=="" || @$sit_cont=="" || @$sub_sit_cont=="" || $anios=="" || $talla=="") { @$merror.="<p style=\"color:#990000\x3b font-weight:bold\">Por Favor Llene el Formulario completamente.</p>"; } else //lleno - filled { //sql ya registrado Ăł sancionado?? - sql registered or punished ?? $sqlcheck="SELECT COUNT(*) FROM sancionados,participantes WHERE sancionados.No_Ficha='$no_ficha' AND participantes.No_Ficha='$no_ficha'"; $querycheck=mysql_query($sqlcheck) || die(mysql_error()); if($A->integrantes_restantes==0)//no hay lugares libres? - no positions left? { @$merror.="<p style=\"color:#990000\x3b font-weight:bold\">CENTRO DE TRABAJO COMPLETO. NO HAY REGISTROS DISPONIBLES. <img src=\"./imgs/error.gif\" alt=\"\"></p>"; echo "<meta http-equiv=\"refresh\" content=\"3\x3burl=index.php\">"; } elseif(@mysql_result($querycheck,0,0)>0) //ya registrado Ăł sancionado?? - registered or punished ?? { $merror.="<p style=\"color:#990000\x3b font-weight:bold\">JUGADOR SANCIONADO, IMPOSIBLE REGISTRAR. <img src=\"./imgs/error.gif\" alt=\"\"></p>"; } else //no registrado ni sancionado. hay cupo. - neither registered nor punished. positions availables { $situacionc="$sit_cont $sub_sit_cont"; $sql="INSERT INTO participantes VALUES ( 0 , '$nombre','$ape1','$ape2','$no_ficha','$situacionc','$talla','$anios','$deporte','$rama','$centro_trabajo','$enc_reg','$fecha')"; $query=mysql_query($sql) || die(mysql_error()); // registro de jugador - storing player info $sql="UPDATE equipos SET integrantes_restantes=(integrantes_restantes - 1) where Centro_de_Trabajo='$centro_trabajo' and Deporte='$deporte'"; $query=mysql_query($sql) || die(mysql_error()); // una posiciĂłn menos - minus one position @$merror.="<p>Jugador $nombre $ape1 $ape2 <strong>Registrado</strong> <img src=\"./imgs/oki.gif\" alt=\"\"></p>"; } } }form_jugadores(@$desp,$code,@$enc_reg,@$merror,@$deporte,@$rama,@$centro_trabajo);}// FIN PRINCIPAL - END MAIN // thank u very much for your help
-
note:macromedia and winamp run in linux
-
a part of my code... $sqlcheck="SELECT count(*) FROM participantes AS a, sancionados AS b WHERE a.No_Ficha = '$no_ficha' OR b.No_Ficha='$no_ficha';"; $querycheck=mysql_query($sqlcheck) || die(mysql_error());; if(@mysql_result($querycheck,0,0)>0) { $merror.="<p style=\"color:#990000; font-weight:bold\">JUGADOR YA REGISTRADO Ó SANCIONADO <img src=\"./imgs/error.gif\" alt=\"\"></p>"; } else { $sql="UPDATE equipos SET integrantes_restantes='$integrantesr' where Centro_de_Trabajo='$centro_trabajo' and Deporte='$deporte'";$query=mysql_query($sql); $sql="INSERT INTO participantes VALUES (0,'$nombre','$ape1','$ape2','$no_ficha','$situacionc','$talla','$anios','$deporte','$rama','$centro_trabajo','$enc_reg','$fecha'"; $query=mysql_query($sql); @$merror.="<p>Jugador ".$nombre." ".$ape1." ".$ape2." <strong>Registrado</strong> <img src=\"./imgs/oki.gif\" alt=\"\"></p>"; } the insert query doesn't function either ... thank u guys ... greetings from MĂŠxico City
-
Swf In Trouble problem loading .swfs
panquetofobia replied to panquetofobia's topic in Graphics, Design & Animation
no... i design on a generic pc with windows xp, and sometimes linux mandrake 10.p4 2ghz, 256mb ram, 64mb video, 60 g hd... and..... i use flash mx 2004 progreetings from méxico -
Swf In Trouble problem loading .swfs
panquetofobia replied to panquetofobia's topic in Graphics, Design & Animation
it seems that theres' no possible solution.i'll make the menu in fireworks........ -
Swf In Trouble problem loading .swfs
panquetofobia replied to panquetofobia's topic in Graphics, Design & Animation
i have re generated the swf lots of times.... the web page is the index.php in my local server and in http://participantes.co.nr/ loads properly... i have talked to opaque about this and he said it was sth on my side. -
doesn't function....but thank u so much avalon
-
Swf In Trouble problem loading .swfs
panquetofobia replied to panquetofobia's topic in Graphics, Design & Animation
damn...i've just tried both....no succes :)this is very weird, cuz the code functions in other hosts...thanx anyway.... -
Swf In Trouble problem loading .swfs
panquetofobia replied to panquetofobia's topic in Graphics, Design & Animation
didn't function.............!!!!!1 any other idea??greetings from México -
Swf In Trouble problem loading .swfs
panquetofobia replied to panquetofobia's topic in Graphics, Design & Animation
Thanx a lot!!!let me try... -
i dunno why this query doesn't function.. $sql="SELECT count(*) FROM participantes,sancionados WHERE participantes.No_Ficha = '$no_ficha' or sancionados.No_Ficha='$no_ficha'";$query=($sql); any suggestion???
-
hello guys... i have this problen since i signed up. my website has a flash menu which never loads. <object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,0,0" width="180" height="160" id="menu" align="middle"><param name="movie" value="./swf/menu.swf"><param name="quality" value="high"><param name="bgcolor" value="#ffffff"><embed src="./swf/menu.swf" quality="high" bgcolor="#ffffff" width="180" height="160" name="menu" align="middle" type="application/x-shockwave-flash" pluginspage="https://get.adobe.com/flashplayer/otherversions/;the file name is ''menu.swf'' in the 'swf' directory. have u ever had any similar problem??? greetings from MĂŠxico City
-
can't load a .SWF need some help please
panquetofobia replied to panquetofobia's topic in Web Hosting Support
opaque...the problem is with the server... u have to know what the misconfiguration is.i host my site in another server and it works. (now the server everywebhost.com is down).i like Xisto and would like to find out what the problem is so that i can host my site here. i really like the forums....saludos desde méxico -
anyway... thank u very much for your help !!