Thread: Php4 to php5

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2012
    Posts
    5
    Rep Power
    0

    Php4 to php5


    Hello guys,

    I'm helping someone who has needed to go from Debian/php4 to Ubuntu/php5 on their webserver. Its a small business who had their page made some years back(like 10 maybe). Since their OS/php version has changed there are some PostgreSQL queries that don't seem to work anymore. I'm used to MySql so PostgreSQL is completely new to me. I've tried searching the interweb and didn't find much if anything.


    Here is the function that has the query in it.

    Code:
    function get_all_days_products($order_day, $order_month, $order_year)
    {
            $conn = connectEfesDB();
            if (!$conn){
                    noDBConn($conn);
                    exit;
            }
    
    	if($order_day < 10)
    		$order_day = "0$order_day";
    	if($order_month < 10)
    		$order_month = "0$order_month";
    
    	$query = "SELECT distinct P.product_id, product_code
    		FROM products as P, order_items as OI, orders as O
    		WHERE P.current_product='t'
    		and O.order_id = OI.order_id
    		and OI.product_id = P.product_id
    		and O.delivery_date like '$order_year-$order_month-$order_day%'
    		order by P.product_id";
    
            $products = pg_query($conn, $query);
            
    	if (!$products){
                    return;
            }
            for ($i=0; $i<pg_numrows($products); $i++){
                    $product_list[$i]["id"]   = pg_result($products, $i, 0);
                    $product_list[$i]["code"] = pg_result($products, $i, 1);
            }
            return $product_list;
    }
    Now all I know so far is it returns nothing. I don't have PostgreSQL on my personal webhost so I haven't been able to test around too much.
    Do you see anything in there that would stop working going from php4 to php5?

    Thanks so much any help..
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,777
    Rep Power
    348
    Shouldn't you post this in a PHP forum?

    If you have a specific SQL question, then please post SQL code, not PHP.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2012
    Posts
    5
    Rep Power
    0
    my apologies

IMN logo majestic logo threadwatch logo seochat tools logo