Jump to content

Archived

This topic is now archived and is closed to further replies.

desithugg

join query

Recommended Posts

[code]
<?php
$link = mysql_connect('localhost', $my_sql_password, $my_sql_username);
if (!$link) {
  die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db('tpf');
if (!$db_selected) {
  die('Could not select database: ' . mysql_error());
}
$query = "SELECT author.post,post.post,id.post,extra.post,signature.signup FROM post where thread_id = '$thread_id' ORDER BY id.post ASC limit $start,10";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)) { $count++; $row['post'] = str_replace(array_keys($filter), array_values($filter), $row['post']); $row['post'] =  nl2br($row['post']);
echo "too long to post here";
}
?>
[/code]
but i also want to recieve the get the signup table where the username = author.post but i dont know where to add it do i use AND OR???

Share this post


Link to post
Share on other sites
Your query currently references 5 tables

author
post
id
extra
signature

but there is only the 'post' table in the FROM clause.

Perhaps if you tell us what columns are in the relevant tables and what you are trying to achieve.

Share this post


Link to post
Share on other sites
o my bad so the table comes before the dot
[code]
<?php
$link = mysql_connect('localhost', $my_sql_password, $my_sql_username);
if (!$link) {
  die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db('tpf');
if (!$db_selected) {
  die('Could not select database: ' . mysql_error());
}
$query = "SELECT post.author,post.post,post.id,post.extra,signup.signature FROM post.signup where thread_id = '$thread_id' ORDER BY id.post ASC limit $start,10";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)) { $count++; $row['post'] = str_replace(array_keys($filter), array_values($filter), $row['post']); $row['post'] =  nl2br($row['post']);
echo "too long to post here";
}
?>
[/code]

okay there and i want to eceice the row signup.signature where the row signup.username is = to post.author but where do i add this since i already have a where do i use AND OR??

Share this post


Link to post
Share on other sites
[code=php:0]
$query = "SELECT post.author, post.post, post.id, post.extra, signup.signature
FROM post
LEFT JOIN signup ON signup.username = post.author
WHERE thread_id = $thread_id
ORDER BY post.id ASC
LIMIT $start,10";
[/code]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.