04-13-2011, 05:35 AM
[eluser]The Casual Bot[/eluser]
so im moved my site from a wamp setup to my newly build LAMP using ubuntu
apache2 and php5.3.3
but on my dashboard it displays 24 hour orders but i notice that there was a diffrence in the result on each server
on my wamp i had some
on my lamp i had none
but i did have any errors either and there both looking at the same DB
my code looks likes this
and it returns nothing
however if i do this
so by puting the results in an array it starts to work again
note tho: $test does appear anywhere else in the doc just there and i can changes its name to anything and it still works
the db is mssql and im connecting via ODBC useing the freetds driver and unixodbc any clue to whats going on
so im moved my site from a wamp setup to my newly build LAMP using ubuntu
apache2 and php5.3.3
but on my dashboard it displays 24 hour orders but i notice that there was a diffrence in the result on each server
on my wamp i had some
on my lamp i had none
but i did have any errors either and there both looking at the same DB
my code looks likes this
Code:
$DIMENSIONS = $this->load->database('DIMENSIONS', TRUE);
$sql = 'select oh_account, oh_order_number from ord_header where OH_URGENT_FLAG = 1 and oh_status <1';
$query = $DIMENSIONS->query($sql);
//then some code below to just print this out
and it returns nothing
however if i do this
Code:
$DIMENSIONS = $this->load->database('DIMENSIONS', TRUE);
$sql = 'select oh_account, oh_order_number from ord_header where OH_URGENT_FLAG = 1 and oh_status <1';
$query = $DIMENSIONS->query($sql);
$test = $query->result_array();
//the code below has'nt changed but now it works
so by puting the results in an array it starts to work again
note tho: $test does appear anywhere else in the doc just there and i can changes its name to anything and it still works
the db is mssql and im connecting via ODBC useing the freetds driver and unixodbc any clue to whats going on