Jump to content
Fórum Script Brasil
  • 0

ERRO: IE TRAVA AO EXECUTAR QUERY


PaulinhoM

Question

Boa tarde,

Estou com um problema que não consegui encontrar no fórum.

Estou criando um sistema que utiliza uma query, depois utiliza um While e dentro deste while, faz uma verificação com IF.

Depois, exibe os dados do Banco.

No Chrome e no Firefox funcionam normalmente.

Porém, no IE ele trava e para de responder.

Não sei se é problema, mas na minha query, utilizo INNER JOIN

<?php
                        
                            $task="SELECT 
                            spac_taskmanager.task_manager_id,
                            spac_taskmanager.task_manager_id_periodo,
                            spac_taskmanager.task_manager_id_festa,
                            spac_taskmanager.task_manager_fazer,
                            spac_taskmanager.task_manager_contratar,
                            spac_taskmanager.task_manager_dias,
                            
                            
                            spac_festa_categoria.festa_categoria_nome,
                            spac_festa_categoria.festa_categoria_id FROM
                            
                            spac_taskmanager INNER JOIN spac_festa_categoria 
                            ON spac_taskmanager.task_manager_id_festa=spac_festa_categoria.festa_categoria_id
                            
                            WHERE spac_festa_categoria.festa_categoria_nome= 'Casamento' AND
                            spac_taskmanager.task_manager_status='Ativo' AND spac_taskmanager.task_manager_id_periodo='".$_GET['temp']."'";
                            $task_query=mysql_query($task) or die(mysql_error());
                            $num=mysql_num_rows($task_query);
                    
                                    while($task_linha=mysql_fetch_array($task_query))
                                        {
                                                if($task_linha['task_manager_id_periodo']==$_GET['temp'])
                                            {
                                                
                                                echo"<tr>";
                            
                                                    echo"<td style='height:10px; width:10px;vertical-align:top;'>";
                                                        echo"<form style='height:100%;width:100%;'>";
                                                        echo"<INPUT TYPE='checkbox' NAME='task' VALUE='".$task_linha['task_manager_fazer']."'>";
                                                    echo"</td>";
                                                    echo"<td style='height:10px; width:650px; color:#555555;'>";
                                                        echo"<b>".$task_linha['task_manager_fazer']."<b>";
                                                    echo"</td>";
                                                    echo"<td>";
                                                        echo"<input type='image' src='images/edit.jpg' name='acao' value='A'>";
                                                    echo"</td>";
                                                echo"<tr>";
                                                    echo"<td>";
                                                        echo"<br />";
                                                    echo"</td>";
                                                echo"</tr>";
                                                echo"</tr>";
                                            } 
                                            
                                        }
                                echo"</td>";
                            echo"</tr>";
                            

                        ?>

OBRIGADO!

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Olá PaulinhoM,

Verifique duas coisas:

1ª - Porque você está utilizando o if dentro do while se você está filtrando essa mesma informação na última linha do seu select?

2ª - Verifique a sua sintaxe HTML porque ela está bem confusa. Por exemplo:

- Você abriu um form na primeira linha da tabela mas não fechou ele.

- Você está fechando a tag de linha <tr> de forma errada.

- Todos os elementos e atributos devem estar em minúsculas (ex. sua tag input)

Aconselho você dar uma olhada em alguma material sobre sintaxe básica de HTML (http://www.w3schools.com/html/default.asp).

Link to comment
Share on other sites

Join the conversation

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

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  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.



  • Forum Statistics

    • Total Topics
      152.2k
    • Total Posts
      652k
×
×
  • Create New...