Select word from string

@KruithneMay 03.2010 — #If you have all the photos in a database table and going to be linking then via keywords from the titles I would do something like this ...

Have another column for each photo thats Keywords and put say 3 keywords for each.

[code=html]
 <?php
 //Current photos keywords (pull these from the current photos keywords field)
 $keyword1 = 'Outdoors';
 $keyword2 = 'Car';
 $keyword3 = 'Person'; //Rubbish keywords ey :P
 
 //Now we search for say 10 other photos with the same keywords..
 $query = "SELECT * FROM Photos WHERE Keywords LIKE '&#37;$keyword1%' OR Keywords LIKE '%$keyword2' OR Keywords LIKE '%$keyword3' LIMIT 0, 10";
 $result = mysql_query($query);
 $count = 0;
 echo "<table><tr>";
 while($row = mysql_fetch_array($result)){
 $count++;
 if($count == 5){
 echo "</tr><tr>";
 }
 $title = $row["Title"];
 $thumb = $row["Thumbnail"];
 $id = $row["PhotoID"];
 echo "<td><a href="viewphoto.php?photo=$id"><img src="photos/thumbnails/$thumb"><br/>$title</a></td>";
 }
 echo "</tr></table>";
 ?>
 [/code]

This is a very rough version and is untested and most likely won't run but it is just to give you an idea of what I would do. Hopefully it helps ?

Kruithne

Select word from string

2 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

Select word from string

2 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

2 Comments(s) _↴

Also in #PHP _↴