Extra Fields....

[carpenoctem]

is there a way for me to run a script that will show me if there are any products that do not have anything listing in the Extra Fields?

 

I have several thousand products... and it is not time efficient to click on EVERY product to see if I have added the necessary information, and I am sure that along the way I have missed some products.

 

Thanks for your help

[♥geoffreywalton]

Use phpmyadmin

 

select your db

Select the table that has this field in it

Select the search tab

 

Seach as required.

 

That gives you products where you hace set up a record and not entered some data.

 

Have you got any products where there are no records set up to even store the data in?

 

If so, you need a sql statement to find all product where the key fileld on the file containing these extras fields is null.

[♥geoffreywalton]

This gives you the sysntax you need.

 

SELECT CarIndex FROM DealerCatalog LEFT JOIN BigCatalog ON DealerCatalog.CarIndex=BigCatalog.CarIndex WHERE BigCatalog.CarIndex IS NULL

 

For more info try

 

http://dev.mysql.com/doc/refman/5.0/en/select.html

[western]

Hi, I'm trying to improve osCommerce advanced search to search customers in my site.

 

Please, can you give me any suggestions?

 

I'm reading a lot of books and forums, but nobody seems to have solutions for me.

 

I can reset and improve html sites . For example i can modifies any kind of html site, by css or adding Javascrits or similar, make any changes for the Dreamweawer template, aligned text, images and so on. Html have almost no secret for me. Php and Mysql it's rather quite a prolblem. I'm still studying them (also I'm studying English, as you can see in this post)

 

I hope you can help. I don't find anywhere in this site how can I set tables join ("c." is for customers, I'm sure) i think that for Extra Filed (I have some of them) I have to use "e." but I need help to do, or at least some suggestions to make it My purpose is have an advanced search between customers, using also customers extra fields that I put in create_customer.php, using the contrib.

 

Thanks for your help

[♥geoffreywalton]

This site does not support how to write SQL

 

Try http://www.w3schools.com/php/php_mysql_select.asp for an introduction to to MySQL.

 

and http://uk.php.net/tut.php for more info.

 

The letter denoting a table has no relational significance to the name, it just needs to be unique

[western]

Try http://www.w3schools.com/php/php_mysql_select.asp for an introduction to to MySQL.

 

and http://uk.php.net/tut.php for more info.

 

The letter denoting a table has no relational significance to the name, it just needs to be unique

 

Really thank you. This is one of the more important the information I was searching for, to write by myself search code I need. As soon as I'll finish it, I will put contrib in this site. :lol:

[♥geoffreywalton]

buona fortuna, vi avete molte ore felici

 

(good luck, you have many happy hours ahead of you)

[western]

:lol: Thank you!