Hi I need some help with this..

I have tables in sql with the following values;

Tbl name - members
memberid - primary key

Tbl name -Orders

Orderid -primary key
memberid - foreign key

I want to be able to grab the order numbers by the specific member.

I have two members in the sql database.
I have two orders in the sql database.

Here is my sql i used to create the tables -
members -

CREATE TABLE `members` (
  `memberid` int(4) NOT NULL auto_increment,
  `Username` varchar(65) collate latin1_general_ci NOT NULL,
  `Password` varchar(65) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`memberid`)

-- Dumping data for table `members`

INSERT INTO `members` VALUES(1000, 'qprping', '1234');
INSERT INTO `members` VALUES(1001, 'xrated', 'password');


  `Orderid` int(11) NOT NULL,
  `Orderno` int(11) NOT NULL,
  `memberid` int(11) default NULL,
  PRIMARY KEY  (`Orderid`),
  KEY `memberid` (`memberid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- Dumping data for table `Orders`

INSERT INTO `Orders` VALUES(1010, 5892584, 1000);
INSERT INTO `Orders` VALUES(1011, 1234567, 1001);

How do I do this using php?

I have not understood your question but I think you might need to check table joining, especially inner join. May be explaining what you want to accomplish might help!

If you look in the members sql the memberid is related to a specific order in the orders table

so I want to get that specific order number by the member id

would you put sample data on table and ask your question based on minimal data? I have not catch well your question!