mysql_fetch_array()

[mohamed42]

I give in to Vincent on this one. Sometimes I can make it work and sometimes I can't. Take this code for example:
if($s_pre)
{
$query = "select s_id from tbl_skill where s_name like \"$s_pre\"";
$pre_id = mysql_query($query);
* $pre_id = mysql_fetch_array($pre_id);
$pre_id = $pre_id["s_id"];
echo $pre_id;
}

This is causing the following error:
Warning: Supplied resource is not a valid mSQL result resource in /www/verlynia/school/skillpost.php on line 23

The problem I'm having is that sometimes this will cause an error and sometimes it won't. What am I doing wrong? I don't know if this makes a difference, but the query here should only ever return one line. Never more than one.

[rleonen]

Have you tried using single quotes around the $s_pre variable in the $query string? I don't use double quotes and mysql_fetch_array seems to work ok. Also, when the query does work, does it return any results (or does it just run without any error messages)? Try this instead;

$query = "select s_id from tbl_skill where s_name like '$s_pre'";

Also, you might want to include wild cards around your $s_pre variable like this '%$s_pre%'.

Hope this helps.

[Anon]

You probably shouldn't override your query result identifier before spitting the results out. Try changing the name of what you assign mysql_fetch_array to.

if($s_pre)
{
$query = "select s_id from tbl_skill where s_name like '$s_pre'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$pre_id = $row["s_id"];
echo $pre_id;
}

[mohamed42]

Ok, thanks. I tried that and it worked.