Hello -
Please help! I'm creating search pages using Dreamweaver 8, PHP, and MySQL database with Mac OS X. I think my code is good, but when I run my query, I come up with no data, even though I know there is data in the database that should be coming up.
I'm searching two tables that are linked with a foreign key (member_id). The members table is the main table (where "member_id" is an auto increment key) , and the specialty_groups table uses "member_id" to reference which member has what specialty.
I've created a LEFT JOIN with USING (member_id). I've tried modifying the code by hand several times, and still come up with "no data."
My code (as created by Dreamweaver 8) is below:
<?php
$varspecialty_rsmembersearchresultsm = "%";
if (isset($_POST['mbrsearchspecialty'])) {
$varspecialty_rsmembersearchresultsm = $_POST['mbrsearchspecialty'];
}
$varfirstname_rsmembersearchresultsm = "%";
if (isset($_POST['mbrsearchfname'])) {
$varfirstname_rsmembersearchresultsm = $_POST['mbrsearchfname'];
}
$varmbrlname_rsmembersearchresultsm = "%";
if (isset($_POST['mbrsearchlname'])) {
$varmbrlname_rsmembersearchresultsm = $_POST['mbrsearchlname'];
}
$varmbrfirm_rsmembersearchresultsm = "%";
if (isset($_POST['mbrsearchfirm'])) {
$varmbrfirm_rsmembersearchresultsm = $_POST['mbrsearchfirm'];
}
$varmedia_rsmembersearchresultsm = "%";
if (isset($_POST['mbrsearchmedia'])) {
$varmedia_rsmembersearchresultsm = $_POST['mbrsearchmedia'];
}
$varfirstname_rsmembersearchresultsm = "%";
if (isset($_POST['mbrsearchfname'])) {
$varfirstname_rsmembersearchresultsm = (get_magic_quotes_gpc()) ? $_POST['mbrsearchfname'] : addslashes($_POST['mbrsearchfname']);
}
$varmbrlname_rsmembersearchresultsm = "%";
if (isset($_POST['mbrsearchlname'])) {
$varmbrlname_rsmembersearchresultsm = (get_magic_quotes_gpc()) ? $_POST['mbrsearchlname'] : addslashes($_POST['mbrsearchlname']);
}
$varmbrfirm_rsmembersearchresultsm = "%";
if (isset($_POST['mbrsearchfirm'])) {
$varmbrfirm_rsmembersearchresultsm = (get_magic_quotes_gpc()) ? $_POST['mbrsearchfirm'] : addslashes($_POST['mbrsearchfirm']);
}
$varmedia_rsmembersearchresultsm = "%";
if (isset($_POST['mbrsearchmedia'])) {
$varmedia_rsmembersearchresultsm = (get_magic_quotes_gpc()) ? $_POST['mbrsearchmedia'] : addslashes($_POST['mbrsearchmedia']);
}
$varspecialty_rsmembersearchresultsm = "%";
if (isset($_POST['mbrsearchspecialty'])) {
$varspecialty_rsmembersearchresultsm = (get_magic_quotes_gpc()) ? $_POST['mbrsearchspecialty'] : addslashes($_POST['mbrsearchspecialty']);
}
mysql_select_db($database_connection, $connection);
$query_rsmembersearchresultsm = sprintf("SELECT member.member_id, member.firstname, member.lastname, member.businessname, specialty_group.member_id FROM member LEFT JOIN specialty_group USING (member_id) WHERE member.firstname LIKE '%%%s%%' AND member.lastname LIKE '%%%s%%' AND member.businessname LIKE '%%%s%%' AND member.media_contact = '%s' AND specialty_group.specialty = '%s'", $varfirstname_rsmembersearchresultsm,$varmbrlname_rsmembersearchresultsm,$varmbrfirm_rsmembersearchresultsm,$varmedia_rsmembersearchresultsm,$varspecialty_rsmembersearchresultsm);
$rsmembersearchresultsm = mysql_query($query_rsmembersearchresultsm, $connection) or die(mysql_error());
$row_rsmembersearchresultsm = mysql_fetch_assoc($rsmembersearchresultsm);
$totalRows_rsmembersearchresultsm = mysql_num_rows($rsmembersearchresultsm);
?>
Thank you in advance for taking the time to help.
Best,
Charity
