ignace

Yep as your username no longer exists

http://dev.mysql.com/doc/refman/5.5/en/dynindex-is.html

Load your image through PHP that way you can add additional headers to expire the image instead of not caching the entire page. EDIT: apparently that doesn't work in all browsers use their_username.jpg?<?php print time(); ?> EDIT 2: Google doesn't like this their_username-<timestamp>.jpg

$image->output(); should be: $image->save('path/to/file'); EDIT: jcbones beat me to it

name="products[$ID]" then when the user presses UPDATE you go over each item and check if the quantity has changed if it did then modify it in your database. $_SESSION['cart_namespace'][$productID] = $row;

Try to update the field and set it's value explicit to NULL

I must be getting blind (or really tired) I didn't even see this line

REGEX is IMO to much overhead for something this simple

Maybe you can take an alternative path as it feels somehow wrong to let a validation class pull records from a database. How about whitelisting? Like below: $subscribed = $usersTable->findBySubscriptionStatus('subscribed');//this line alone should give you the e-mails you need. if (sizeof($subscribed)) { $validEmail = new ValidateEmail(); if ($validEmail->massValidate($subscribed)) {//all e-mails

SELECT * FROM room WHERE r_roomtypeID = $rtID ORDER BY rand() LIMIT 1 or SELECT * FROM room r, roomtype rt WHERE rt.roomtypeID = r.r_roomtypeID AND rt.roomtypeID = $rtID ORDER BY rand() LIMIT 1 I prefer the first

A DBMS already has tables to manage users and to control access to it's resources (databases, tables, views, procedures, ..) Take a look at the information_schema database

Add a field subscription_status VARCHAR(12) which can hold (subscribed, unsubscribed, pending, renewed, ..) probably don't need no explanation

That is because your decimal field currently has NOT NULL change it to NULL that way it allows you to have NULL as a value

Keep coming here and you soon will be My motto: learn from the mistakes of others as you can't make them all yourself Visiting these forums made me a wise man

A class in PHP is always global you can access it - once declared - everywhere.

You probably meant without refreshing the entire page as you can switch stylesheet without leaving the page using PHP

SELECT * FROM m$selected ORDER BY rand() LIMIT 1

Just pass it to the constructor Edit: why does a validation class need access to the database?

$to = str_replace(array('(', ')', '-'), '', $to);

A simple google search learned http://www.mkyong.com/mysql/how-to-modify-the-max_questions-resource-value-in-mysql/

I assumed you already created a connection to the database and you only wanted to verify if a certain database exists, NOT apparently. Use: $connection = mysql_connect($cfg['host'], $cfg['username'], $cfg['password']); if (!$connection) { header('Location: install/index.php'); }

Please post your code in its entirety

I'm just saying that having the same information (username) scattered across the database is a bad idea much more so when a simpler solution is at hand

if($checkUser == '0' || $Password != $checkUserInfo[Password]) { $errors[] = "Username or Password is incorrect"; } Should do the trick

You can also use buttons <button type="submit" name="state" value="1">Kansas</button>