You have a double ; in your $check at the end.
//check if the username is taken
$check = "SELECT id from registration WHERE username =
'".$POST ['username']."';";
I think it should be:
'".$POST ['username']."'";
Sincerely,
Mike
--
Mike Brandonisio * IT Planning & Support
Tech One Illustration * Database Applications
tel (630) 759-9283 * e-Commerce
[EMAIL PROTECTED] * www.techoneillustration.com
On Apr 19, 2006, at 6:25 AM, Olunkwa Ikechukwu wrote:
> Hello Everyone
> It's me Iyke
> I need your help on a script, its supposed to collect user
> registration and store in mysql database.
> but I get
> Parse error: parse error, unexpected T_STRING in /home/
> public_html/register.php on line 30
> Here's the code
> ================================
> <?
> include ("password.php");
> include ("db_connect.php");
> $username=$_POST ['username'];
> $email=$_POST ['email'];
> $password=$_POST ['password'];
> $first=$_POST ['first'];
> $family=$_POST ['family'];
> $gender=$_POST ['gender'];
> $birth=$_POST ['birth'];
> $address=$_POST ['address'];
> $city=$_POST ['city'];
> $state=$_POST ['state'];
> $country=$_POST ['country'];
> $phone=$_POST ['phone'];
>
> //check if the username is taken
> $check = "SELECT id from registration WHERE username =
> '".$POST ['username']."';";
> $qry = mysql_query ($check) or die ("Could not match data
> because '.mysql_error() );
> $num_rows = mysql_num_rows ($qry);
> if ($num_rows !=0)
> {
> // i think below shoul be the line 30
> echo "sorry, The Username $username is already
> taken.<br>";
> echo "<a href="" Again</a>";
> exit;
> }else{
> //insert data
> $query='INSERT INTO registration VALUES (",
> '$username','$email', '$password','$first', '$family','$gender',
> '$birth', '$address', '$city', '$state', '$country','$phone')";
> mysql_query($query);
> }
> mysql_close();
> echo "We will contact you with Your Account Information
> and Login Page";
> ?>
>
> ================================
>
>
>
> I am a Sun, impatiently waiting for dawn.
>
>
>
>
>
>
>
>
> ---------------------------------
> Blab-away for as little as 1ยข/min. Make PC-to-Phone Calls using
> Yahoo! Messenger with Voice.
>
> [Non-text portions of this message have been removed]
>
>
>
> Community email addresses:
> Post message: [email protected]
> Subscribe: [EMAIL PROTECTED]
> Unsubscribe: [EMAIL PROTECTED]
> List owner: [EMAIL PROTECTED]
>
> Shortcut URL to this page:
> http://groups.yahoo.com/group/php-list
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
SPONSORED LINKS
| Php mysql | Job postings |
YAHOO! GROUPS LINKS
- Visit your group "php-list" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
