Query is Empt In PHP but Works in MySQL

[JustJay]

OK so I created this query to be run each time "the page" is loaded...

// SET PIK Details 
mysql_select_db($database_tvconnect, $tvconnect); 
$query_PIKDETAILS = "UPDATE Flights SET PIKDETAILS = CONCAT(DepartingCity,' to ',Destination,' on ',DepartureDate,' returning/duration = ',ReturnDuration,' priced from $',PricedFrom)"; 
$PIKDETAILS = mysql_query($query_PIKDETAILS, $tvconnect) or die(mysql_error());

And it works like a charm....however...when I went to do the bilingual side....with this query...

// Set Details de PIK en français 
mysql_select_db($database_tvconnect, $tvconnect); 
$query_DetailPIK = "UPDATE Flights SET DetailPik = CONCAT('À partir de ',VilleDepart, ' à ',DestinationFR,' retour ou durée = ',RetourDuree,' à partir de ',PricedFrom,'$')"; 
$DetailPik = mysql_query($query_DetailPik, $tvconnect) or die(mysql_error());

"The page" will not load and mysql_error = Query was empty.

However if I run that exact query in MySQL - it works exactly as it should...

So my question is --- am I missing something? Are the accented characters screwing things up? Am I missing something or a character that I need to escape?

😕

Thanks,

[swr]

In PHP variable names are case-sensitive. When you
set $query_DetailPIK the last two letters are
uppercase, but when you use it it's $query_DetailPik
with the last two letters lowercase. two different
variables as far as PHP is concerned.

I usually use all-lowercase variable names, to avoid
such mistakes.

[JustJay]

cheers thanks....my eyes were VERY tired last night....missed that completely....

I realise the benefits of lower case...yet sometimes i find it hard to read them....using CAPs sometimes breaks them up for me...