PHP / MySQL Recordset MM_Error DWMX 6.1 Mac 10.3.4 accessing a Unix server

I've got this weird error ... When I try to access a recordset I added called "rs_pref", I get an "MM_Error". The weird thing is that on another page in another folder I set up the exact same recordset called "rs_pref" and the data comes up fine. So these are the steps to my error:

  • 1. Create a new php page.

  • 2. Add connection to database by connecting to the file in the "Connections" folder

  • 3. Go to "Bindings" panel and select "Recordset Query"

  • 4. In pop up window, name recordset "rs_pref", connect to database, choose table, set filters and sort, click "ok".

  • 5. "rs_pref" recordset appears in bindings panel with "MM_Error" apearing instead of data.

I once had a similar problem where I couldn't connect to the database, but everything seems to be connecting fine. Anybody got any ideas? Here's my code below if you want to take a look at it ...

<?php require_once('../../../../Connections/pdb_conn.php'); ?>
<?php
mysql_select_db($database_pdb_conn, $pdb_conn);
$query_rs_pref = "SELECT * FROM pdb_pref";
$rs_pref = mysql_query($query_rs_pref, $pdb_conn) or die(mysql_error());
$row_rs_pref = mysql_fetch_assoc($rs_pref);
$totalRows_rs_pref = mysql_num_rows($rs_pref);
?>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<body topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">
aaa
</body>
</html>
<?php
mysql_free_result($rs_pref);
?>

    I'm not sure if this applies here, because I don't know how you're trying to display the data. If you're just displaying it as variables ($name) then you will need to use the [man]extract[/man] function first.

    Also, I remember reading somewhere that the MM_error can occur if your database name has spaces or something funky in there.

    Does that help?
    Elizabeth

      Write a Reply...