Two tables, one result

[prays]

Hi all,

 

I have these tables

 

Lead_click

----------

id

lid

click

username

 

Lead_info

---------

id

lid

description

img

url

price

 

Lead_sub

--------

id

lid

username

 

How do I list the leads where click is greater than 0, in one row, where Lead_info

provides the information such as description, and Lead_sub shows how many people

has subscribed, and only for the username "x" for instance.

I hope you understand me.

 

Thanks!

[p2grace]

Is this what you're looking for?

 

<?php
$query = "SELECT `c`.`click`, `i`.`description`, `s`.`lid` 
FROM `Lead_click` c, `Lead_info` i, `Lead_Sub` s 
WHERE `c`.`username` = '$username' AND
`i`.`username` = '$username' AND
`s`.`username` = '$username'";
$run = mysql_query($query);
?>

 

I'm not sure if I understood your question, but this would be a way of returning data from the three tables.

[prays]

I didn't really work. But i'll try to ask in another way.

From the three tables i need to write this: Description(lead_info) - Clicks(lead_click) - Leads(Number of rows in lead_sub where username=$username)

And this should be shown if click in lead_click is greater than 0, for the username, $username.

 

I hope this helped, and i'm sorry, but i have a real hard time explaining this.