Jump to content
Sign in to follow this  
carpenoctem

Extra Fields....

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.


Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites

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


Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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


Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites
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:

Share this post


Link to post
Share on other sites

buona fortuna, vi avete molte ore felici

 

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


Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×