Hi everyone,
So I’m having issues trying to get two of my If, else statements to work.
So they take an input from an html submit form, and if there is an input the code works, but for this there needs to be all the values in the database returned if there is nothing submitted. It’s as if php doesn’t even recognize the if part and only runs the else part.
Any guidance is highly appreciated! Thanks 8)
here’s the code for the 1st:
[php]$lastName = $_POST[‘lastName’];
if ($lastName = “”) {
$query = "SELECT c., s.speaker_year FROM Contact c, Speakers s WHERE s.Contact_con_id = c.con_id ";
} Else {
$query = "SELECT c., s.speaker_year FROM Contact c, Speakers s WHERE s.Contact_con_id = c.con_id
AND con_lname = ";
}
$query = $query . “’” . $lastName . “’ ORDER BY con_lname;”;[/php]
here’s the 2nd one:
[php]$rgroups = $_POST[‘rgroups’];
if ($_Post[‘rgroups’] = “”) {
$query6 = "SELECT r.rev_groups_id, c.con_fname, c.con_lname, con_phone, rev_groups_pass, count(p.proposal_id)
FROM Review_Groups r JOIN Proposal p on r.rev_groups_id = p.Review_Groups_rev_groups_id
JOIN Presents px on px.Proposal_proposal_id = p.proposal_id
JOIN Contact c on px.Speakers_Contact_con_id = c.con_id
JOIN Reviewer rw on rw.Review_Groups_rev_groups_id = r.rev_groups_id
WHERE rw.reviewer_type = ‘local’
AND r.rev_groups_id = ";
$query6 = $query6 . “’” . $rgroups . “’ Group BY r.rev_groups_id;”;}
Else {
$query6 = "SELECT r.rev_groups_id, c.con_fname, c.con_lname, con_phone, rev_groups_pass, count(p.proposal_id)
FROM Review_Groups r JOIN Proposal p on r.rev_groups_id = p.Review_Groups_rev_groups_id
JOIN Presents px on px.Proposal_proposal_id = p.proposal_id
JOIN Contact c on px.Speakers_Contact_con_id = c.con_id
JOIN Reviewer rw on rw.Review_Groups_rev_groups_id = r.rev_groups_id
WHERE rw.reviewer_type = ‘local’
AND r.rev_groups_id = ";
$query6 = $query6 . “’” . $rgroups . "’ ";}
[/php]