Blogs

MYSQL Joins are confusing, to say the least. I was successfully able to do one a few different ways and thought it be best to write down how I did it so I can do it in the future.

What I had was two different tables. One table was xcart_products_categories which stores all "productid" and matches them with which category they go to "categoryid". The other table which was xcart_products had the “productid” and all of its information.

When you run a recordset through a loop, you will not be able to re-run the recordset further down in the same page. Here is how to reset the recordset so you can use it again on the same page. Just place this code after your loop. Change the "$Recordset" to your recordset's variable.

If you have ever had problems getting a nice deep black with Adobe Illustrator, you’re not the only one. When generating pdfs if you have your standard black color set to #000000 your black may come off a little different than expected, it will loose its richness and not be true black.

To get a true rich black in Adobe Illustrator, use the following:

Cyan: 50
Magenta: 40
Yellow: 40
Black: 100

With PHP you can recognize the page you are on and then display a proper header for that page.

For example:

Looping comes in handy when you may want to execute a certain script "x" number of times or if you want to display all the information within a Recordset. Here is an example of how I display all the information stored within a Recordset into a nice table that is easy to read.

Recordsets in PHP are useful bits of code used to display data that is stored within a MYSQL table. You can run a loop to display all of this data or you can display only the bit of information you want. Here is how I do this: