code not working!!

siwy

this used to work but now it doesn't. $miesiac returns no data from db any ideas why?
please i need this to work.

mysql_select_db($database_rscontacts, $rscontacts);
$query_Recordset5 = "SELECT last_name, first_name, '$miesiac' FROM february WHERE '$miesiac' <> 'sorry' ORDER BY last_name ASC";
$Recordset5 = mysql_query($query_Recordset5, $rscontacts) or die(mysql_error());
$row_Recordset5 = mysql_fetch_assoc($Recordset5);
$totalRows_Recordset5 = mysql_num_rows($Recordset5);

ahundiak

Possiby because $miesiac is not set perhaps because of register_globals being off.

Echo out $miesiac.
Check for errors after the query and echo out mysql_error() if one is generated.

siwy

i did echoed $miesiac and it's fine, it's egzactly what it's suposed to be but it's not returning anything from db.

xblue

if that variable is a column name, you should remove the singlequotes, I think. else mysql would take it for a string.

also, give ahundiak's suggestion with mysql_error a try, this is often very helpful.

siwy

no, if i remove the single quotes then it gives me a syntax error. i tryed to echo the mysql_error but it returns nothing. it's driving me mad.

siwy

this is really driving me nuts. when i removed the single quotes it gives me a syntax error but just now i was in another web browser where it wouldn't work either then i went back to IE and it worked perfectly until i quit and restart again then i'm back to syntax error. HELP

xblue

could you post the error (the mysql syntax error returned by mysql_error()) together with the query? if you get different errors with different queries, post them too.

btw, since php is completely serverside, it shouldn't have to do with the browser you use.

siwy

well, here is the error message:
You have an error in your SQL syntax near 'FROM february WHERE <> 'sorry' ORDER BY last_name ASC' at line 1
with query:

mysql_select_db($database_rscontacts, $rscontacts);
$query_Recordset5 = "SELECT last_name, first_name, $miesiac FROM february WHERE $miesiac <> 'sorry' ORDER BY last_name ASC";
$Recordset5 = mysql_query($query_Recordset5, $rscontacts) or die(mysql_error());
$row_Recordset5 = mysql_fetch_assoc($Recordset5);
$totalRows_Recordset5 = mysql_num_rows($Recordset5);

but sometimes it works without changing anything, it just works and then i get the above error message again.

when i put '$miesiac' instead of $miesiac it just returns the value of $miesiac not the db column.

gregor63

Just try miesiac instead of $miesiac :-)

Gregor63

gregor63

of course miesiac before FROM
and '$miesiac' after FROM

Gregor63

siwy

that won't work since $miesiac changes all the time and miesiac is not a column name the variable $miesiac is.

gregor63

I think - after WHERE You should add :
WHERE miesiac='$miesiac' and '$miesiac' <>'sorry'

Gregor63

siwy

nope, that only returns error: Unknown column 'miesiac' in 'where clause'

gregor63

Maybe creating table you use English name month instead of Polish miesiac?
So, the name of the column is unknown.

Gregor63

-Rich87Tx2

Try 'echo $query'. Make sure the output for $query string appears how you think it should, prior to actually making the query.

If it appears how you think it should, try something like this:

$query_Recordset5 = "SELECT last_name.'$miesiac', first_name.'$miesiac' FROM february WHERE '$miesiac' <> 'sorry' ORDER BY last_name ASC";

echo $query

I might have the variables reversed or quotes misplaced...
It might need to be "SELECT '$miesiac'.last_name"
OR "SELECT last_name.$miesiac
-Rich

siwy

i formulated the query like this now and it works except it selects the rows with 'sorry' in them as well.

mysql_select_db($database_rscontacts, $rscontacts);
$query_Recordset5 = "SELECT * FROM february WHERE '$miesiac' <> 'sorry' ORDER BY last_name ASC";
$Recordset5 = mysql_query($query_Recordset5, $rscontacts) or die(mysql_error());
$row_Recordset5 = mysql_fetch_assoc($Recordset5);
$totalRows_Recordset5 = mysql_num_rows($Recordset5);

gregor63

I suppose you create the table using the name of the column : month so you should use:
$query_Recordset5 = "SELECT last_name, first_name, month FROM february WHERE month='$miesiac' and '$miesiac'<> 'sorry' ORDER BY last_name ASC";

Gregor63

siwy

no, no you see column names are like 02_01_2003, 02_02_2003, 02_03_2003 and so on. Depends on what you'll choose from a pull down menu the $miesiac gets its value and fetches the corresponding record from a db. it seems that the first $miesiac in front of the WHERE clause is causing all the problems.

rrijnders

Take the single quotes off of $miesiac

siwy

no can do, if i take them off i get syntax error.