Posted by sixstringsin on 01/14/08 19:15

On Jan 14, 11:31 pm, Michael Fesser <neti...@gmx.de> wrote:
> .oO(sixstring...@yahoo.co.in)
>
>
>
> >##in the mysql query below, i am selecting a few fields from the masks
> >table:-
>
> >$mask_query = "SELECT mask_id, mask_name, mask_dynamic FROM masks
> >where mask_project = $project_id AND mask_parent = $phase_id";
>
> >##next i am storing the return value to a variable (on executing the
> >script, I donot get any mysql error so i assume the query ran fine:-
>
> >$mask_res = mysql_query($mask_query) or die("can't run query
> >[$mask_query]: ".mysql_error());
>
> >##now i intend to print the field called mask_name on the browser:-
>
> > $tc_array = mysql_fetch_array($mask_res, MYSQL_ASSOC);
> > $tc_name = $tc_array["mask_name"];
> > print "mask Name:".$tc_array['mask_name'] . " ";
>
> >##However, what is printed is the string mask Name, followed by a
> >blank. The mask_name field from the db is ##not retrieved. Where am i
> >going wrong? Appreciate any help!
>
> Make sure that error_reporting is set to E_ALL|E_STRICT in your php.ini
> and display_errors is enabled. Do you get any notices when you run the
> code? Does the query actually return anything? What does a
>
> var_dump($tc_array);
>
> show?
>
> Micha

thanks a lot for the help. Indeed var_dump($tc_array)
prints:bool(false). So is it that the mysql query is going wrong?

[Back to original message]