Jump to content

Archived

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

steply

MX/PHP TABLE JOIN

Recommended Posts

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?

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.