paolorossi07 Posted April 3, 2007 Share Posted April 3, 2007 I currently have the following table within my database, LOGIN Login Password Inspector ID When logged in i need it to perform the following query SELECT Customer.Customer Name Customer.Customer Address Customer.Customer Postcode Customer.Customer Contact Tele Number Customer.Customer E-Mail Inspection Request.Inspection Address Inspection Request.Inspection Stage Inspection Request.Inspection Date Requested Inspection Request.Area Name FROM CUSTOMER,Inspection Request WHERE CUSTOMER.CUSTOMER ID=Inspection Request.CUSTOMER ID AND Inspection Request.Inspector ID = [investor id of login investor] Does anyone know the PHP code required and will it be compicated if not? Quote Link to comment https://forums.phpfreaks.com/topic/45398-loginquery/ Share on other sites More sharing options...
monk.e.boy Posted April 3, 2007 Share Posted April 3, 2007 google for php mysql_query php mysql_fetch_array these will give you about 1,000,000 tutorials and examples. monk.e.boy Quote Link to comment https://forums.phpfreaks.com/topic/45398-loginquery/#findComment-220421 Share on other sites More sharing options...
Daniel0 Posted April 3, 2007 Share Posted April 3, 2007 Use mysql_query(). Quote Link to comment https://forums.phpfreaks.com/topic/45398-loginquery/#findComment-220429 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.