2 question 1=about changing the name of a file being uploaded... 2=about mysql_num_r

dv6cougar

alirght I have a script that I'm using with alot of success.

it's an upload script, not problem is that if someone uploads a file with a %20 in there, it messes up the script i have for showing the pictures and thumbs.

what I need to do is alter the %20 to be something else in the file name when it is upload....

i was gonna try and use this

$read = file_content($directory);

$count = count($read);

$NewName = $count++;

problem is that, it doesn't open the directory and list the content in an array as it should....

Do i have to put something after my $directory?

and then obviously $NewName will be dependent on how many pics are in the folder already.

It's either that or can I do this somehow

$space = "%20";
$NewName = "20";
$space = $NewName;

any ideas?

Only problem with the first one would be that my users would have to upload their thumbnails in the exact order they did the regular sized images, as ImageMagick is not wroking yet, my host hasn't had time at all.

ok quetion #2
in my script I am need to be able to take 2 record types in a field and have it show my results... here's an example...


/*********
//Autumb Orange (BG)
**********/
//1999-2000
$query25 = "SELECT * FROM users WHERE Color='%Autumn%' AND Year='1999' ";
$resultaut = mysql_query($query25);
$resultaut99 = mysql_num_rows($resultaut);
$query27 = "SELECT * FROM users WHERE Color='%Autumn%' AND Year='2000'  ";
$resultaut0 = mysql_query($query27);
$resultaut00 = mysql_num_rows($resultaut0);
$aut00total = "$resultaut99+$resultaut00";

now this is probably something i've over looked but the answer shows up like

0+0... but there are 3 Autumn Oranges with the year 1999.

so A it should be 3+0.... and I would want that to show up as just 3

Thanks all.

jpmoriarty

on that last bit dont include the addition in quotations for a start: just do echo $resultaut99+$resultaut00;

have you tried copying and pasting your query into mysql to check that it is returning the right results - dont forget case sensitivitiy etc which can throw it off from time to time

dv6cougar

Originally posted by jpmoriarty
on that last bit dont include the addition in quotations for a start: just do echo $resultaut99+$resultaut00;

have you tried copying and pasting your query into mysql to check that it is returning the right results - dont forget case sensitivitiy etc which can throw it off from time to time

should be good to go in that, i'll try without the ""

thanks

EDIT THANKS THAT DID WORK 🙂

now to write the rest of this massive script 😃

any help on the first part is greatly appreciated

thanks again