is there any idea i can connect two tables in this query


define('DB_SERVER', 'localhost');
define('DB_PORT', '3306');
define('DB_USERNAME', '-----');
define('DB_PASSWORD', '-----');
define('DB_NAME', 'selling');
define('TABLE_PREFIX', 'ioline _');
define('DB_USERTABLE', 'sales'); (i want to connect another table to sales called buy)

use join or inner join.

table 1 - sales
fields : saleid, product, amount

table 2 - order;
orderid, saleid, timeoforder

assuming saleid is the same in both tables, you can say something like:

select sales.product,sales.amount, order.orderid from sales,order where sales.saleid=order.orderid and order.orderid= 5; //simplemente eh?

its more like the config file being used to connect to database

define('DB_SERVER', 'localhost');
define('DB_PORT', '3306');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', 'xxxxxxx');
define('DB_NAME', 'market');
define('TABLE_PREFIX', 'cath_');
define('DB_USERTABLE', 'member'); want to join these with guest
define('DB_USERTABLE_NAME', 'name');

ok now i have another table called guest how do i go about it

Lemme explain the kinda stuff you are asking to you.

There are so many ways of joining tables together:
Inner joins, outer joins, left outer join. . . , . . cartesian join.

The type of join you use depends on what you are looking for.

actually the script given is used to connect to database with one user table i want to connect to the same database with the with two user table using the given the code below

define('DB_SERVER', 'localhost');
define('DB_PORT', '3306');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', 'xxxxxxx');
define('DB_NAME', 'market');
define('TABLE_PREFIX', 'cath_');
define('DB_USERTABLE', 'member'); want to join these with guest
define('DB_USERTABLE_NAME', 'name');

Your questions are not clear. Sorry, that is all the help i can give - based on your question. Lookup joining mysql tables on google