limit uploads

[kiwi2]

How do I go about limiting uploads, I have tried mysql_num_rows error not a valid resource, next, fetch row, now fetch object, can anyone see the fault in my logic(ie no logic here)
$email = $POST['email'];?$con = @mysql_connect("localhost", "$user", "$pass")?or die("Could not connect");?@mysql_select_db($db)?or die("Unable to select");?$query = "SELECT COUNT(*) FROM pixs7 WHERE email = '$email'";?$result = mysql_query($query)?or die ('Error in query: $query. ' . mysql_error());?$row = mysql_fetch_object($result);?$totals = "$row->email";?if ($totals < 5)??{??$title = $POST['title'];?$name = $POST['name'];?$email = $POST['email'];?if(isset($POST['upload']))?{?echo "$FILES[userfile][tmp_name]";?echo "<br />";?$fileName = $FILES['userfile'] ['name'];?$tmpName = $FILES['userfile'] ['tmp_name'];?$fileSize = $FILES['userfile'] ['size'];?$fp = fopen($tmpName, 'r');?$content = fread($fp, $fileSize);?$content = addslashes($content);?fclose($fp);?$picture = str_replace(' ', '', $tmpName);?$source = $picture;?$target ="dir/" . $fileName;?move_uploaded_file( $source, $target );??@mysql_connect(localhost, $username,$password);?@mysql_select_db($database) or die("<b>Unable to specified database</b>");?$query = "INSERT INTO pixs7 (name, email, titles, imagedata) VALUES ('$name', '$email', '$title', '$target')";?@($query) or die ('Error, query failed');?//return insert information to client?$id= mysql_insert_id();?echo "File<b> $fileName</b> uploaded as id= $id<br>";?} ?else ?{ ?echo "Could not complete your request, You already have 8 images in your gallery"; ?} ?} ???>?

[kiwi2]

Weird stuff in this code, sorry I posted it in operamini, hope it is legable.

[ShawnK]

please use

 before your code and 

afterwards it will help us eval your code

[sheephat]

i removed all the question marks and tidyied the code up a bit for all to see

<?php

$email = $_POST['email'];
$con = @mysql_connect("localhost", "$user", "$pass")or die("Could not connect"); 
@mysql_select_db($db)or die("Unable to select");

$query = "SELECT COUNT(*) FROM pixs7 WHERE email = '$email'";
$result = mysql_query($query)or die ('Error in query: $query. ' . mysql_error());
$row = mysql_fetch_object($result);
$totals = "$row->email";

if ($totals < 5)
{
	$title = $_POST['title'];
}

$name = $_POST['name'];
$email = $_POST['email'];

if(isset($_POST['upload']))
{
	echo "$_FILES[userfile][tmp_name]";
	echo "<br />";

$fileName = $_FILES['userfile'] ['name'];
$tmpName = $_FILES['userfile'] ['tmp_name'];
$fileSize = $_FILES['userfile'] ['size'];

$fp = fopen($tmpName, 'r');
$content = fread($fp, $fileSize);
$content = addslashes($content);
fclose($fp);

$picture = str_replace(' ', '_', $tmpName);
$source = $picture;
$target ="dir/" . $fileName;
move_uploaded_file( $source, $target );

@mysql_connect(localhost, $username,$password);
@mysql_select_db($database) or die("<b>Unable to specified database</b>");
$query = "INSERT INTO pixs7 (name, email, titles, imagedata) VALUES ('$name', '$email', '$title', '$target')";
@mysql_query($query) or die ('Error, query failed');
//return insert information to client?$id= mysql_insert_id();?echo "File<b> $fileName</b> uploaded as id= $id<br>";?} ?else ?{ ?echo "Could not complete your request, You already have 8 images in your gallery
}

?>