[SELECT com PHPnão exibe tudo]

Já identifiquei o problema, foi a conexão com a base de dados que não estava boa. Obrigado!!

Como finalizo o post??!

[SELECT com PHPnão exibe tudo]

Estou tendo exibir todos os resultados encontrados vindo da minha base, no entanto quando faço pelo php o mesmo só mostra 10 resultados no maximo. Qual faço no meu sql pela base, mostra todos os 233 registros. 

$sqlExibeQuest = "SELECT  al_reg, Cod_Questoes, Resp_Aluno, perletivo, Ordem, finalizada
  FROM           Prova
  WHERE        (al_reg = '$matricula') AND (perletivo = '$perletivo')
  ORDER BY Ordem ASC ";
  //die($sqlVerificaDia);  
  //retornar o consulta
  $params = array();
  $options =array('Scrollable' => SQLSRV_CURSOR_KEYSET);
  $ExibQuest = sqlsrv_query($conn, $sqlExibeQuest, $params, $options);

while ($Quest = sqlsrv_fetch_array($ExibQuest, SQLSRV_FETCH_ASSOC)) { 

	echo $Quest['Cod_Questoes'];

}

Alguém sabe porque isso acontece e como resolver para mostrar todos os registros e não apenas os 10 que estão sendo exibidos?

[Retornar IP da maquina]

beleza galera,

estou tendo um problema ao pegar o iP da maquina, quando uso a função echo $_SERVER['REMOTE_ADDR']; está me retornando o getway e não o IP porque isso está ocorrendo?

[Problemas com SQL]

Eu tenho uma tabela em html que tá realizando o select de duas outras tabelas uma professor e a outra frases, criei uma outra tabela no musql para gravar os dados do formulario html tipo radio. O que preciso é gravar na tabela voto o voto desse radio, no professor e frase sequente. Segue o codigo:

<form action="cadastrar.php" method="post">
<table width="100%" border="1">
<tr>
<td width="5%" class="frases" >PROFESSOR(A)</td>

<?php
//consulta sql
$query = mysql_query("SELECT * FROM frases ORDER BY id") or die(mysql_error());

//faz um looping e cria um array com os campos da consulta
while($array = mysql_fetch_array($query))
{
//mostra na tela o nome e a data de nascimento

echo '<td width="23%" class="frases">'.$array['texto'].' </td> ';
}
?>
</tr>
<?php

//consulta sql
$query = mysql_query("SELECT * FROM professor ORDER BY id") or die(mysql_error());

//faz um looping e cria um array com os campos da consulta
while($array = mysql_fetch_array($query))
{
?>

<tr>
<?php
echo'<td class="frases"><strong>'.$array['nome'].'</strong>
<td>
1<input name="criterio" type="radio" value="1" />
2<input name="criterio" type="radio" value="2" />
3<input name="criterio" type="radio" value="3" />
4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</td>
<td>
1<input name="criterio" type="radio" value="1" />
2<input name="criterio" type="radio" value="2" />
3<input name="criterio" type="radio" value="3" />
4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</td>
<td>
1<input name="criterio" type="radio" value="1" />
2<input name="criterio" type="radio" value="2" />
3<input name="criterio" type="radio" value="3" />
4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</td>
<td>
1<input name="criterio" type="radio" value="1" />
2<input name="criterio" type="radio" value="2" />
3<input name="criterio" type="radio" value="3" />
4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</td>
<td>
1<input name="criterio" type="radio" value="1" />
2<input name="criterio" type="radio" value="2" />
3<input name="criterio" type="radio" value="3" />
4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</td>
<td>
1<input name="criterio" type="radio" value="1" />
2<input name="criterio" type="radio" value="2" />
3<input name="criterio" type="radio" value="3" />
4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</td>
<td>
1<input name="criterio" type="radio" value="1" />
2<input name="criterio" type="radio" value="2" />
3<input name="criterio" type="radio" value="3" />
4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</td>
<td>
1<input name="criterio" type="radio" value="1" />
2<input name="criterio" type="radio" value="2" />
3<input name="criterio" type="radio" value="3" />
4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</td>
<td>
1<input name="criterio" type="radio" value="1" />
2<input name="criterio" type="radio" value="2" />
3<input name="criterio" type="radio" value="3" />
4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</td>
<td>
1<input name="criterio" type="radio" value="1" />
2<input name="criterio" type="radio" value="2" />
3<input name="criterio" type="radio" value="3" />
4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</td>
<td>
1<input name="criterio" type="radio" value="1" />
2<input name="criterio" type="radio" value="2" />
3<input name="criterio" type="radio" value="3" />
4<input name="criterio" type="radio" value="4" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</td>

</td>';
}
?>

</table>

[(Resolvido) Problema com a FOREIGN KEY]

Oi, 'web_charles'

corrija esta linha

FOREIGN KEY (cod_emprestimo) references cliente(cod_cliente));

para que fique assim:

FOREIGN KEY (cod_emprestimo) references EMPRESTIMO (Cod_emprestimo));

Pô parceiro, muito obrigado! você salvou minha vida. Agora poderei dar continuidade ao meu trabalho.

Abração!

[(Resolvido) Problema com a FOREIGN KEY]

tenho a seguinte DER:

EMPRESTIMO ( Cod_emprestimo (primary key) , Valor , Data_hora )

CLIENTE (Cod_cliente (primary key) , cod_emprestimo (foreign key) ,Nome , data_nasc , idade , telefone )

MUNICIPIO ( Nome (primary key) , CEP )

ESTADO (Sigla (primary key) , Nome )

O erro é no codigo:

CREATE TABLE cliente(

cod_cliente int( 7 ) NOT NULL ,

cod_emprestimo int( 7 ) NOT NULL ,

nome varchar( 50 ) NOT NULL ,

data_nasc int( 8 ) NOT NULL ,

idade int( 2 ) NULL ,

telefone int( 10 ) NULL ,

PRIMARY KEY ( cod_cliente ) ;

FOREIGN KEY (cod_emprestimo) references cliente(cod_cliente));

Quando jog no meu banco de dados a tabela CLIENTES dá um erro de sintaxe creio que seja na FOREIGN KEY. Gostaria de saber se classifiquei certo esse meu SISTEMA DE COBRANÇA?

Grato!