i'm having a problem with the below sql. basically, i'm pulling user information where customers_id = $id. i can go in phpmyadmin, mimic the sql, and it works. i can echo the $id and it's the correct id.
but it still won't pull the data.
suggestions on where i'm going wrong here?
thanks
code:
$customers_ID = $userinfo[uid];
//check to see if $customers_ID exists, it does and it matches what it should be to pull data
//echo $customers_ID;
$result1 = sql_query("select * from customers where customers_id = ".$customers_ID, $dbi);
$userinfo1 = sql_fetch_array($result1,$dbi);
//but it comes back saying no data pulled?