Could you tell me what wrong with my code to join 2 table.
$query ="select customer.first_name, customer.last_name, order.description, order.quantity, order.purchase_date from customer, order where customer.customer_id=order.customer_id";
$result=mysql_query($query, $connect);
$query ="select customer.first_name, customer.last_name, order.description, order.quantity, order.purchase_date from customer, order where customer.customer_id=order.customer_id";
$result=mysql_query($query, $connect);
Comment