pascal_22

Hello to all! I ask myself the following question: Is there a way that is better to calculate the number of members / guests online I have a table with ip, id member ,URL of the actual page ... I try with a primary key for the IP address, but some provider changes the IP Adress of their client several times a day or every few minutes ... So that resulted resulted duplicates entry... I try with the member id ... but that can not count visitors as those not connected their id is -1 Is there a better way than another? Do You calculate just members connected? thank you pascal

Hello to all! I have a question. I really like that kind of button http://getbootstrap.com/components/#btn-dropdowns-split I tried it without JS and it doen't work... Is there a way, for user without JS to make it works? Thanks a lot! Pascal

Thanks for your help! I Appreciate!! Have a great day! Pascal

Hello!! I think subdomain was perfect for me! One more question! How google interpret those url: mysite.com/register ->english version fr.mysite.com/register de.mysite.com/register Does Google interpret it as 3 different url or a unique url? For sure, depending of subdomain, the page register will be in a good translaton!! Thanks a lot! Pascal

thanks for your response sKunkbad, I will not try automatic translate... all do it all myself or with other people in this language You suggest subdomain and i think that was nice! What do you thing betwween this: fr.mysite.com en.mysite.com of mysite.fr -> fr version mysite.com -> en version thanks a lot! Pascal

Hello to all! Since 2009 my website is online. It's a french dating site. Now i want to make it available in english too. I wonderring what is the best practice? should i Create a new domain name and separate english and french OR create my actual website multilingue. What do you suggest? Also... for an multilingu website, when a french member register, he will describe himself in french, but if an english member view my site in english and visites a profile of a french member... all will be in english but not the description of the french member...... is it bad or not? Thanks for your precious help! Pascal

any suggestions? thanks! Have great day!

Hello!! i'm a bit confuse... My actual query: select p.idmember,p.Note,p.CheminPhoto, usagers.username,profiles.ville,profiles.sexe,profiles.age from photosprofils inner join profiles.idmember=p.idmember inner join usagers on usagers.idmember=photosprofils.idmember inner join province on province.idprovince=profiles.idprovince where.... order by note desc in the where clause, depending if user is logged or not, i add the looking sex.... When i did a EXPAIN on it... it take 0.0055 seconde.... i think it's pretty good When i try you Query.... without adding all my INNER JOIN... it take 0.5 seconde..... when i add all my INNER JOIN (usager, province, profil,...) the time is between 0.9 and 2.0 seconde.... oufff.... do i miss something... Because yes i display pics but i show the name of the member, the city(ville), the province or state, the sexe, the age...... Thanks a lot for you precious help! Have a good week end! Pascal

Thanks so much Barand!!! It works perfectly! Does that kind of query are heavy for a server..? i mean for performance...? Also, can i add another field as OTHER, maybe OTHER2 that will get each NOTE of the picture in the same order thans 'OTHER' field ---> 10, 9.5,8,6..... So when i display thumbnail of other pics, i will also display the NOTE (maxvote) of this pic! Thanks so much! Pascal

Hi Barand! Thanks a lot for your help! That works perfectly! That exacly what i need!! But on more thing that i can't figure it out... What to do with my limit 20 I mean some user has 9 picture or more.... so for this user: it means 8 rows... so if i did a limit 20, this page will have only 11 members...... (assuming that other members as only one pic) What sould i do? Change my select? or another way? Thanks for your help Pascal

Thanks Barand! I tested it and the result was it select the highest vote for each user... but if i add a limit 20 and order by p.TotalVote desc, to show 20 results per page, and then i make an EXPLAIN.... it search in all rows of my database.... that can load my server.... Is that normal? After i selected the highest Vote for this user... how can i get other pics of the same members...? i know that i can query like this: while($row = $highestVote->fetch_assoc()) { //display highest vote of this user... ... //check if this user has others pics $otherpics = $db->query(select * from photosprofils where idmember=".$row["idmember"]." and id!=".$row["id"]) if($otherpics->num_rows>0) { //display in thumbnail otherpics of this user } } but i'm pretty sure that it is not the BEST WAY to do this.... send a query to the database at each rows(20 rows per page)... that can load the server...... ??? no? Because, i want to show the highest vote picture of a member(maybe 150px width and height) + i want to show other pics of the same members(before showing the next highest vote of an other member) in small(maybe 75px width and height) after the highest vote(bigger picture) i dont know if my explication is good? is it ? Thanks a lot!! Pascal

Ok thanks, i'm trying it now! i'll come back!! I really appreciate!!!! thanks a lot!!! Pascal

Sorry for the response time... i didn't see the email.... for sure here is the table structure.. please note that some field has a french name..... photosprofils ---------------- id idmember CheminPhoto (path) SectionVote (if the photo can be rated or not) DateEnvoi (sent date) Note TotalVote NbVote idprofil Approuver (approuved) Thanks a lot!

Thanks for your replies! What Davidannis explain in exactly what i need! Sorry if my question was hard to understand. Actually on my site: i have a query that get photopath order by Rating desc so i display it and some user appears a lot of times... How can i do it as Davidannis explain? Thanks a lot! Pascal

Any hint? thanks !! Pascal