why this is not working

[hassank1]

I've got an error executing this script !! I don't know what's wrong !!

 

$StudyGroups=array(

'Arts & Design',

'Engineering',

'Education',

'Communication Arts',

'Computer',

'Business',

'Pharmacy',

'sciences',

'Lab Reports (Engineering)',

'Lab Reports (Sciences)'

);

 

$GetStudyGroups_Query="select GroupID,GroupName

from groups

where GroupName IN $StudyGroups

";

$StudyGroups_Result=mysql_query($GetStudyGroups_Query);

echo mysql_num_rows($StudyGroups_Result);exit();

 

[dezkit]

<?

$StudyGroups=array(
   'Arts & Design',
   'Engineering',
   'Education',
   'Communication Arts',
   'Computer',
   'Business',
   'Pharmacy',
   'sciences',
   'Lab Reports (Engineering)',
   'Lab Reports (Sciences)'
   );
   
   $GetStudyGroups_Query="select GroupID,GroupName
                     from groups
                     where GroupName IN $StudyGroups
                     ";                      
   $StudyGroups_Result=mysql_query($GetStudyGroups_Query);
   echo mysql_num_rows($StudyGroups_Result);exit();

?>

[hassank1]

it is still the same !!

[alecks]

what is the error, that you are getting...

[Barand]

<?php
$groupList = join ("','", $studyGroups);

$GetStudyGroups_Query="select GroupID,GroupName
                     from groups
                     where GroupName IN ('$groupList');
                     "; 

[hassank1]

<?php
$groupList = join ("','", $studyGroups);

$GetStudyGroups_Query="select GroupID,GroupName
                     from groups
                     where GroupName IN ('$groupList');
                     "; 

 

thanks it worked

however,why my previous code didn't work ? and what the above code means (join() !! ) ?

 

[Barand]

if you have

 

$ar = array ('A'. 'B', 'C');

 

then join (',' , $ar) returns "A,B,C" (the array elements separated by a comma).

 

For your query you needed .... IN ('A','B','C') , with quotes, so I joined the elements with "','"

 

www.php.net/join

[hassank1]

ok thx . SOLVED

[Barand]

 

however,why my previous code didn't work ?

 

 

try doing it your way and

 

echo $GetStudyGroups_Query;

 

then echo my query.