PHP - Inner Join Search Help

Hello,

I'm developing a website that asks the user to submit a keyword for a search. The results should display matches for this keyword, but also show matches for related keywords (in order of relevenace!).

I'm planning on building up a library of which search terms users use in the same sessions (e.g. if someone searches for "it jobs" and "php jobs", I'll know the terms are correlated), and I'll also measure the click-through rates of the items on the results list.

I've been spending all weekend trying to map out the design for this but it's proving incredibly complicated and I think the solution is likely to be on the internet somewhere already?!

Please could someone point me in the right direction if you've come accross this problem before?

Thanks a million,

Stu

Friends,

I want to extract the Search Keyword from the URL, a visitor came from. I am using a PHP CMS and want to show the Keyword on my Blog.

So if they search "abcd" from google, i want to extract "abcd" and echo on my blog.

Here is the coding i could got hold of, but its not working, not echoing anything

<?php

function pk_stt2_function_get_delimiter($ref) {
    $search_engines = array('google.com' => 'q',
'go.google.com' => 'q',
'images.google.com' => 'q',
'video.google.com' => 'q',
'news.google.com' => 'q',
'blogsearch.google.com' => 'q',
'maps.google.com' => 'q',
'local.google.com' => 'q',
'search.yahoo.com' => 'p',
'search.msn.com' => 'q',
'bing.com' => 'q',
'msxml.excite.com' => 'qkw',
'search.lycos.com' => 'query',
'alltheweb.com' => 'q',
'search.aol.com' => 'query',
'search.iwon.com' => 'searchfor',
'ask.com' => 'q',
'ask.co.uk' => 'ask',
'search.cometsystems.com' => 'qry',
'hotbot.com' => 'query',
'overture.com' => 'Keywords',
'metacrawler.com' => 'qkw',
'search.netscape.com' => 'query',
'looksmart.com' => 'key',
'dpxml.webcrawler.com' => 'qkw',
'search.earthlink.net' => 'q',
'search.viewpoint.com' => 'k',
'mamma.com' => 'query');
    $delim = false;
    if (isset($search_engines[$ref])) {
        $delim = $search_engines[$ref];
    } else {
        if (strpos('ref:'.$ref,'google'))
            $delim = "q";
elseif (strpos('ref:'.$ref,'search.atomz.'))
            $delim = "sp-q";
elseif (strpos('ref:'.$ref,'search.msn.'))
            $delim = "q";
elseif (strpos('ref:'.$ref,'search.yahoo.'))
            $delim = "p";
        elseif (preg_match('/home\.bellsouth\.net\/s\/s\.dll/i', $ref))
            $delim = "bellsouth";
    }
    return $delim;
}

/**
 * retrieve the search terms from search engine query
 * */ 
function pk_stt2_function_get_terms($d) {
    $terms       = null;
    $query_array = array();
    $query_terms = null;
    $query = explode($d.'=', $_SERVER['HTTP_REFERER']);
    $query = explode('&', $query[1]);
    $query = urldecode($query[0]);
    $query = str_replace("'", '', $query);
    $query = str_replace('"', '', $query);
    $query_array = preg_split('/[\s,\+\.]+/',$query);
    $query_terms = implode(' ', $query_array);
    $terms = htmlspecialchars(urldecode(trim($query_terms)));
    return $terms;
}

/**
 * get the referer
 * */ 
function pk_stt2_function_get_referer() {
    if (!isset($_SERVER['HTTP_REFERER']) || ($_SERVER['HTTP_REFERER'] == '')) return false;
    $referer_info = parse_url($_SERVER['HTTP_REFERER']);
    $referer = $referer_info['host'];
    if(substr($referer, 0, 4) == 'www.')
        $referer = substr($referer, 4);
    return $referer;
}



$referer = pk_stt2_function_get_referer();
if (!$referer) return false;
$delimiter = pk_stt2_function_get_delimiter($referer);
if( $delimiter ){
$term = pk_stt2_function_get_terms($delimiter);
}
echo $term;
?>


May someone help?

Natasha T

Hello. I am working on a php script for searching a database table. I am really new to this, so I used the this tutorial http://www.phpfreaks.com/tutorial/simple-sql-search

I managed to get all the things working the way I wanted, except one important and crucial thing.
Let me explain.
My table consist of three columns, like this:

ID(bigint20)    title(text)        link (varchar255)
=============================
ID1                title1                link-1
ID2                title2                link-2
etc...

Like I said, I managed to make the script display results for a search query based on the title. Want I want it to do more, but I can't seem to find the right resource to learn how, is to place a "Download" button under each search result with its corresponding link from the table.

Here is the code I used.

<?php

$dbHost = 'localhost'; // localhost will be used in most cases
// set these to your mysql database username and password.
$dbUser = 'user'; 
$dbPass = 'pass';
$dbDatabase = 'db'; // the database you put the table into.
$con = mysql_connect($dbHost, $dbUser, $dbPass) or trigger_error("Failed to connect to MySQL Server. Error: " . mysql_error());

mysql_select_db($dbDatabase) or trigger_error("Failed to connect to database {$dbDatabase}. Error: " . mysql_error());
// Set up our error check and result check array
$error = array();
$results = array();
// First check if a form was submitted. 
// Since this is a search we will use $_GET
if (isset($_GET['search'])) {
   $searchTerms = trim($_GET['search']);
   $searchTerms = strip_tags($searchTerms); // remove any html/javascript.
   
   if (strlen($searchTerms) < 3) {
      $error[] = "Search terms must be longer than 3 characters.";
   }else {
      $searchTermDB = mysql_real_escape_string($searchTerms); // prevent sql injection.
   }
   
   // If there are no errors, lets get the search going.
   if (count($error) < 1) {
      $searchSQL = "SELECT title, link FROM db WHERE title LIKE '%{$searchTermDB}%'";

      $searchResult = mysql_query($searchSQL) or trigger_error("There was an error.<br/>" . mysql_error() . "<br />SQL Was: {$searchSQL}");
      
      if (mysql_num_rows($searchResult) < 1) {
         $error[] = "The search term provided {$searchTerms} yielded no results.";
      }else {
         $results = array(); // the result array
         $i = 1;
         while ($row = mysql_fetch_assoc($searchResult)) {
            $results[] = "{$row['title']}<br /> Download - this is the button I want to link to the title results - and maybe other links too - <br /> ";

    $i++;

       

   
         }
      
      }
   }
}

function removeEmpty($var) {
   return (!empty($var)); 


}
?>

      <?php echo (count($error) > 0)?"The following had errors:<br /><span id=\"error\">" . implode("<br />", $error) . "</span><br /><br />":""; ?>
      <form method="GET" action="search?" name="searchForm">
         Search for title: <input type="text" name="search" value="<?php echo isset($searchTerms)?htmlspecialchars($searchTerms):''; ?>" />
        
         <input type="submit" name="submit" value="Search" />
      </form>

    <?php echo (count($results) > 0)?"Rezultate lucrari de licenta sau disertatie pentru {$searchTerms} :<br /><br />" . implode("", $results):""; ?>




 $results = array(); // the result array
         $i = 1;
         while ($row = mysql_fetch_assoc($searchResult)) {
            $results[] = "{$row['title']}<br /> Download - this is the button I want to link to the title results - and maybe other links too - <br /> ";

    $i++;

 
I would like the results to be displayed like this

Results for SearchItem:

Result 1
Download | Other link
Result 2
Download | Other link
etc.... or something like this.

So, how do I add the data from the link row into a text(Dowload), within an <a href> tag (well, at least I guess it would go this way) ?
My first tries (fueled by my lack of knowledge) where things like

$results[] = "{$row['title']}<br /> <a href="{$row['link']}">Download</a> <br /> ";

but I keep getting lots of errors, and then I don't know much about arrays and stuff (except basic notions);
So there it is. I am really stuck and can't seem to find any workaround for this.
Any suggestions? (examples, documentation, anything would do, really)
Thanks,
Radu

I have code to search a database of members, I can search by lastname but having a little problem. I want to be able to search by lastname starting with the first letter. (ie:  a or b or c or d and so on). As it is right now I can only search by first letter of last name if I add % to the search (ie: a% b% c%) will give me all members with the last names starting with the approiate letter designation. I'm not sure how to handle this, any help would be appreciated. Thanks.
Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
 
</head>
<body>
<center><table cellspacing="10" cellpadding="10" width="750" border="0">
<h4>Search</h4>
 
<form name="search" method="post" action="<?php $PHP_SELF?>">
Seach for: <input type="text" name="find" /> in <Select NAME="field">

<Option VALUE="lname">Last Name</option>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form>
 
<?php 
 
// check to see if anything is posted
if (isset($_POST['find'])) {$find = $_POST['find'];}
if (isset($_POST['searching'])) {$searching = $_POST['searching'];}
if (isset($_POST['field'])) {$field = $_POST['field'];}
 
//This is only displayed if they have submitted the form 
if (isset($searching) && $searching=="yes") {
echo "<h4>Results</h4><p>";
// If they did not enter a search term we give them an error
if (empty($find)) {
echo "<p>You forgot to enter a search term"; exit;
}
 
// Otherwise we connect to our Database 
mysql_connect("localhost", "root", "1910") or die(mysql_error());
mysql_select_db("cmc_member") or die(mysql_error());
 
// We preform a bit of filtering 
$find = strtoupper($find);
$find = strip_tags($find); $find = trim ($find); 
 
// Now we search for our search term, in the field the user specified 
$results = mysql_query("SELECT * FROM members WHERE upper($field) LIKE'$find'");
 
// And we display the results 
if($results && mysql_num_rows($results) > 0)
{
    $i = 0;
    $max_columns = 3;
    while($row = mysql_fetch_array($results))
   {
       // make the variables easy to deal with
       extract($row);

       // open row if counter is zero
       if($i == 0)
          echo "<tr>";

       // make sure we have a valid product ALIGN='CENTER'

       if($fname != "" && $fname != null)
          echo "<td ALIGN='CENTER'><FONT COLOR='red'><b>$fname $lname</b></FONT><br> $address <br> $city $state $zip <br>$phone<br><a href=\"mailto: $email\">$email</a><br></td>";

       // increment counter - if counter = max columns, reset counter and close row
       if(++$i == $max_columns)
       {
           echo "</tr>";
           $i=0;
           }  // end if
   } // end while

} // end if results

// clean up table - makes your code valid!
if($i < $max_columns)
{
    for($j=$i; $j<$max_columns;$j++)
        echo "<td>&nbsp;</td>";

}

//This counts the number or results - and if there wasn't any it gives them a little message explaining that 
$anymatches = mysql_num_rows($results);
 
if ($anymatches == 0) {
echo "Sorry, but we can not find an entry to match your query<br><br>"; }
 
//And we remind them what they searched for 
echo "<b>Searched For:</b> " .$find;
}
?>
</tr>
</table></center>
</body>
</html>

I am developing a intranet forum in Php and MySQL and I am using ajax to display searched results on the same page but right now I am using query LIKE text% to search in database which is slower. but I want to make it fast search engin which can parse *,+ and show result.

Since I am using ajax i am not able to use free search engin,so if possible pls provide a complete solution

Im currently working on a new feature called 'Request Player'. Basically what this does is allows managers to request players within their club for a upcoming fixture. There a multiple teams within a club (Senior As, Senior Bs, Colts U21s). Each team is controlled by a manager. And then they can add players as they need.

Anyway, I'm having problems with the sql JOIN.

I have currently got this:

$check = "SELECT u.* FROM users AS u LEFT JOIN requests AS r ON (u.id = r.player_id) WHERE (u.id = r.player_id)";


I have got two tables.

users - all the managers and players.
requests - all the requests the managers make to other teams within their club.

In the request table i have got this:

id
player_id - the players that has been requested.
fixture_id - the fixture the manager wants to have that player for.
accepted - if he has been accepted or not. This comes later on.

At the moment i have got it working so that it inserts this data, although the code is working but i want to have a mysql query that checks if a manager has any incoming requests from other teams within the club. BUT only request that has been made to his team....

Could someone please help me out?

First off Please bear with me. I am newbie.

Here is a table name 'Employes' and has following Columns.
ID(PK) | FirstName | LastName | SecurityLicence | CrowdLicence | DriversLicence | Password |

And through form all the values are assigned to these columns and user gets registered.
I have done it using this code and its working fine.
Code: [Select]
<?php
session_name('YourVisitID');
session_start();
if(!isset($_SESSION['FirstName']))
        {
                header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/index.php");
                exit();
        }
else
{
$page_title = 'Register';
include('templates/header.inc');
if(isset($_POST['submit']))
{
        require_once('mysql_connect.php');
        // connect to the db
        
        //Create a function for escaping the data.
        function escape_data($data)
        {
                global $con; // need connection
                if(ini_get('magic_quotes_gpc'))
                {
                        $data = stripslashes($data);
                }
                return mysql_real_escape_string($data, $con);
        }
        $message = NULL;
        if(empty($_POST['firstName']))
        {
                $fn = FALSE;
                $message .= '<p>you forgot to enter your first name!</p>';
        }
        else
        {
                $fn = escape_data($_POST['firstName']);
        }
        
        if(empty($_POST['lastName']))
        {
                $ln = FALSE;
                $message .= '<p>You forgot to enter your last name!</p>';
        }
        else
        {
                $ln = escape_data($_POST['lastName']);
        }
        if(empty($_POST['licenceId']))
        {
                $li = FALSE;
                $message .='<p>You Forgot enter your Security Officer Licence Number!</p>';
        }
        else
        {
                $li = escape_data($_POST['licenceId']);
        }
        if(empty($_POST['crowdLicenceNo']))
        {
                $cln = FALSE;
                $message .='<p>You Forgot to enter your Crowd Controller Licence Number!</p>';
        }
        else
        {
                $cln = escape_data($_POST['crowdLicenceNo']);
        }
        if(empty($_POST['driverLicenceNo']))
        {
                $dln = FALSE;
                $message .='<p>You forgot to enter your Driving Licence Number!</p>';
        }
        else
        {
                $dln = escape_data($_POST['driverLicenceNo']);
        }
        if(empty($_POST['password']))
        {
                $p = FALSE;
                $message .='<p>You forgot to enter your password!</p>';
        }
        else
        {
                        if($_POST['password'] == $_POST['password2'])
                                {
                                        $p = escape_data($_POST['password']);
                                }
                        else
                                {
                                        $p = FALSE;
                                        $message .='<p>Your password did not match the confirmed password</p>';
                                }
        }
        if($fn && $ln && $li && $cln && $dln && $p)
        {
                                
                $query = "SELECT ID FROM Employes WHERE SecurityLicence='$li'";
                $result = @mysql_query($query);
                if(mysql_num_rows($result) == 0)
                { 
                
                
                $query = "INSERT INTO Employes (FirstName, LastName, SecurityLicence, CrowdLicence, Driverslicence, Password)
                VALUES ('$fn', '$ln', '$li', '$cln', '$dln', PASSWORD('$p'))";
                $result = @mysql_query($query);
                        if($result)
                                {
                                        echo '<p>You have been registered</p>';
                
                                }
                        else
                        {
                                $message = '<p>We apologise there is a system error.</p><p>' . mysql_error(). '</p>';
                        }
                } 
                else 
                {
                        $message = '<p>That Security Licence is already registered</p>';
                }
                        mysql_close();
        }
        else
        {
                $message .='<p>Please try again</p>';
        }
}

//print the message if there is one
if (isset($message))
{
        echo '<font color="red">', $message, '</font>';
}
}
?>
<script type="text/javascript">
function validate_form()
{
        var f = document.forms["regForm"]["firstName"].value;
                if(f==null || f=="")
                        {
                                alert("First Name must be filled out");
                                return false;
                        }
        var l = document.forms["regForm"]["lastName"].value;
                if(l==null || l=="")
                        {
                                alert("Last Name must be filled out");
                                return false;
                        }
        var sl = document.forms["regForm"]["licenceId"].value;
        var s = /^\d{5,}$/g.test(sl);
        var sll = sl.length;
                if(s==false)
                        {
                                alert("Security Licence No must be filled out in digits");
                                return false;
                        }
                else if(sll>=7)
                        {
                                alert("Invalid Security Licence No");
                                return false;
                        }
        var csl = document.forms["regForm"]["crowdLicenceNo"].value;
        var k = /^\d{5,}$/g.test(csl);
        var csll = csl.length;
                if(k==false)
                        {
                                alert("Crowd Controller Licence No must be filled out in digits");
                                return false;
                        }
                else if(csll>=7)
                        {
                                alert("Invalid Crowd Controller Licence No");
                                return false;
                        }
        var d = document.forms["regForm"]["driverLicenceNo"].value;
        var v = /^\d{6,}$/g.test(d);
        var dl = d.length;
                if(v==false)
                        {
                                alert("Driver's Licence No must be filled out in digits");
                                return false;
                        }
                else if(dl>=11)
                        {
                                alert("Invalid Driver's Licence No");
                                return false;
                        }
       
}
</script>


<h3>Employment Registration Form</h3>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" name="regForm" method="post" onsubmit="return validate_form()">
<fieldset>
<legend>Enter informations in the form below</legend>
<table>
<tr><th>First Name:</th><td><input type="text" name="firstName" /></td></tr>
<tr><th>Last Name:</th><td><input type="text" name="lastName" /></td></tr>
<tr><th>SO Licence No:</th><td><input type="text" name="licenceId" size="5" /></td></tr>
<tr><th>CC Licence No:</th><td><input type="text" name="crowdLicenceNo" size="5" /></td></tr>
<tr><th>Driver's Licence No:</th><td><input type="text" name="driverLicenceNo" size="10" /></td></tr>
<tr><th>Create Password:</th><td><input type="password" name="password" size="10" /></td></tr>
<tr><th>Confirm Password:</th><td><input type="password" name="password2" size="10" /></td></tr>
</table>
<input type="submit" name="submit" value="Register" />
<input type="reset" value="Reset" />
</fieldset>   
</form>

<?php
include('templates/footer.inc'); 
?>
 

Here is another Table "Jobs", with the following columns.
JobID(PK) | ID(FK) | JobDate | JobStart | JobFinish | JobLocation | RequestedBy |

For Example I am the owner of the company and want to assign jobs to my registerd workers using a form.
I assign JobDate=12/12/12 JobStart=1900 JobFinish=2300 JobLocation=Perth Requestedby=John. And I do it using form. JobID will be incremented automatically.
Now what i dont understand is how do I assign ID(FK) to it?? I am newbie this question may sound stupid to many of you but hey please help.
Or should I replace ID(FK) with the SecurityLicence of the worker, Like this
JobID(PK) |ToSecurityLicence | JobDate | JobStart | JobFinish | JobLocation | RequestedBy |

What I want is when the workers signs in He should see the job assigned to him. Can I do it using inner join??? if so how to right PHP code for comparing these two tables???
I am way too much confused.

Too many of you I have made a fool of myself asking this question. But I believe a person who doesnt ask the question is fool foreva.

If somebody could Help I would really really aprreciate it.

Thanks.

Hi

I want to know I can select which ID I get from an inner join?

Not sure If I should post here or in the MYSQL forum, but as it's using OOP I posted here.


Code: [Select]
$sql = "SELECT * FROM area_county INNER JOIN area_country ";
$sql .= "ON area_county.country_id = area_country.id ";
$sql .= "ORDER BY area_country.country, area_county.county ASC ";
$sql .= "LIMIT {$per_page} ";
$sql .= "OFFSET {$pagination->offset()}";
$list = Area_county::find_by_sql($sql);

foreach($list as $lists){
$ID = $lists->id;
$country_id = $lists->country_id;
$county = ucwords($lists->county);
        $country = ucwords($lists->country);

echo $ID;
}


I want it to show the ID of the county, NOT the id of the country.
both tables in the database have the ID column called id.

I know this can be done, but not to sure how.


Thanks

I'm trying to figure out the best way to do this if I'm doing it right with my for loop. With how many numAnswers there are for the selected poll its going to put the div with the label and text box for each of those but its giong to go and tie in each of those pollAnswers with what ID of the pollAnswer to the pollAnswer table.


Code: [Select]
$pollsQuery = "
    SELECT
        polls.question,
        polls.statusID,
        polls.numAnswers,
        DATE_FORMAT(polls.dateExpires, '%m/%d/%Y') AS dateExpires
    FROM
        polls
    WHERE
        polls.ID = '" . $pollID . "'";
$pollsResult = mysqli_query ( $dbc, $pollsQuery ); // Run The Query
$row = mysqli_fetch_array ( $pollsResult, MYSQL_ASSOC );

$pollAnswers = "
    SELECT
        pollAnswers.ID,
        pollAnswers.answer
    FROM
        pollAnswers
    WHERE
        pollAnswers.pollID = '" . $pollID . "'";
$pollAnswersResult = mysqli_query ( $dbc, $pollAnswers ); // Run The Query

Code: [Select]
<fieldset class="answerLeg">
        <legend>Edit Poll Answers</legend>
        <?php for ( $j = 0; $j <= $numAnswers; $j++) { ?>
            <div class="field required answers">
                <label for="answer<?php $j?>">Answer <?php $j?></label><input type="text" class="text" name="answer<?php $j?>" id="answer<?php $j?>" title="Answer <?php $j?>"/>
                <span class="required-icon tooltip" title="Required field - This field is required, it cannot be blank, and must contain something that is different from emptyness in order to be filled in. ">Required</span>     
            </div>
        <?php } ?>
    </fieldset>

Hello everyone,   I am hopping someone can help me sort out a query.   I have two tables, one table is a players table, and a second table is a player_vitals data that stores heights and weight changes.  I want to list all the players showing the latest height and weight change.   this query will not fetch the latest height and weight   SELECT a.player_id, a.player_first_name,a.player_last_name, b.player_height, b.player_weight

I'm an amateur PHP/mySQL person, trying to learn some more things, and I've hit a snag trying to do something I haven't done before.

Okay, here's what I'm trying to do. I have 3 tables:

Items (which includes `id` as the primary key) and a TON of information about each item.
Shop (which includes `id` as the primary key) and shop name and location.
Sale which has shop_id and item_id.

So, what I'm trying to do is have a form where someone can input in an item name and a shop name and have that item then added to the shop. This is where the Sale table comes into play too, as that's going to house each of the items and what shop it's in.

I currently have the following queries:


       $query5 = $db->execute("SELECT id FROM items LEFT JOIN sale ON items.id=sale.item_id");
       $query6 = $db->execute("SELECT id FROM shop LEFT JOIN sale ON shop.id=sale.shop_id");


I have the following form:


        if ($name == "") { $errors++; $errorlist .= "Name is required.<br />"; }
        if ($location == "" ) { $errors++; $errorlist .= "Location is required.<br />"; }
if (!isitem($itemname)) die("That item does not exist."); }

        if ($errors == 0) { 
            $query = doquery("INSERT INTO `sale` SET `item_id`=`$item`");
            admindisplay("New Item Added.","Add Items");

$page = <<<END

<b><u>Add Item</u></b><br /><br />
<form action="create_shop.php?do=additem" method="post">
<table width="90%">
<tr><td width="20%">Name:</td><td><input type="text" name="itemname" size="30" maxlength="255" value="" />**Be sure the item is already in the database and matches it IDENTICALLY.</td></tr>
<tr><td width="20%">Location:</td><td><input type="text" name="location" size="30" maxlength="55" value="" /><br /><span class="small">Where is the item obtained (unique shop name, please!)</span></td></tr>
</table>
<input type="submit" name="submit" value="Submit" /> <input type="reset" name="reset" value="Reset" />
</form>


What next steps do I need to take? Am I even on the right path?

Thanks for any and all help anyone provides!! I really appreciate it!

Not sure if it is because it is too early in the morning but I am having a problem.

Code: [Select]
$mpid = #

$query = "SELECT table1.title, table2.* ".
 "FROM table1, table2 ".
"WHERE table1.mpid = table2.mpid";

How do I only show the info from the 2 tables where mpid=#

I'm trying to pull from my database every spell or attack that is equal to `All`, but it doesn't seem to be working. All it is doing is pulling all the spells, regardless of class = `All`, and also 0 of the attacks. It should be producing a single attack that is = to `All` as no spells are = `All`.

Any help would be greatly appreciated! Thanks! (This is my first attempt at a JOIN statement...)


$query = "SELECT attacks.id, attacks.name, attacks.price, attacks.class, attacks.descript, spells.id, spells.name, spells.price, spells.class, spells.descript ".
"FROM attacks, spells ".
"WHERE attacks.class = 'All' || spells.class = 'All' order by attacks.name, spells.name asc";

Hello All,

Hi guys,

Would like to check if I have done my INNER JOIN function correctly, as I have received and an error msg

Warning: mysqli_error() expects exactly 1 parameter, 0 given in D:\inetpub\vhosts\111.com\httpdocs\111.com\registration3.php on line 598.

Thanks


<?php
   $dbc = mysqli_connect('localhost', '111', '111', '111')
   or die(mysqli_error());
   $query = "SELECT sl.subject_level_id, sl.level_id, sl.subject_id, tl.name AS level_name, ts.name AS subject_name " .
    "FROM tutor_subject_level AS sl " .
    "INNER JOIN tutor_level AS tl USING (level_id) " .
    "INNER JOIN tutor_subject AS ts USING (subject_id) ";
   $sql = mysqli_query($dbc, $query);
   
   echo'<table><tr>'; // Start your table outside the loop... and your first row
   $count = 0; // Start your counter
      while($data = mysqli_fetch_array($sql)) {
         /*    Check to see whether or not this is a *new* row
            If it is, then end the previous and start the next and restart the counter.
         */
         if ($count % 5 == 0) {
            echo "</tr><tr>"; $count = 0;
         }
         echo '<td><input name="subject_level[]" type="checkbox" id="'.$data['subject_level_id'].'" value="'.$data['subject_level_id'].'"/>';
         echo '<label for="'.$data['subject_name'].'">'.$data['subject_name'].'</label></td>';
         $count++; //Increment the count
      }
   echo '</tr></table><br/><br/>'; //Close your last row and your table, outside the loop
   
?>


Wilson