mysql/php error message?

[Geoff Cox]

Hello

I get the following error

"Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result resource in path/user-groups.php on line 25" (line 25 is the
one with a *)

with

@require(dirname(__FILE__) . '/../../config_php/config.php');

$query ="select * from users where " . "user_name " ."like" . "%" .
$_POST['username'] . "%";

$link = mysql_connect(
$conf['sql']['host'],
$conf['sql']['user'],
$conf['sql']['pass']
) or die ("cannot make connection to {$conf['sql']['db']}");

if (mysql_select_db($conf['sql']['db'],$link)) {

$result = mysql_query($query, $link);

while ($row = mysql_fetch_array($result)) { //*
echo $row['user_name'] . " " . $row['group1'] ."<br>";
}
}
why?!

is it because there is only 1 record for each user_name?

Cheers

Geoff

[Jerry Stuckle]

Geoff Cox wrote:

Hello

I get the following error

"Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result resource in path/user-groups.php on line 25" (line 25 is the
one with a *)

with

@require(dirname(__FILE__) . '/../../config_php/config.php');

$query ="select * from users where " . "user_name " ."like" . "%" .
$_POST['username'] . "%";

$link = mysql_connect(
$conf['sql']['host'],
$conf['sql']['user'],
$conf['sql']['pass']
) or die ("cannot make connection to {$conf['sql']['db']}");

if (mysql_select_db($conf['sql']['db'],$link)) {

$result = mysql_query($query, $link);

while ($row = mysql_fetch_array($result)) { //*
echo $row['user_name'] . " " . $row['group1'] ."<br>";
}
}
why?!

is it because there is only 1 record for each user_name?

Cheers

Geoff

No, it's because your mysql_query had an error.

ALWAYS check the results of ANY mysql call. In this case:

if (!$result)
echo mysql_error();

will show you your problem.

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

[Charles Polisher]

Geoff Cox <gc**@freeuk.notcomwrote:

Hello

I get the following error

"Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result resource in path/user-groups.php on line 25" (line 25 is the
one with a *)

with

@require(dirname(__FILE__) . '/../../config_php/config.php');

$query ="select * from users where " . "user_name " ."like" . "%" .
$_POST['username'] . "%";

$link = mysql_connect(
$conf['sql']['host'],
$conf['sql']['user'],
$conf['sql']['pass']
) or die ("cannot make connection to {$conf['sql']['db']}");

if (mysql_select_db($conf['sql']['db'],$link)) {

$result = mysql_query($query, $link);

while ($row = mysql_fetch_array($result)) { //*
echo $row['user_name'] . " " . $row['group1'] ."<br>";
}
}

Two observations: (1) like '%foo%' (the apostrophes are required).
You show: like%foo%
(2) Dangerous to use raw POST in a query, see:
http://php.net/function.mysql-real-escape-string

--
Charles

[Geoff Cox]

On Mon, 11 Aug 2008 19:37:38 -0400, Jerry Stuckle
<js*******@attglobal.netwrote:

>Geoff Cox wrote:

>Hello

I get the following error

"Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result resource in path/user-groups.php on line 25" (line 25 is the
one with a *)

with

@require(dirname(__FILE__) . '/../../config_php/config.php');

$query ="select * from users where " . "user_name " ."like" . "%" .
$_POST['username'] . "%";

$link = mysql_connect(
$conf['sql']['host'],
$conf['sql']['user'],
$conf['sql']['pass']
) or die ("cannot make connection to {$conf['sql']['db']}");

if (mysql_select_db($conf['sql']['db'],$link)) {

$result = mysql_query($query, $link);

while ($row = mysql_fetch_array($result)) { //*
echo $row['user_name'] . " " . $row['group1'] ."<br>";
}
}
why?!

is it because there is only 1 record for each user_name?

Cheers

Geoff

No, it's because your mysql_query had an error.

ALWAYS check the results of ANY mysql call. In this case:

if (!$result)
echo mysql_error();

will show you your problem.

it did indeed!

thanks Jerry.

Cheers

Geoff

[Geoff Cox]

On Mon, 11 Aug 2008 23:35:10 -0500, Charles Polisher
<cp*****@nonesuch.comwrote:

>Geoff Cox <gc**@freeuk.notcomwrote:

>Hello

I get the following error

"Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result resource in path/user-groups.php on line 25" (line 25 is the
one with a *)

with

@require(dirname(__FILE__) . '/../../config_php/config.php');

$query ="select * from users where " . "user_name " ."like" . "%" .
$_POST['username'] . "%";

$link = mysql_connect(
$conf['sql']['host'],
$conf['sql']['user'],
$conf['sql']['pass']
) or die ("cannot make connection to {$conf['sql']['db']}");

if (mysql_select_db($conf['sql']['db'],$link)) {

$result = mysql_query($query, $link);

while ($row = mysql_fetch_array($result)) { //*
echo $row['user_name'] . " " . $row['group1'] ."<br>";
}
}

Two observations: (1) like '%foo%' (the apostrophes are required).
You show: like%foo%
(2) Dangerous to use raw POST in a query, see:
http://php.net/function.mysql-real-escape-string

thanks for both ideas - is working now!

Cheers

Geoff