Posts by DanielTulp

let them create an xml file dynamically from the database on a secured location
I think that would be the easiest solution

And i can get the result of the queries and insert them on different tables?

yes, html tables, sql tables, whatever you want

Based on your explanation you gave im sure that i can compare all the filds of each table of the database and i also saw it on joint query explanation.
Thank you

you're welcome

first, you don't need the first two sql commands anymore
second, I think you should specify what you want to select (in this case *)
third, use the outer join command to get non matches

<?php
$handle_db1 = mysql_connect("localhost","myuser","apasswd");
$handle_db2 = mysql_connect("127.0.0.1","myuser","apasswd");
mysql_select_db("db1",$firstDB);
mysql_select_db("db2",$SecondDB);

//get the results when there is a match
$query_match="SELECT * FROM SecondDB.TableA inner join firstDB.TableA  ON TableA.userID=TableB.userID";

//get the results when there is no match
$query_nomatch="SELECT * FROM SecondDB.TableA outer join firstDB.TableA  ON TableA.userID=TableB.userID";
?>

this should give you the results that do ant don't have a match

http://www.google.nl/search?hl=nl&client=firefox-a&hs=z31&rls=org.mozilla%3Anl%3Aofficial&q=sql+join&aq=f&aqi=&aql=&oq=&gs_rfai=

yep, using 1 database is best
otherwise you'd be synchronising the whole time

to display data from an xml check out these resources
http://www.w3schools.com/PHP/php_xml_simplexml.asp
http://php.net/manual/en/book.xml.php

here is some sample code I use to display text (used on http://photo.danieltulp.nl)

<?php
                $newsitems = new SimpleXMLElement('xmlfilename.xml', null, true);

                foreach ($newsitems as $item):?>
                <div class="newsitem">
                    <h4><?php echo $item->title?><span class="date"><?php echo $item->date?></span></h4>                    
                    <p><?php echo $item->body?></p>
                </div>
                <?php 
                endforeach;?>

if you want a button to go the next record, you could use:

<?php
                $records = new SimpleXMLElement('records.xml', null, true);
                $i = 0;
                foreach ($records as $record):?>
                <div class="record-<?php echo $i;?>" style="display:none;">
                    <p>Name: <?php echo $record->name?><br />
                    Age: <?php echo $record->age?><br />                   
                    Mark: <?php echo $record->mark?></p>
                </div>
                $i = $i + 1;
                <?php endforeach;?>

and then use javascript to set the display property to block or inline

search for the sql join command and you'll probably find your answer

oh my, doesn't anyone take the time to read articles any more...
here is an excerpt for the lazy people on this planet:

1. You can't prevent it, if someone really really wants to, they can
2. You can make it harder by doing, one or (many) more of the following:
a. watermark your images -> very good method, but doesn't look very good
b. use low resolution -> they won't be able to use your images for anything else then webpages
c. remove any colour management profiles -> harder but has same effect as b.
d. using as background with transparent image on top -> pretty easy to work around but can be automated using automatically generated css file
e. javascript right click disable -> as said before, also easy to work around
f. prevent leaching with .htaccess -> bit harder to do but works, also gives options to log the use of images using the 404 page and then approach the thieves
g. prevent search engine indexing -> I don't know why he put this as an option, sounds silly to me
h. actively search for use of your images on the web -> sue the a**holes!! ;)
i. copyright your images -> you can register yourself as the owner of the copyright

conclusions of the article:

Every image protection technique will have its pros and cons. A watermark can detour image theft but can …

dannie, have you read the article? please do and realise that your comment is tackled in it

This website gives insight into the methods available for image protection, or at least to make it harder to steal images: http://www.naturefocused.com/articles/image-protection.html