Re: [PHP] SELECT problem..Need urgent help !!!!

[Greg Donald]

On Mon, 29 Nov 2004 17:27:26 +0200, Phpu <[EMAIL PROTECTED]> wrote:
> I have an array named $ex_array.
> 
> I want to search the database and find those ids that are different from the 
> values in $ex_array.
> 
> I use this but didn't work
> 
> $sql = "SELECT product_id FROM products WHERE product_id <> '$ex_array' " ;

$sql = "
SELECT
product_id
FROM
products
WHERE
product_id NOT IN ( "
. implode( ', ', $ex_array )
. " ) ";

This question would be more appropriate for the php-db list.


-- 
Greg Donald
Zend Certified Engineer
http://gdconsultants.com/
http://destiney.com/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] SELECT problem..Need urgent help !!!!

[Phpu]

Hi,

I have an array named $ex_array.

I want to search the database and find those ids that are different from the 
values in $ex_array.

I use this but didn't work

$sql = "SELECT product_id FROM products WHERE product_id <> '$ex_array' " ; 


Thanks for any help 

Re: [PHP] select problem

[Gyozo Papp]

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.\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]

[PHP] select problem

[Roman]

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.\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]