[PHP-DB] Problem with Oracle query
Hi, I have a problem with PHP and Oracle SQL query. I have 2 tables : Table Main: --- id number text varchar2(100) Table Recs --- id number pos number log varchar2(200) I need to make query to select a list from first table(Main), where somewhere in the second table (Recs), the log field contains some string. The records for one ID from Main table can be many in table Recs. ( Table Recs acts as log for every row from table Main). Can someone help me with this query? Thanks in advance, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Problem with Oracle query
Try this ... SELECT m.id ,m.text FROM main m ,recs r WHERE m.id = r.id AND r.log like '%sometext%' ORDER BY m.id / Roy A. Jones Rick [EMAIL PROTECTED] 13-Oct-2006 10:53 To php-db@lists.php.net cc Subject Re: [PHP-DB] Problem with Oracle query Brad Bonkoski [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Rosen wrote: Hi, I have a problem with PHP and Oracle SQL query. I have 2 tables : Table Main: --- id number text varchar2(100) Table Recs --- id number pos number log varchar2(200) I need to make query to select a list from first table(Main), where somewhere in the second table (Recs), the log field contains some string. The records for one ID from Main table can be many in table Recs. ( Table Recs acts as log for every row from table Main). Can someone help me with this query? Thanks in advance, Rosen select m.id, r.log from main m left outer join recs r on r.id = m.id This will output something like: Id log 1log item 1 1log item 2 1log item 3 2another log etc... Thanks, but I want to retrieve only one row for ID field (row from Main table) where the string contains in second table. Something like this: ID Text 1 Sometext 1 2 Sometext 2 6Sometext 3 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Problem with Oracle query
[EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Try this ... SELECT m.id ,m.text FROM main m ,recs r WHERE m.id = r.id AND r.log like '%sometext%' ORDER BY m.id / Thanks, but this retrieves me so much rows as many are the appearance the 'sometext' in the Recs table Roy A. Jones Rick [EMAIL PROTECTED] 13-Oct-2006 10:53 To php-db@lists.php.net cc Subject Re: [PHP-DB] Problem with Oracle query Brad Bonkoski [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Rosen wrote: Hi, I have a problem with PHP and Oracle SQL query. I have 2 tables : Table Main: --- id number text varchar2(100) Table Recs --- id number pos number log varchar2(200) I need to make query to select a list from first table(Main), where somewhere in the second table (Recs), the log field contains some string. The records for one ID from Main table can be many in table Recs. ( Table Recs acts as log for every row from table Main). Can someone help me with this query? Thanks in advance, Rosen select m.id, r.log from main m left outer join recs r on r.id = m.id This will output something like: Id log 1log item 1 1log item 2 1log item 3 2another log etc... Thanks, but I want to retrieve only one row for ID field (row from Main table) where the string contains in second table. Something like this: ID Text 1 Sometext 1 2 Sometext 2 6Sometext 3 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Problem with Oracle query
When you say so much rows I am assuming you mean 1 row from MAIN for every row in RECS. If that is true and you just want 1 MAIN row then I would add DISTINCT or EXISTS or IN ... SELECT DISTINCT m.id ,m.text FROM main m ,recs r WHERE m.id = r.id AND r.log like '%sometext%' ORDER BY m.id / Roy A. Jones Rosen [EMAIL PROTECTED] 13-Oct-2006 11:09 To php-db@lists.php.net cc Subject Re: [PHP-DB] Problem with Oracle query [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Try this ... SELECT m.id ,m.text FROM main m ,recs r WHERE m.id = r.id AND r.log like '%sometext%' ORDER BY m.id / Thanks, but this retrieves me so much rows as many are the appearance the 'sometext' in the Recs table Roy A. Jones Rick [EMAIL PROTECTED] 13-Oct-2006 10:53 To php-db@lists.php.net cc Subject Re: [PHP-DB] Problem with Oracle query Brad Bonkoski [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Rosen wrote: Hi, I have a problem with PHP and Oracle SQL query. I have 2 tables : Table Main: --- id number text varchar2(100) Table Recs --- id number pos number log varchar2(200) I need to make query to select a list from first table(Main), where somewhere in the second table (Recs), the log field contains some string. The records for one ID from Main table can be many in table Recs. ( Table Recs acts as log for every row from table Main). Can someone help me with this query? Thanks in advance, Rosen select m.id, r.log from main m left outer join recs r on r.id = m.id This will output something like: Id log 1log item 1 1log item 2 1log item 3 2another log etc... Thanks, but I want to retrieve only one row for ID field (row from Main table) where the string contains in second table. Something like this: ID Text 1 Sometext 1 2 Sometext 2 6Sometext 3 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mysql databases
how would you add something new into a table and take out something old? example: (1) 1st something (2) 2nd something (3) 3rd something (4) 4th something and then you add in something new so then the table would look like (1) new something (2) 1st something (3) 2nd something (4) 3rd something thanks in advance -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql databases
Hi Bob Your question isn't very clear. Do you want to remove the oldest entry, newest, or is there some other criteria to diceide? Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql databases
He means that he wants to use REPLACE and take out the old entry and update it with a new one. Although, you would probably use UPDATE instead. -- Dave W
Re: [PHP-DB] mysql databases
Hi He means that he wants to use REPLACE and take out the old entry and update it with a new one. Although, you would probably use UPDATE instead. Hmmm... Thought this was DB list, not mind-readers. I would also *guess* that would be the intention, but his example seems to remove the newest entry, not the oldest, hence I stopped guessing and asked. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
