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 Chriss Miller 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. pgferro

    Complex pivoting..

    Thanks ! I have to loop through the set, but it gets the job done !
  2. pgferro

    Complex pivoting..

    Hi Guys, this is a tough one, for me... I'm working on a ecommerce db migration, this is the basic structure : description price image category subcategory1 subcategory2 subcategory3 subcategory4 subcategory5 There are 8,000 records, 6,000 of which are same items present in different...
  3. pgferro

    Simple Array question....

    Well, I thought my question was pretty straightforward, but evidently it was not. I was looking for a way to store data in php and be able to display with $whatever->whatever format. I thought (wrongly) this was probably in relation to some array manipulation, hence the subject line. I also...
  4. pgferro

    Simple Array question....

    I understand that, but my question was : how do i populate an array (or object) to use "echo $client->name;" format. That means that i prefer to use that structure for reasons too long to explain.... Wanna give the best answer ? Check the question ! :-) -- PG
  5. pgferro

    Simple Array question....

    Hey Tanstaafl, tried both method and i do not get anything outputted when : echo $client->name; Any idea ? -- PG
  6. pgferro

    Simple Array question....

    Hi, How can I populate an array so that i could use it this way : echo $client->name echo $client->phone etc etc ?? The array will be populated manually. Thanks !! -- PG
    • pgferro
    • Thread
    • Replies: 6
    • Forum: PHP
  7. pgferro

    how to convert documents to pdf format using php

    If you're on a win environment, try this : http://www.goermezer.de/pdf-converter-server/servpdf---ein-webbasierter-pdf-server-fur-microsoft-office.html Let me know... -- PG
  8. pgferro

    SELECT issue

    If you want to stick at all cost with mysql_query : $result = mysql_query("SELECT * FROM users WHERE username = '$username' AND password='$password'"); if ($result) { echo "your signed in"; } else { echo "oops! wrong password"; } Of course you should validate the username and password...
  9. pgferro

    Advise on large table indexing

    Thanks Eric. -- PG
  10. pgferro

    Advise on large table indexing

    Thanks Eric ! What would you consider the lowest variance threshold for considering indexing ? Another question, you say that the optimizer will use the indexes first than the table scan, should the query be constructed accordingly (with a specific order in the WHERE clause) to improve...
  11. pgferro

    Advise on large table indexing

    Hi Guys, I have a large (50 million records) demographic table, normalized, with about 10 searcheable fields (annual income, number of children, etc etc) all searchable fields are id's related to smaller tables. The query I will run against the db is a classic multiple options choice : Income...
  12. pgferro

    Help with subquery MySql

    Yes, I have.
  13. pgferro

    Help with subquery MySql

    Hi guys, Can somebody help me transform this subquery in a prior 4.1 version ? SELECT name, contact FROM contact WHERE contact NOT IN ( SELECT contact FROM contact_to_students WHERE student = whatever_id ) Appreciate the help ! -- PG
    • pgferro
    • Thread
    • Replies: 2
    • Forum: PHP
  14. pgferro

    SELECT help...

    The subquery would look like : SELECT name, contact FROM contact WHERE contact NOT IN ( SELECT contact FROM contact_to_students WHERE student = whatever_id )
  15. pgferro

    SELECT help...

    Tony, Thanks again. Always no results... Maybe you got confused by the table example, which would be more like : ContactID ContactStudentId 1 125 1 158 2 158 3 140 Thanks again for your time -- PG
  16. pgferro

    SELECT help...

    Tony, I understand you are using just one table, how can I fit the query to my example ? Sorry... I'm aware that I have big limits.. Thanks ! -- PG
  17. pgferro

    SELECT help...

    Thanks Tony, You are right, it is not very clear.. There are 2 tables 1 is contact_to_students (example above) 2 is contact_bio (with name address etc) Goal is to get the names of contacts 2 and 3 (always based on the above example) There is no Null value Thanks -- PG
  18. pgferro

    SELECT help...

    I have two tables : students and contacts Contacts can be related to several students and viceversa I'm trying to come up with a select (prior 4.1) that will allow me to choose a contact which is not related to a particular student, but also not related to any other student. Contact table...
  19. pgferro

    Simple validation question

    Thanks ! It did the trick ! -- PG
  20. pgferro

    Simple validation question

    Hi guys, I know this sound trivial, but I cannot find a way to do this simple task. I have a form which is repeated in various pages with different values, and only one text field. In the same page (php) the same form is double, with a different name in case it is an update or a add action in...

Part and Inventory Search

Back
Top