[Resolved] Error PHP script itself fails - need help

[ppowell]

query_error.php:

<?

$msg = 'Could not produce proper results';
if (preg_match('/\/development\//i', $devpath)) $msg .= ': ' . mysql_error();

?>
<script>
<!--
  location.href = '<?= $devpath ?>error.php?msg=<?= urlencode($msg) ?>';
//-->
</script>
<meta http-equiv='Refresh' content='1;URL=<?= $devpath ?>error.php?msg=<?= urlencode($msg) ?>'>

This script is called by other scripts this way:

		$result = mysql_query($this->query, $this->dbcnx) or die(include("$DOCUMENT_ROOT${devpath}errors/query_error.php?msg=" . urlencode(mysql_error())));

However, upon attempt to do so the following warning is thrown instead and everything just dies:

Warning: Failed opening '/errors/query_error.php?msg=Can%27t+find+FULLTEXT+index+matching+the+column+list' for inclusion (include_path='.:/usr/share/pear') in /libdev/db.inc on line 115

Very Very simple requirement: Show Friendly mysql_error() message and can't do it 🙁

Please help, I'm stuck

Thanx
Phil

[bubblenut]

The problem lies with your understanding of what [man]include[/man] actually does. It does not open a url, it simply includes a file directly into the script as though the code were there. In order to have data available within the included file you simply set that data to variables and then use those variables. So, in the case of your code one could do something like this.

$result = mysql_query($this->query, $this->dbcnx) or die(include($DOCUMENT_ROOT.$devpath.'errors/query_error.php'));

I notice that in your query_error.php script you overwrite the $err variable before you do anything with it anyway. You also use mysql_error() which, if include had worked as you expected, would not work because you would not be using the same database connection.

HTH
Bubble

[ppowell]

Oh good grief it was that simple. I have no idea what possessed me to put a query string into an include knowing that include() would just interpret the query string as part of the file name.

Thanx
Phil