[Fwd: Re: Deleting Data but Value Still Present]

-------- Original Message --------
Subject: Re: Deleting Data but Value Still Present
Date: Mon, 28 Mar 2005 15:24:31 -0600
From: Wade
To: randy@novaspace.com
References: <424871EF.3000206@wadesmart.com>
<20050328141943.2125692369.randy@novaspace.com>



03282005 1521 GMT-6

I deleted all the rows in the user table through the MySQL Control
Center app. Im testing for right now.

But my php script was pretty simple:
$sql ="SELECT username FROM users WHERE username = ' " .
$_POST['user_name'] . " ' ";
$result = mysql_query($sql, $connection);
while ( $row = mysql_fetch_array($result) ) {
$username = $row['username'];
}

if ( $username == $_POST['user_name'] ) {
$problemR = TRUE;
$errorR[] = 'That username is already in use. Please
pick another!';
}

At first it was saying that the user name was still present even when
there were new records in the db.

Wade




Randy Clamons wrote:

>Can you give a little more info abou this? Any code samples?
>
>Randy Clamons
>Systems Programming
>Novaspace.com
>
>
>
>
>>------------Original Message------------
>>From: Wade
>>To: "MySQL Win32 List"
>>Date: Mon, Mar-28-2005 2:08 PM
>>Subject: Deleting Data but Value Still Present
>>
>>03282005 1505 GMT-6
>>
>>I have deleted some data out of the db and when I try to enter new
>>data,
>>when my script checks to see if the data is already present, it still
>>says it is even when it is not.
>>
>>How do I get around this?
>>
>>Wade
>>
>>--
>>MySQL Windows Mailing List
>>For list archives: http://lists.mysql.com/win32
>>To unsubscribe:
>>http://lists.mysql.com/win32?unsub=randy@novaspace.com
>>
>>
>>
>>
>
>
>
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org