Jump to content


alapimba

Member Since 15 Nov 2006
Offline Last Active Aug 29 2014 11:47 AM

Topics I've Started

how to create ranking and order mysql table

29 August 2014 - 11:25 AM

Hello

 

I have a mysql table like this:

id | user | car
1 | 1 | fiat 500
2 | 2 | vw polo
3 | 2 | vw golf
4 | 3 | renault clio
5 | 2 | fiat panda

6 | 3 | seat ibiza

From this table how can i get a query that the result be like:

 

user 2 - 3 cars

user 3 - 2 cars

user 1 - 1 cars

 

Thanks


Loop Throught Sql Results And Don't Print Repeated Data

22 November 2012 - 01:32 PM

Hello

I have a mysql database that looks like this:

id_name - phone number - email
1 - 927567348 - lalala@gmail.com
1 - 965437823 - lalala@gmail.com
1 - 963423495 - lalala@gmail.com
2 - 4357986345 - bubu@hotmail.com
2 - 4395874355 - bubu@hotmail.com
3 - 3459875234 - ghjfgh@mail.com

and now i want to print it like this:

1
927567348
965437823
963423495
lalala@gmail.com

2
4357986345
4395874355
bubu@hotmail.com

3
3459875234
ghjfgh@mail.com


I don't know how do this.
if i didn't needed to print the email in the end it would be "simple"

like this:
<?php
$id_name = $row_rs_livros['id_name'];
while ($row_rs_livros = mysql_fetch_assoc($rs_livros)) {
  if ($iddolivro != $row_rs_livros['id_name']) {
   echo $row_rs_livros['id_name'];
   }
  echo $row_rs_livros['phonenumber'];
  $iddolivro = $row_rs_livros['id_li'];
  }
?>

But in this case i'm lost.

Anyone can help me please?

Thanks

Text hidden behind div on firefox

14 September 2012 - 04:05 AM

Hello

I'm doing a site with wordpress and i'm having problem with... i guess divs

It only happends with firefox, with IE and chrome is fine. but i want it fixed on firefox too.

take a look here: http://r2com.pt/wordpress/about/

The content can only be read until 2008/2009 and i have text until 2012.
I can't understand what is wrong. anyone can help? Thanks

This site works in your pc?

30 October 2011 - 07:11 AM

Hello

I did this site for a client and he is happy with that.
but he reported that the site is not working in 3 diferent pc's of 3 diferent people.
can you find any problem with the site?

the url is http://tinyurl.com/62jjdr9

Regards

how to make a 180º panorama?

26 July 2011 - 12:34 PM

Hello, anyone can point me in the right direction on how to make a 180º panorama?

I have a 180º image of my office, i want to put it on a size with all the width of the open browser (100%) and the user to be able to scroll from the left to the right of the image with rollover.

Anyone can help? I have searched a lot but nothing of what i found does what i need.

Thanks

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com