Re: [PHP] mysql_fecth_array() and function call as parameter

2006-03-27 Thread Paul Goepfert
according to my SQL the month name ois going to be returned not the month number. m_id is the number equivlent to the month. months is the full name of the month. In my month method I did not change the case values to the month number and the function returns correctly. All I had to do was add t

RE: [PHP] mysql_fecth_array() and function call as parameter

2006-03-27 Thread Brady Mitchell
> -Original Message- > I finally got the function to work. However I have a problem with > another function. It is almost exactly like the origional function > but in this function I am determining the days instead of the month. > I made the same changes to the days function as I did to

Re: [PHP] mysql_fecth_array() and function call as parameter

2006-03-27 Thread Paul Goepfert
I finally got the function to work. However I have a problem with another function. It is almost exactly like the origional function but in this function I am determining the days instead of the month. I made the same changes to the days function as I did to the month function. However no value

RE: [PHP] mysql_fecth_array() and function call as parameter

2006-03-27 Thread Brady Mitchell
> I have done the following to my code hoping that the fix would work > > $query1 = mysql_query("SELECT months FROM Month WHERE m_id = month(curdate())"); > //echo $query1 . ""; > > $query1_data = mysql_fetch_assoc($query1); > echo $query1_data . ""; returns Array > (The word that

Re: [PHP] mysql_fecth_array() and function call as parameter

2006-03-27 Thread Paul Goepfert
I have done the following to my code hoping that the fix would work $query1 = mysql_query("SELECT months FROM Month WHERE m_id = month(curdate())"); //echo $query1 . ""; $query1_data = mysql_fetch_assoc($query1); echo $query1_data . ""; returns Array (The word that is) switch ($q

Re: [PHP] mysql_fecth_array() and function call as parameter

2006-03-26 Thread Chris
Paul Goepfert wrote: I placed the echo statements in my code and I found out that my query was empty. I also went a step further and tested if I was getting the correct outputs from the queries that initially do at the beginning of the method. Instead of getting an output like "March" I got an

Re: [PHP] mysql_fecth_array() and function call as parameter

2006-03-26 Thread Paul Goepfert
I placed the echo statements in my code and I found out that my query was empty. I also went a step further and tested if I was getting the correct outputs from the queries that initially do at the beginning of the method. Instead of getting an output like "March" I got an output that says "Resou

Re: [PHP] mysql_fecth_array() and function call as parameter

2006-03-26 Thread Chris
Paul Goepfert wrote: Hi all, I have wriiten a function that determines whether tomorrows date is the first of the month or not then returns a SQL string based on whether its the first of the month or not. According to my apache error logs I get an error that says: [Sun Mar 26 21:43:14 2006] [e