Hi,
if your script makes errors on mysql_query() try to printthe errormessages sent back
by MySql:
mysql_query(...) or die(mysql_error());
see: http://www.php.net/manual/en/function.mysql-error.php
----- Original Message -----
From: "Roman" <[EMAIL PROTECTED]>
To: "Php-General" <[EMAIL PROTECTED]>
Sent: 2001. augusztus 15. 11:28
Subject: [PHP] select problem
> 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;
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]