This topic is locked

PHP ERROR

5/2/2008 7:21:32 AM
PHPRunner General questions
F
futo author

I WANT TO DISPLAY TREE FIELDS FROM ANOTHER TABLE (pod_7165) TO ANOTHER TABLE (7165_list.php)
I USE PHP SPINET
// Put your code here.

global $conn;

$str = "select * from pod_7165";

$rs = db_query($str,$conn);

while ($data = db_fetch_array($rs))

{

echo "Broj_dozvole: ".$data["Broj_dozvole"]."
";

echo "Kupac: ".$data["Kupac"]."
";

echo "Kolicina: ".$data["Kolicina"]."
";

};
I GETT THIS:
PHP error
Technical information

ERROR TYPE 256

EROR DESCRIPTION Table 'zupsphr_viro.pod_7165' doesn't exist

URL www.zupanjasped.hr/viro/_7165_list.php?

ERROR IN : /home2/zupsphr/public_html/viro/include/dbconnection.php

ERROR IN LINE 26

SQL upit SELECT `_7165`.Id, `_7165`.Datum, `_7165`.Racun, `_7165`.Eur, `_7165`.Kg, `_7165`.Jcd, `_pod_7165`.Broj_dozvole, `_pod_7165`.Kupac, `_pod_7165`.Kolicina, `_7165`.Ostalo FROM `_7165` , `_pod_7165` ORDER BY `_7165`.Racun DESC
PHPRUNNER 4.2 368

PHP version 4.4.7

MySQL version 4.0.27-standard
THANKS

Sergey Kornilov admin 5/2/2008

There seems to be a problem with table name:

global $conn;

$str = "select * from _pod_7165";

$rs = db_query($str,$conn);

while ($data = db_fetch_array($rs))

{

echo "Broj_dozvole: ".$data["Broj_dozvole"]."
";

echo "Kupac: ".$data["Kupac"]."
";

echo "Kolicina: ".$data["Kolicina"]."
";

};