Re: asking comment
| From: | Angelo Zanetti | Date: | Wed, 30 Mar 2005 13:17:14 +0000 |
| Subject: | Re: asking comment | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-211867@lists.php.net to get a copy of this message | ||
use a SQL statement to check if that number exists if not then its fine if it does then generate another no and check again, until there is a unique number generated.
hope this helps
angelo
William Stokes wrote:
Hello, I got a bit frustrated with image upload stuff with different image name problems. So I created a system that gives the uploaded imaged a random numeric name between 1-10 000 000 and saves the file to a server folder and the image name to mysql DB. Is there a so sort of a problem here that I am not thinking of? I only can imagine problem that the rand() gives the same value twice. But I cant see this as a major problem because there would be maybe not more than 1000 uploaded pictures. So the chance is at worst something like 1:10 000 that same name is created to the image. Anyway if same name is created what's the best way to check that? I was thinking of putting the image name field in DB as a unique field. That would do it? Right? Thanks again -Will-- Angelo Zanetti Z Logic [c] +27 72 441 3355 [t] +27 21 464 1363 [f] +27 21 464 1371 www.zlogic.co.za