PROTECTED]
Subject: Re: [PHP] How to nest information from different tables.
Hi,
You can use join or make this query as follows
$query=select *(or coulmn name) from event,
eventdetails where event.id = eventdetails.id;
zareef ahmed
--- Karl-Heinz Schulz [EMAIL PROTECTED] wrote:
I have two tables
Karl-Heinz Schulz wrote:
snip
But it generates now for the second query the is not a valid MySql result
error.
/snip
Echo out mysql_error() after you try to execute the second query.
--
By-Tor.com
It's all about the Rush
http://www.by-tor.com
--
PHP General Mailing List (http://www.php.net/)
To
Karl-Heinz Schulz wrote:
snip
$eventdetails_query = mysql_query(select details, information, file_name
from eventdetails where event.id = eventdetails.event_id);
/snip
What is 'eventdetails.event_id'?
Should this be a variable?
$eventdetails.event_id?
--
By-Tor.com
It's all about the Rush
:17 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] How to nest information from different tables.
Karl-Heinz Schulz wrote:
snip
$eventdetails_query = mysql_query(select details, information, file_name
from eventdetails where event.id = eventdetails.event_id);
/snip
What is 'eventdetails.event_id
But it generates now for the second query the is not a valid MySql result
error.
TIA
-Original Message-
From: zareef ahmed [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 29, 2004 11:57 PM
To: Karl-Heinz Schulz; [EMAIL PROTECTED]
Subject: Re: [PHP] How to nest information from different tables.
Hi
Karl-Heinz Schulz wrote:
John,
eventdetails is a table
event_id is a field in the eventdetails table
I want to show all file downloads (information's in table eventdetails) for
all events (table name is event)
TIA
Okay. What does mysql_error() say?
--
By-Tor.com
It's all about the Rush
Jeremy Berthet wrote:
You have forgotten one table in your second query, try this :
$eventdetails_query = mysql_query(select details, information,
file_name from event, eventdetails where event.id =
eventdetails.event_id);
Good eyes. ;)
--
By-Tor.com
It's all about the Rush
http://www.by-tor.com
]
Subject: Re: [PHP] How to nest information from different tables.
Hi,
You can use join or make this query as follows
$query=select *(or coulmn name) from event,
eventdetails where event.id = eventdetails.id;
zareef ahmed
--- Karl-Heinz Schulz [EMAIL PROTECTED] wrote:
I have two
Karl-Heinz Schulz wrote:
Thank you,
I made one error - I forgot the second table (Thank you Jeremy)
It didn't like the field information in the eventdetails table - it worked
after I changed it to informations (Thank you John).
..but the result is not what I was trying to achieve.
I'm
, July 30, 2004 9:52 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] How to nest information from different tables.
Karl-Heinz Schulz wrote:
Thank you,
I made one error - I forgot the second table (Thank you Jeremy)
It didn't like the field information in the eventdetails table - it
worked
Karl-Heinz Schulz wrote:
John,
Since we never have more than 30 records I don't think it will be necessary
to join the tables.
Your queries are preforming a join (you're selecting from more than one
table with one query, a common reference pointetc.). Check out
Did your table event_details contain a field linked with
event.id ? if not, you'll need it
Maybe I misunderstood what you want, but try this
$event_result = mysq_query(SELECT * FROM event_table) or
die(Cant catch events);
print(table);
while ($eventDb =
Hi,
You can use join or make this query as follows
$query=select *(or coulmn name) from event,
eventdetails where event.id = eventdetails.id;
zareef ahmed
--- Karl-Heinz Schulz [EMAIL PROTECTED] wrote:
I have two tables with relevant information's;
Table1 - event
Table 2 - eventdetails
13 matches
Mail list logo