PHP/MySQL warnings about results

[bruno_guedesav]

I've made a function to fetch all results as an array of result-
arrays. Getting the result arrays is easy, via mysql_fetch_arr ay, and
function itself is quite simple, as follows:

function db_query($db, $query)
{
$result = mysql_query($qu ery, $db);
$res_array = array();

if ($result) //it is a search
{
while($data = mysql_fetch_arr ay($result,MYSQ L_ASSOC))
array_push($res _array,$data);
}

return $res_array;
}

But there's a slight problem: when the query in question is an INSERT,
UPDATE or DELETE query, PHP will show me a warning saying:

Warning: mysql_fetch_arr ay(): supplied argument is not a valid MySQL
result resource in /home/grad/ccomp/06/guedesav/public_html/PbBlog/inc/
db.php on line 28
(line 28 is "while($dat a = mysql_fetch_arr ay($result,MYSQ L_ASSOC))")

and havingthis warning on the HTML output leads to be impossible to
use header() to, for instance, go back to the post removal page. Is
there any way to know prior to fetching if my result is of and INSERT/
UPDATE/DELETE instead of a SELECT query?

[Knut Krueger]

Jerry Stuckle schrieb:

In general, it's also a bad idea to have error_display enabled in a production system. It can show other things about your system when there are problems - things you don't necessarily want known (i.e. contents of SQL statements). But it's necessary for development.

yes it depends in my files on then content of $testmode TRUE/FALSE in a
config file and will be submitted with session variable or post forms
otherwise I am using the PHP default (think it is set to #40)

>But this error is included in the proof function from those selected
data before updating the data.

??? I don't understand this part.

But this error *handling* is included in the proof function from those
selected data before updating the data.

select -update
Knut

[Jerry Stuckle]

Knut Krueger wrote:

Jerry Stuckle schrieb:

>In general, it's also a bad idea to have error_display enabled in a
production system. It can show other things about your system when
there are problems - things you don't necessarily want known (i.e.
contents of SQL statements). But it's necessary for development.

yes it depends in my files on then content of $testmode TRUE/FALSE in a
config file and will be submitted with session variable or post forms
otherwise I am using the PHP default (think it is set to #40)

>>But this error is included in the proof function from those selected
data before updating the data.

??? I don't understand this part.

But this error *handling* is included in the proof function from those
selected data before updating the data.

select -update
Knut

But if the error occurs once every 10 years because a user incorrectly
deleted a required table with PhPMyAdmin, that's their problem. I'd let
the message go ahead and be displayed.

I don't try to protect against user stupidity like that.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===