Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Recordsetclown

    How to limit this insert

    This table is where fields defined by the user are stored. Every field is a row within the table, with column headings of field_name, field_value, listingsdbelements_id (auto-incremented), listingsdb_id, and user_id. The application deals with real estate listings, so fields might be number...
  2. Recordsetclown

    How to limit this insert

    Actually, no. I found lots of references to unique constraint, but none that looked like they explain your suggestion. At any rate, thanks for your reply.
  3. Recordsetclown

    How to limit this insert

    Thanks for your reply. I may have misunderstood though, as the target table might already have 30 rows with the same listingsdb_id. I'm not understanding the unique constraint.
  4. Recordsetclown

    How to limit this insert

    Hi, I want to insert one row per each value of listingsdb_id into a table with the following fields: field_name, field_value, listingsdbelements_id, listingsdb_id, user_id There are an unknown and variable number of rows already in this table for each unique listingsdb_id. I've tried the...
  5. Recordsetclown

    Update query

    I am stumped as to how to make this work. I have the following elements: UPDATE default_en_listingsdb as r1 INNER JOIN default_en_listingsdbelements as r2 ON r2.listingsdb_id = r1.listingsdb_id AND r2.listingsdbelements_field_name = 'MLSID' AND r2.listingsdbelements_field_value...
  6. Recordsetclown

    How to get array outside of while loop?

    Thanks very much folks. As Feherke says, jpadie's code showed me the problem. When I ran my code, I saw numbers 2 through 7, which are from a mysql column named userdb_id. I would either test the value of $data[2] outside the loop or assign the value of $data[$i] to another array within the...
  7. Recordsetclown

    How to get array outside of while loop?

    I need to save the results outside the while loop somehow, but $data[$i] apparently retains no value once while is complete.
  8. Recordsetclown

    How to get array outside of while loop?

    I'm new to PHP programming and am having trouble with variable scope. If I echo the value of $data within the following loop, I get the expected values. How can I transfer those values to an array that I can access outside the loop? while ($data = mysql_fetch_array($result)) { for ($i=0...
  9. Recordsetclown

    cron permissions

    OK, thanks very much.
  10. Recordsetclown

    cron permissions

    When I run a php program from its gui interface, it operates correctly. When run from cron, it works properly except that it fails to unlink and rewrite a batch configuration file (to update the last date/time run) saying permission denied. Can anyone tell me how to get a this to run with my...
  11. Recordsetclown

    Dynamic web page - character replace help

    Thanks very much for your help. That gives me some ideas to consider.
  12. Recordsetclown

    Dynamic web page - character replace help

    The information is stored in the db as a pipe-separated text field. The program formats it to a bullet list, which is fine for the area it is intended for. If I put that field on another page, it gets no formatting. There are several such fields. The output buffer sounds promising since I...
  13. Recordsetclown

    Dynamic web page - character replace help

    Hi, I'm new to php programming and am looking for ideas. I am working with a program that generates web pages from database information using templated forms. Some of the database fields contain options that are formatted as a bulleted list in certain areas of the page, but as pipe separated...
  14. Recordsetclown

    Update syntax

    Thanks very much. I shouldn't have quoted the price value - that seems to be why I got just a few records. The update worked just as I wanted.
  15. Recordsetclown

    Update syntax

    Yes, or ... Substituting join in all instances finds few rows - I thought too few - but they meet all the criteria, where the other appears to include rows that meet some but not all.
  16. Recordsetclown

    Update syntax

    The column to be updated is in r1. There is one row per listing in both r1 and r4, and many rows with various field names in the other table.
  17. Recordsetclown

    Update syntax

    I want to change the listingsdb_featured value for records returned by this query to 'yes'. I was hoping to use update, but haven't found a working syntax. Can anyone assist? SELECT listingsdb_featured from default_en_listingsdb as r1 LEFT OUTER JOIN default_classlistingsdb as r4 ON...
  18. Recordsetclown

    Date/time conversion problem

    I would like to display the latest UTC date/time value in my db as the date/time it would have been in my time zone. The following returns null. Can anyone tell me what is wrong with the query. Perhaps it is that I'm not referencing the time zones correctly, but I couldn't find how to...
  19. Recordsetclown

    How to finish this query?

    Hi, The primary key for this table is an auto-incremented field called listingsdbelements_id. I want to concatenate (streetnumber,streetdirection,streetname,streetsuffix)from the following query into an address field. I was looking at...
  20. Recordsetclown

    How to reference field names in this query

    When I looked again at the table, I saw that r# joined r1 on listingsdbelements_id rather than listingsdb_id. With that changed, it worked fine. Thanks again.

Part and Inventory Search

Back
Top