BetterPHP

Just had a quick look at the video, I can't see an IN() statement used?

Hello, I've just been following the "Database Searching" tutorial (http://betterphp.co.uk/playlist.html?pid=EA49AA759BABE5EC) but unfortunately, every search seems to return an empty array. Here is the code for my 'search.inc.php' in the tutorial this was the function file (blog_posts.inc....

I'm currently working on a project which includes your user system but with my image upload system built on top and I had an idea of adding some kind of "tagging" system. For example, if you were to upload an image of say a Lamborghini you'd use the following tags: "Lamborghini, car&q...

Got it! Thank-you so much!

Sure! It all looked the same to me too :/ <?php // checks if the given username exists in the database. function user_exists($user){ $user = mysql_real_escape_string($user); $total = mysql_query("SELECT COUNT(`user_id`) FROM `users` WHERE `user_name` = '{$user}'"); return (mysql_result($to...

$sql = "SELECT
				COUNT(`user_activations`.`user_id`)
			FROM `users`
			INNER JOIN `user_activations`
			ON `users`.`user_id` = `user_activations`.`user_id'
			WHERE `users`.`user_name` = '{$user}'";

I hope this is fine?

-- phpMyAdmin SQL Dump -- version 3.3.9.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Nov 05, 2011 at 04:09 PM -- Server version: 5.0.92 -- PHP Version: 5.2.9 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;...

Unfortunately not, can you point me in the right direction?

Hello, this is was the output:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'users`.`user_name` = 'joe'' at line 5

Hello, I followed the User System tutorial, followed by the Cookie Extension tutorial and everything worked out perfectly. On the Email Activation tutorial [03] I unfortunately came across an error when I'm testing if an account is active or not. Warning: mysql_result(): supplied argument is not a v...