Hot Scripts Forums

Hot Scripts Forums - Database http://www.hotscripts.com/forums/ General database discussion including setup, connecting, troubleshooting and any other issue you might have can be found/posted here! en Mon, 23 Nov 2009 09:44:01 GMT vBulletin 60 http://cdn.hotscripts.com/forums/hsforum/misc/rss.jpg Hot Scripts Forums - Database http://www.hotscripts.com/forums/ Database select querry http://www.hotscripts.com/forums/showthread.php?t=55943&goto=newpost Fri, 20 Nov 2009 23:14:01 GMT Hi
I have a working database and search facility that I need to refine a bit but am having problem with
.

PHP Code:


		
			
$query = "SELECT 

    model, 

    brand, 

    gc_number, 

    dir, 

    manuals_pdffiles.id, 

    pdf_file, 

    category, 

    pdf_info, 

    DATE_FORMAT(date_available, '%d %b %y') AS Fdate, 

    safety, 

    asbestos,

    class 

FROM 

    manuals_models 

LEFT JOIN 

    manuals_pdffiles ON manual_id = manuals_pdffiles.id 

LEFT JOIN 

    manuals_brands ON brand_id = manuals_brands.id 

WHERE 

    (model like '%$entry%') AND class = 1 

ORDER BY 

    brand, model ";

The field 'models' might contain an entry such as "Potterton Puma 80e" and if the site visitor enters a search string ($entry) enters say "puma 80e" the select statement returns the correct entry. If they enter "puma 80 e" it doesn't obviously.

I can easily modify the search string $entry to remove all the spaces but how do I modify the WHERE statement so that the database entry 'model' is also minus any spaces?

Using the above example then 'model' would end up as "PottertonPuma80e" and the search string would be "puma80e". Then if site visitor added extra spaces (or left any out) the select statement would find the entry?

Hope that makes sence!! ]]> Database alane http://www.hotscripts.com/forums/showthread.php?t=55943 SQL query question http://www.hotscripts.com/forums/showthread.php?t=55772&goto=newpost Thu, 05 Nov 2009 16:05:19 GMT Hi there

I'm trying to establish if the following is possible using SQL on it's own (I know it can be done by means of scripting)

I have the following table

Code:

year (int)

course (string)

rep_id (int)

The table describes "course representitives" in a particular year. I'm trying to find a way to list the rep_id of all reps who have been a rep in 2 consecutive years. I can't for the life of me establish the SQL.

Hope someone can help.

Thanks ]]> Database landing http://www.hotscripts.com/forums/showthread.php?t=55772 Report Post This simple joing mysql select return many duplicate results http://www.hotscripts.com/forums/showthread.php?t=55671&goto=newpost Tue, 27 Oct 2009 18:09:28 GMT I've problem with this query :
MySQL pastebin - collaborative debugging tool ,

It returns many duplicated results ,
here's image : Imageshack - mysqlun - Uploaded by alex_funky_dj ]]> Database m_abdelfattah http://www.hotscripts.com/forums/showthread.php?t=55671 case sensitive search with MATCH AGAINST along with ID http://www.hotscripts.com/forums/showthread.php?t=55670&goto=newpost Tue, 27 Oct 2009 16:17:30 GMT case sensitive search with MATCH AGAINST along with ID

Here is my sql:

PHP Code:


		
			
$filterstr = sqlstr($filter);
  if (!$wholeonly && isset($wholeonly) && $filterstr!='') $filterstr = "%" .$filterstr ."%";
  $sql = "SELECT COUNT(*) FROM `description`";
  if (isset($filterstr) && $filterstr!='' && isset($filterfield) && $filterfield!='') {
    $sql .= " where " .sqlstr($filterfield) ." like '" .$filterstr ."'";
  } elseif (isset($filterstr) && $filterstr!='') {
    $sql .= " where  MATCH (ID , SERIES_NUM ,TITLE,DESCRIPTION,CATEGORY,`TYPE`,VERSION,MEDIA_TYPE,PLATFORM,DATE,FILENAME) AGAINST ('+$filterstr -$filterstr' IN BOOLEAN MODE); ";
  }
  $res = mysql_query($sql, $conn) or die(mysql_error());
  $row = mysql_fetch_assoc($res);
  reset($row);
  return current($row);

If i REMOVE ID from the MATCH...case sensitivity goes away. if i put it back in, case sensitivity comes back...how can i get around this? I need to search the ID as well without case sensitivity.

Im using MySQL 5.1.36 ]]> Database tooletime http://www.hotscripts.com/forums/showthread.php?t=55670 Database Name issue http://www.hotscripts.com/forums/showthread.php?t=55648&goto=newpost Mon, 26 Oct 2009 15:12:39 GMT Hi there, is it possible to get the name of the database from the data? I search my DB with full-text-search.. now I want to link from the results, but I need the name of the table the result was found in. I use that back in the URL to link.. F.E. Hi there,

is it possible to get the name of the database from the data?
I search my DB with full-text-search..

now I want to link from the results, but I need the name of the
table the result was found in. I use that back in the URL to link..

F.E.

search for: "Example Search" in my DB
In table 1 this is found, I need the name of table 1 to use..

Hope this comes a bit clear to someone...

_j ]]> Database jonnekke http://www.hotscripts.com/forums/showthread.php?t=55648