Retrieval issue

Hi,

So, at the end of your code, is $prod an array of titles, or descriptions?

Are you trying to retrieve all of the file names from CMSB that match that array of titles?

Let me know and we'll figure out a solution.

Hi,

Okay, what we can do is use the information in $prod to create a list that we can search the database with:

First, we use this code:
$list="(";
foreach($prod as $p){
if($list=="("){
$list.="'".mysql_escape($p)."'";
}
else{
$list.=",'".mysql_escape($p)."'";
}
}

$list.=")";

This will produce a string that would look something like this for example:
('Administrative In-Basket Exercise','The Commissioner\'s Dilemma')

Once we have this, we can use it to do a search in the database. The getRecords would look something like this:

list($records,$metadata)=getRecords(array(
'tableName'=>'listings',
'allowSearch'=>false,
'where'=>"title IN ".$list,
));

Obviously you'd have to change names in order to make it match what you have in your database.

Give that a try and let me know if that does what you're looking for.

Jason: Not sure if I did this right as I am getting an error.

Fatal error: Call to undefined function: mysql_escape() in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 25

I have attached the script, as it might be easier to see it from there.

Hi,

You may have an old version of the database functions library. But it's okay, just replace the first bit of code I gave you with this:

$list="(";
foreach($prod as $p){
if($list=="("){
$list.="'".mysql_real_escape_string($p)."'";
}
else{
$list.=",'".mysql_real_escape_string($p)."'";
}

}

$list.=")";

Give that a try and let me know if it works for you.

Jason: looks like I may have to pass the db credentials?? (BTW, I am using v2.03)

I get the following error msgs:

Warning: mysql_real_escape_string(): Access denied for user 'apache'@'localhost' (using password: NO) in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 25

Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 25

Warning: mysql_real_escape_string(): Access denied for user 'apache'@'localhost' (using password: NO) in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 28

Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 28

Warning: mysql_real_escape_string(): Access denied for user 'apache'@'localhost' (using password: NO) in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 28

Warning: mysql_real_escape_string(): A link to the server could not be established in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 28

Fatal error: Call to undefined function: getrecords() in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 35

Hi,

Could you attach the file you're working with so I can take a closer look.

Thanks.

Jason: Made some changes to the file (see attached).

The errors I am now getting are:

Notice: Undefined variable: list in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 12
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY dragSortOrder DESC' at line 3

Jason: I made another change (see attached file) and get the foll error/output:

Notice: Undefined variable: description in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 23
Notice: Undefined variable: description in /var/www/vhosts/ipac.ca/httpdocs/casestudies/includes/success.php on line 24

Closing the Baldwin Hospital
Formulating a Provincial Budget, revised