PHP - Table Joining Help Please

I hope this is not confusing. 
Lets say I want to join 2 tables.

When I put it through a while loop, how do I write the code so that all id's in table2 are on the SAME line for each referring id in table 1, before dropping to the next line and going to the next record in table 1?

I THINK that actually makes sense if you read it carefully :-)

What I want is basicly a newspaper function.

I have a table like this:

name hone website email name1 hone1 website1 email1
So what i want is creating a mail link that takes the 2 mailadresses from my table. 1 email with 2 reciepts. Just like you seperate them with the ; in you mailclient

mailto:email; email1


Hoping someone can help, I think it is not that hard, I am just a nOOb

Hello, I am very new to both php and sql.

how can i join the two queries so that they function as one. for example, if $keywords or $username is empty then the result will be null.

$query1 = "SELECT * FROM forums WHERE MATCH (topics) AGAINST ('$keywords' IN BOOLEAN MODE)";

$query2 = "SELECT * FROM users WHERE username='$username";

i have 2 tables.

table 1
- Id
-Name
-ShortId

table 2
-lots of data....
-Category (same value with table1 Id)

im trying to join this 2 tables...

Code: [Select]
$query = "SELECT * FROM tblnews_categories WHERE ShortId != 0 ORDER BY `ShortId`";
$result = mysql_query($query);
$query2 = "SELECT * FROM tblnews_categories, tblnews WHERE tblnews_categories.Id = tblnews.Category ";
$result2 = mysql_query($query2);
while($row = mysql_fetch_assoc($result))
{

?>
<div class="quartetin2">
<div id="HomeMoreNewsIMG2"><div id="HomeMoreNewsTitle2"><a href="summary?catid=19167"><?php echo strtoupper($row['Name']);?></a></div></div>
<div id="HomeMoreNewsText">
<?php 
while($row2 = mysql_fetch_assoc($result2))
{
?>
<tr>
<td id="HomeLatestNewsDate"><li><?php echo strtoupper($row2['Title']);?></li></td>

</tr>


<?php } ?>

What i want to do is when Id = Category echo all data under the specific category

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=353189.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=308889.0

$sql = "SELECT * FROM leads  WHERE accesstoken = '".$_POST["userAc"]."'"; 
                $result = mysql_query($sql) or trigger_error("Query Failed: " . mysql_error()); 
 
                if(mysql_num_rows($result)>0) 
                  {
	
                      while($row = mysql_fetch_array($result))
                      {
	           
                      
	   
	                  $id= $row['id'];
					  $fullname= $row['fullname'];
					  $email= $row['email'];
					  
					  $to = $email;
					  
					    $message .=	$_POST["userMessage"];
		                $subject = $_POST["userSubject"];
						
						$headers = "From: " . $_POST["userEmail"] . "\r\n";
			            $headers .= "Reply-To: ". $_POST["userEmail"] . "\r\n";
			            $headers .= "MIME-Version: 1.0\r\n";
			            $headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
						
						if (mail($to, $subject, $message, $headers)) 
			                    {
	
	
	
		                        $output = json_encode(array('type'=>'error', 'text' => '<p>Your Message was sent successfully!</p>'));
		
		                        die($output);
								}
								else
								{
									$output = json_encode(array('type'=>'error', 'text' => '<p>Your Message was not sent!</p>'));
		
		                             die($output);
									
								}
				     }
				  
                  }

I have another table called accounts that I want to join with this one, I need to select from ref to get the email from account table also!
  be something like this

$sql = "SELECT * FROM accounts  WHERE ref = '".$_POST["userAc"]."'"; 
                $result = mysql_query($sql) or trigger_error("Query Failed: " . mysql_error()); 

 

I got two statments:

"SELECT id FROM approvednotes WHERE authoer = '$username'";
"SELECT nid FROM usersdownloaded WHERE username - '$author'";

and then once I get results from both of those I want to search approved notes again using only the matches from the statements above and what I want to select this time is "SELECT * FROM approvednotes WHERE md5 ='$md5'"; But I dont actually want to search all the listings just the ones that returned true in the first two statements, is there a way to join these three statements into one? I hope I made myself clear if not let me know and ill try to reexplain.
   

Hi
As I'm new to PHP/MySQL
I need a little help concerning joining 4 tables in SQL query.
I have 4 tables
first is asort with 4+ columns
id   catid   pid   tipid   ...

id is primary key and catid, pid and tipid are foreign keys from tables kategorija, proizvod and tip

I want to make a query to join this 4 tables and find for example all rows with pid=4
I tryed with
Code: [Select]
$q1 = "SELECT * FROM asort LEFT JOIN (kategorija, proizvod, tip)
                 ON (kategorija.catid=asort.catid AND proizvod.pid=asort.pid AND tip.tipid=asort.tipid)
where tipid='$_GET[tipid]' order by cijena asc";
but I got
"Column 'tipid' in where clause is ambiguous"

Thank you for reading this especially if you are able to help me out on this.
Bye
DVAL

Hello,

I want to 'join' two corresponding array values together as in the example below.

$one = array('tomato', 'ham', 'bacon');
$two = array('soup', 'sandwich', 'roll');

$final=array(?)

//Desired answer =  (tomatosoup, hamsandwich, baconroll)

Is there a php function that can do this, or a series of functions? I am aware of array_merge but this only alternates the values from what I can see.

Ideally there should be a check performed that the two are the same length before completing a merge.

New to this, many thanks!

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=322859.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=331758.0

I have a relational table call sales with prodcut_id and custmer_id tables. I also have a product and customer tables. products table with product_id as an auto increment and customer with custumer_id I want to join through the sales tables all t he fields of row 1 from tables customer and products and pull it at once.


This is a member login script and I want to display the products by members.

So far I have this query to display the products once the member is login in. $userid is the id of the customer coming from the $userid= $_SESSION['customer_id'];


$mysqlSales="SELECT products.* FROM products JOIN sales ON (products.product_id = procuct_id ) WHERE sales.customer_id = '$userid'";


so far that statement is not working where should I have some type of incoherance with the english statement above expressing what I want the query to do.

Hey all,

Quick sum up: I have a social website where users can follow/post/vote etc. I am adding a new facebook-like activity wall feature to each users profiles.

I have worked on this bit for a few days now and can't seem to get it to work properly. What I want is, well, exactly like the facebook wall as I mentioned...When a visitor visits a user's profile, that user's activity will display, whether they recently "voted" on a post, commented, or posted something of their own, I would like it to display on their profile and of course, have the most recent entries on top.

The problems I am having right now a it's displaying some things twice and it's not sorting them by the most recent.

I am working with 3 tables here (I only posted the columns that I am using):
Code: [Select]
Table structure for table votes_posts
Field Type Null Default
indexer int(11) No
post_id int(11) No
vote int(11) No
user_name varchar(250) No
date varchar(255) No

Table structure for table posts
Field Type Null Default
id int(11) No
name varchar(30) No
content text No
datetimerss varchar(255) No
category int(11) No

Table structure for table comments
Field Type Null Default
id int(12) No
post_id int(12) No
name varchar(30) No
content text No
type varchar(30) No
datetimerss varchar(255) No

$users is just $_GET['user']
The timeAgo() function, simply displays the very popular "posted xx ago" date time.
<ul class="streamActivity">
<?php
$checkActivity = "SELECT votes_posts.post_id, votes_posts.user_name, votes_posts.vote, votes_posts.date, 

posts.id, posts.content, posts.name, posts.datetimerss, categories.category, 

comments.post_id AS comm_postid, comments.content AS comm_content, comments.name AS comm_name, comments.datetimerss AS comm_date, comments.type 

FROM `votes_posts` 

LEFT OUTER JOIN `posts` ON votes_posts.post_id = posts.id 

LEFT OUTER JOIN `comments` ON posts.id = comments.post_id 

LEFT OUTER JOIN `categories` ON posts.category = categories.cat_id

WHERE (votes_posts.post_id = posts.id AND user_name = '$user')

OR (comments.post_id = posts.id AND comments.name = '$user')

OR (posts.name = '$user') ORDER BY votes_posts.date, posts.datetimerss, comments.datetimerss ASC";
$checkActivityResult = mysql_query($checkActivity);

if (mysql_num_rows($checkActivityResult) > 0) {

while ($sessionAct = mysql_fetch_array($checkActivityResult)) {

$category = strtolower($sessionAct['category']);

$dateVote = timeAgo($sessionAct['date']);

$datePost = timeAgo($sessionAct['datetimerss']);

$dateComm = timeAgo($sessionAct['comm_date']);

$namePost = $sessionAct['name'];

$nameComm = $sessionAct['comm_name'];

$nameVote = $sessionAct['user_name'];

$idVote = $sessionAct['post_id'];

$idPost = $sessionAct['id'];

$idComm = $sessionAct['comm_postid'];

$contentPost = $sessionAct['content'];

$contentComm = $sessionAct['comm_content'];

$typeComm = $sessionAct['type'];

if ($namePost == $user) {

$classList = 'storyPost';

$classIcon = 'iconMuttr';

$name = $namePost;

$content = $contentPost .' ... read more';

$datetime = $datePost;

}

elseif ($nameComm == $user && $typeComm == "Comment") {

$classList = 'actionPost';

$classIcon = 'iconComment';

$name = $nameComm;

$content = 'Commented "'. $contentComm .'"';

$datetime = $dateComm;

} elseif ($nameComm == $user && $typeComm == "Advice") {

$classList = 'actionPost';

$classIcon = 'iconAdvice';

$name = $nameComm;

$content = 'gave Advice "'. $contentComm .'"';

$datetime = $dateComm;

}

elseif ($nameVote == $user) {

if ($sessionAct['vote'] == "1") {

$classList = 'actionPost';

$classIcon = 'iconLaughed';

$name = $nameVote;

$content = 'Laughed at "'. $contentPost .'"';

$datetime = $dateVote;

} elseif ($sessionAct['vote'] == "2") {

$classList = 'actionPost';

$classIcon = 'iconLoved';

$name = $nameVote;

$content = 'Showed Love on "'. $contentPost .'"';

$datetime = $dateVote;

} elseif ($sessionAct['vote'] == "3") {

$classList = 'actionPost';

$classIcon = 'iconIdiot';

$name = $nameVote;

$content = 'called '. $namePost .' an Idiot for "'. $contentPost .'"';

$datetime = $dateVote;

}

}
?>

<li class="row-activity <?php echo $classList; ?>">

<a href="" class="avatar"><img src="/images/avatars/default_male.jpg" /></a>

<div class="info">

<div class="userName">

<a href=""><?php echo $name; ?></a>

</div>

<span class="msgBody"><?php echo $content; ?></span>

<div class="imgTimeStream">

<span class="img <?php echo $classIcon; ?>"></span>

<span class="source"><?php echo $datetime; ?></span>

</div>

</div>

</li>
<?php

}
} else {

echo '<p>This user has no recent activity.</p>';
}
?>
</ul>


I am by no means an expert programmer...everything I know I have pretty much taught myself over the past year or two, so I can only imagine how ugly this truly is lol. I am learning each and everyday though, and I hope to continue

Also, within each type of activity, there will be slightly different CSS classes on some things.
Example:
if the result row is a post then the css class of the list item would be "post"
if the result row is a vote then the css class of the list item would be "vote"
etc.

Any help would be appreciated!