Jump to content

Need help with two issues


radiations3

Recommended Posts

Issue # 1

How can i send the values come from $_POST['name'],$_POST['number'] to an email address [email protected]???

 

Issue # 2

I am trying to display data from four different tables with the following sql query:

(The problem is that the data is getting displayed fine but i don't know why some of the (same )data gets repeated two or three times where as i checked in all four tables and all the data exists one time not twice)

If anything wrong with my query kindly help

 

SELECT distinct *

FROM applicant,applicant_info_nic,room,student

WHERE applicant_info_nic.status='Available' and  applicant.appNIC=applicant_info_nic.appNIC and applicant.roomID=room.roomID and applicant.appNIC=student.appNIC

ORDER BY applicant.roomID

Link to comment
https://forums.phpfreaks.com/topic/249199-need-help-with-two-issues/
Share on other sites

Not sure if this would work with *.  You might need to add all table fields instead, i.e status, roomID etc.

SELECT distinct(appNIC),*
FROM applicant,applicant_info_nic,room,student
WHERE applicant_info_nic.status='Available' and  applicant.appNIC=applicant_info_nic.appNIC and applicant.roomID=room.roomID and applicant.appNIC=student.appNIC
ORDER BY applicant.roomID

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.