Is there any point doing this?

yoki

Hey all,

I'm confused as to wheter I should save the following error message for later display or is this error only for sql syntax?

$query = "SELECT *
from $table
WHERE $column = '".mysql_real_escape_string($value)."'";
if( !( $res = mysql_query( $query ) ) ){
$error[2] = mysql_error();
return false;

I store the mysql_error returned value into an array called error. If my function returns false then the error message stored in the array is displayed. But I wonder if it's really useful.

I know that if my SQL syntax is wrong then it will return it but other than that, what are the possible return messages?

devinemke

function do_query($table, $column, $value)
{
	$result = mysql_query("SELECT * from $table WHERE $column = '" . mysql_real_escape_string($value) . "'");
	if (!$result) {$error[] = mysql_error();}
	return $result;
}

if there is an error [man]mysql_query[/man] will return boolean FALSE so the above function will either return a result set or FALSE. if it returns FALSE it will also throw the error message into the $error array.

jazz_snob

yoki wrote:
I know that if my SQL syntax is wrong then it will return it but other than that, what are the possible return messages?

IMHO, the messages are sometimes not very useful or incomplete 😕 . What do you hope to do based on the returned message?

Maybe this could help(?):
http://us2.php.net/manual/en/function.mysql-errno.php