Paul Cracknell

What is Resource # – PHP MySql

Are your trying to print_r or echo the results of a mysql query to your database and just get resource #10 or resource #5 or something similar. I found this somewhere that may explain the problem.

When you use mysql_query(), it really returns a reference to a result resource, which is parsed by mysql_fetch_* functions. If you directly echo out the resource, PHP just gives you the resource number. You

…

Submit a form with PHP using a href link – php MySql

If you are trying to submit information from a database using a link here is a method I used in a project recently.  This may or may not be the answer to your needs but give it a go.  Just so you know it is manipulating the url like using the $_GET global.

1
2
3
4
5
6
7
8

<?php
  $query = "SELECT id, name FROM folder WHERE 

Connect to your MySql Database with PHP

First thing to do is to create a new php page. Call it db.php and save it this will be the way you connect to the database through this file so that you only need to write this code once.
Paste this code into your new file and save it. You will have to change the username and password as well as the yourdatabaseName. See below for details.

<?php//connect 

WordPress Theme – Tarnished

I was just having a look at themes for a project when I stumbled across this one.  The front page has a slider, meh most premium themes do, but wait until the clip for Tron comes on.  It opens up a whole new area of possibilty for WordPress websites.   Go to the live preview, I like it…

…

WordPress Photography Theme – Picture This

PictureThis is a powerful, premium WordPress theme great for photography and portfolio websites but can also be used for other projects.

• Fullscreen Background Image Slideshow (Upload unlimited images for each page/post/portfolio item)
• Custom Background Image(s) for every page/post/portfolio item
• Choose Your Own Colors With Color Picker
  • Navigation Links Colors/Drop Down Menu Colors
  • Logo Color
  • Text color, link color, headings color (h1, h2, h3)
  • Much more..
• Slideshow Options
  • Slideshow On/Off
  • Display
…

PHP MySQL – Joining tables in PhpMyAdmin

Lets suppose we have a database called Prints with several tables. The two tables we want to join are called ‘prints’ and ‘artists’. When we join the two we will create a new table which we will call ‘printdetails’.

The PRINTS table looks like this:

the ARTISTS table looks like this:

We want to join both tables into one by using  a combination of columns from each table.

From …

Photorific a photography WordPress Theme

If you are a photographer and need a website that will stand out from this rest I think this may be the one.  It is a WordPress theme but it does some really great things with the gallery and the background image.  Take a look as I just can’t do it justice.

It may be me, because I work with WordPress themes but the things that some of these …