Why "INSERT" not working on MySQL?

[web_designer_iq]

Hello
I have a code that allows the admin. to generating cards. But it's not working correctly! It's not generate the "num" value as i need. For example when i enter 10 it's generate 3 card. That's means "MySQL Insert" not working correctly!
Any idea please?

	$i = 0;

		while($i < $num)
		{

			$rand 	= rand(1000000000,9999999999);

			$sql	 = mysql_query("
			INSERT INTO cards_tmp SET
					cardNumber	=	'$rand',
					isUsed		=	'n'
			");

			$cardsList .= "<tr><td>$rand</td></tr>";

			$i++;
		}

[NogDog]

Try checking if $sql is false after the call to mysql_query(), and if so, echo mysql_error() to find out what's wrong.

[jeremyphphaven]

Like NogDog says... here's some code you can append to the mysql_query that will stop and output the error if the query fails

$sql     = mysql_query(" 
                INSERT INTO cards_tmp SET 
                        cardNumber    =    '$rand', 
                        isUsed        =    'n' 
                ") or die(mysql_error());