Thread

I’m still wrestling with the issues described in the unanswered post “tables in database” posted 14 hrs ago. My background is dbase, FoxPro, Access, and I can do almost anything there, but the basic interface of SQL eludes me. The databases, tables, arrays, and variables seem invisible, with no way to view them, or even find they exist, except by manually searching through the code.  Someone please lend me a hand.  Thanks JB

Hi johnnyb,

Can you please give me an example of what it is that you’re trying to do or understand? What do you mean by the ‘basic interface of SQL’?

Cheers

Greg

Hi Greg. Please see my earlier referenced post “tables in database,” where I’ve already received some help. The basic problem is some glitch in our php/sql shopping cart, and the code is referenced there. 

What would help is a global search for a term in all code on the site. If I could find all instances of the variable $theprice, or even of the number 150 (the price that keeps coming up in the cart, no matter how I change it in the algorithm, I’d find the error quickly. Is there a way to do such a global CODE search?

Re: basic interface: I was raised on dBase, where you could easily get information not only out of, but ABOUT databases tables, and variables using the “list” command.  Finding out how to do that in SQL has been a task. E.g., it took a long time to discover the command DESC - equivalent to “List Structure” in dBase.  And I still don’t know how to list variables globally.

johnnyb,

This really is something that we can’t support. But we have the perfect forum for this in the CodeShare Corner where I am moving this thread.

What would help is a global search for a term in all code on the site. If I could find all instances of the variable $theprice, or even of the number 150 (the price that keeps coming up in the cart, no matter how I change it in the algorithm, I’d find the error quickly. Is there a way to do such a global CODE search?

Not in EE but a number of text editors let you search through files and folders for text strings. I’m on a PC and use E text editor for example

If you are searching your db then use something like phpMyAdmin which allows search easily like Sue suggests

If all these issues you are having are from a legacy shopping cart then maybe switching to an EE based cart might be more in your favour than the learning curve and troubleshooting you are doing at the moment. 2 are available. Cartthrob and BrilliantRetail

If you wish to improve your understanding of MySQL Lynda has some great courses