desithugg Posted August 11, 2006 Share Posted August 11, 2006 [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??? Quote Link to comment Share on other sites More sharing options...
Barand Posted August 11, 2006 Share Posted August 11, 2006 Your query currently references 5 tablesauthor postidextrasignaturebut 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. Quote Link to comment Share on other sites More sharing options...
desithugg Posted August 11, 2006 Author Share Posted August 11, 2006 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?? Quote Link to comment Share on other sites More sharing options...
HeyRay2 Posted August 11, 2006 Share Posted August 11, 2006 [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] Quote Link to comment Share on other sites More sharing options...
desithugg Posted August 11, 2006 Author Share Posted August 11, 2006 thnx alot Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.