echo from table

[pang]

hi,
i have problem with this coding, i want to echo the anc_pagebo and the anc_numbo, but i can't ,
i could just echo the anc_numarrete, is there an errorr in my code?

$sqlquery1="SELECT num_arrete FROM Arrete WHERE num_arrete='$ancienarrete'";
$result1=mssql_query($sqlquery1) or die ("impossible d executer la requete Select");

$row=mssql_fetch_array($result1);

$anc_numarrete=$row['num_arrete'];
$anc_numbo=$row['num_bo'];
$anc_pagebo=$row['page_bo'];

echo $anc_numarrete;
echo $anc_numbo;
echo $anc_pagebo;

mssql_close($sqlconnect);
mssql_free_result($result1);

could anyone help, thanks

[pang]

😕
please is there anyone to help me

[pang]

the error is in the query:
:o

$sqlquery1="SELECT * FROM Arrete WHERE num_arrete='$ancienarrete'";
$result1=mssql_query($sqlquery1) or die ("impossible d executer la requete Select");

$row=mssql_fetch_array($result1);

$ancnumarrete=$row['num_arrete'];
$ancnumbo=$row['num_bo'];
$ancpagebo=$row['page_bo'];

echo $ancnumarrete;
echo $ancnumbo;
echo $ancpagebo;

mssql_close($sqlconnect);
mssql_free_result($result1);

thanks

[thorpe]

without knowing whatever language that is, i'll assume num_arrete is a number.

try;

$sqlquery1="SELECT * FROM Arrete WHERE num_arrete=$ancienarrete";