Jump to content


Photo

MX/PHP TABLE JOIN


  • Please log in to reply
No replies to this topic

#1 steply

steply
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 24 February 2004 - 03:14 AM

I need to join a table [to simply drag all recordset column values over into rows. No need for repeat region on page.]

Already I have a seperate result page coming from a search menu.
This works with the first of the two tables I am using.
-------------------------------
SELECT JoID, `Jopot`, Joping FROM posts
WHERE 'Jopot` LIKE '%colname%'

NAME: colname
Default: 1
$HTTP_Get_Vars['Jopot']

Table 'Easy' has a primary 'ID' named this way, with:
ID
Epos
EPost
EClass
EStart
EEnd

note: 'EasID'column appears on this same table 'posts' as a foreign key to table 'Easy' .
Table 'posts' has:
JoID (primary, autonumber)
EasID (foreign to Easy)
Jopot
Joping
--------------------------------------
I've tried SELECT * many different ways but haven't been able to make this move! I've heard perhaps I should itemize these columns one by one to make them display better (for ordering/renaming column). This right?

How would MySQL statement read?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users