select problem
| From: | Roman | Date: | Wed, 15 Aug 2001 09:28:29 +0000 |
| Subject: | select problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-62800@lists.php.net to get a copy of this message | ||
I have mysql in redhat linux and apache 1.3.20 with module php 4.0.6
but I have error in my select, connect to the database is ok. In apache and
mysql uder windows
working this script OK but no in linux.
What's wrong ?
@$spojenie = mysql_connect("localhost","user","password");
if (!$spojenie) :
echo "Chyba pri konektne na databazu !!!";
exit;
endif;
mysql_select_db("Patenty",$spojenie);
$podmienka = "Cislo_dokumentu BETWEEN 238000 AND 238023";
$tried = "Cislo_dokumentu";
if ($podmienka !="") @$vysledok = mysql_query("SELECT * FROM patent WHERE
$podmienka ORDER BY $tried",$spojenie);
else @$vysledok = mysql_query("SELECT * FROM patent ORDER BY
$tried",$spojenie);
if (!$vysledok):
echo "Error.<BR>\n";
exit;
endif;