povezujem sa Access bazom(ne pitajte me zasto sa access-om a ne MySql-om)
i u bazi jednu tabelu proba:
Code:
<?php
$conn=odbc_connect('glavna','','');
if (!$conn)
{exit("Connection Failed: " . $conn);}
$sql="SELECT * FROM proba";
$rs=odbc_exec($conn,$sql);
echo "<table border='1'><tr>";
echo "<th>id</th>";
echo "<th>Naziv</th>";
echo "<th>Opis</th></tr>";
while (odbc_fetch_row($rs))
{
$slika=odbc_result($rs,"id");
$naziv=odbc_result($rs,"naziv");
$opis=odbc_result($rs,"opis");
echo "<tr><td width='150'>$id</td>";
echo "<td width='350'>$naziv</td>";
echo "<td width='80'>$opis</td></tr>";
}
odbc_close($conn);
echo "</table border='1'>";
?>
<?php
$conn=odbc_connect('glavna','','');
if (!$conn)
{exit("Connection Failed: " . $conn);}
$sql="SELECT * FROM proba";
$rs=odbc_exec($conn,$sql);
echo "<table border='1'><tr>";
echo "<th>id</th>";
echo "<th>Naziv</th>";
echo "<th>Opis</th></tr>";
while (odbc_fetch_row($rs))
{
$slika=odbc_result($rs,"id");
$naziv=odbc_result($rs,"naziv");
$opis=odbc_result($rs,"opis");
echo "<tr><td width='150'>$id</td>";
echo "<td width='350'>$naziv</td>";
echo "<td width='80'>$opis</td></tr>";
}
odbc_close($conn);
echo "</table border='1'>";
?>
I to sve lepo radi, vraca mi celu tabelu.Medjutim kad probam:
Code:
$sql="SELECT * FROM proba WHERE id='1'";
$sql="SELECT * FROM proba WHERE id='1'";
upit mi ne prolazi.Radio sam ranije sa Accessom kroz VB.NET i znam da tamo na
primer taj upit radi.
Probao sam i
Code:
$id="1" ;
$sql="SELECT * FROM proba WHERE id='$id'";
$id="1" ;
$sql="SELECT * FROM proba WHERE id='$id'";
ali bez rezultata.
Izvinjavam se zbog duzeg teksta.
"Ne menjaj nesto sto te sasvim dobro sluzi, ne trazi leba preko pogace" - Aleksandar Andrijevic