Search results for query: *

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

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...

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...

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

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

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

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

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...

Thanks Eric. -- PG

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...

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...

Yes, I have.

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

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

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

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

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

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...

Thanks ! It did the trick ! -- PG

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...