Problema con sql!!! Help please....

[fmb1982]

Código PHP:

  <?php 
include("con_sql_server.php"); 
$result=mssql_query("select no_con from usr_ban group by no_con");  
echo '<p align="justify"><span class="style39">BANCOS</span><FONT FACE="arial" SIZE="2"><br>'; 
while ($row=mssql_fetch_array($result)) {  
$i=$i+1; 
echo $i.'<font color="#999999"><b>'.$row["no_con"].'</b></font><br>';   
$var[$i]=$row["no_con"]; 
}  
echo "</TABLE></p></font>"; 
 
$con++; 
$result=mssql_query(sprintf("select * from usr_ban where no_con=%s", $var[$con]));  
echo '<p align="left"><span class="style39">DEPOSITOS</span><FONT FACE="arial" SIZE="2">'; 
echo '<TABLE CELLPADDING="2" CELLSPACING="2" WIDTH="100%">'; 
echo '<TR><TD BGCOLOR="#999999"><b>BANCO</b></TD><TD BGCOLOR="#999999"><b>DIA/MES/AÑO</b></TD><TD BGCOLOR="#999999"><b>CUENTA</b></TD></TR>'; 
while ($row=mssql_fetch_array($result)) {  
echo '<TR><TD BGCOLOR="#A9B6AD">'.$row["no_con"].'</TD><TD BGCOLOR="#A9B6AD">'.$row["n_dd"].'/'.$row["n_dm"].'/'.$row["n_da"].'</TD><TD BGCOLOR="#A9B6AD">'.$row["nu_con"].'</TD></TD><TD BGCOLOR="#A9B6AD">'.$row["nu_con"].'</TD>';   
echo '</TR>';           
} 
echo "</TABLE></p></font>"; 
?>:'(  

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'Banamex'. (severity 16) in C:\xampplite\htdocs\bank_con.php on line 21

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampplite\htdocs\bank_con.php on line 21

DEPOSITOSBANCO DIA/MES/AÑO CUENTA

Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in C:\xampplite\htdocs\bank_con.php on line 25

[Genetix]

Verifica que las estés escribiendo correctamente el nombre de las columnas

[fmb1982]

for ($con = 0; $con <$i; $con++){
$result=mssql_query("select * from usr_ban where no_con=$var[$con]");

Me marca esto!!!!

Warning: mssql_query() [function.mssql-query]: message: Line 1: Incorrect syntax near '='. (severity 15) in C:\xampplite\htdocs\bank_con.php on line 22

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampplite\htdocs\bank_con.php on line 22

DEPOSITOSBANCO DIA/MES/AÑO CUENTA INGRESO/EGRESO

Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in C:\xampplite\htdocs\bank_con.php on line 26

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'Banamex'. (severity 16) in C:\xampplite\htdocs\bank_con.php on line 22

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampplite\htdocs\bank_con.php on line 22

[Francisco01]

Cambia esta linea:
$result=mssql_query("select * from usr_ban where no_con=$var[$con]");

Por:

$result=mssql_query("select * from usr_ban where no_con='$var[$con]'");

Un saludo

[GatorV]

Porfavor fmb1982

Deja de duplicar temas.

Saludos.