Page 2 of 2

Posted: Wed Nov 26, 2003 5:54 pm
by mchaggis
Sorry please replace db_query with mysql_query

I use a db wrapper and habits are hard to break ;)

Posted: Wed Nov 26, 2003 6:14 pm
by charmedp3
Now i got this error

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'user Username,Password,Email,Name,Age,Sex,Hobbies' at line 1
===============================================

can someone check my edit.php and register.php(written by friend. IT IS WORKING PERFECTLY. Please check the variables for register.php and wat to put in edit.php)

edit.php

Code: Select all

<? session_start(); ?>
<?php include "header.php"; ?>
<?
// Global settings, please change these

$dbserver="127.0.0.1";		// Server to connect to, leave this unchanged
$dbuser="charmed_bhs";	// Username, change this to whatever you need
$dbpass="123	// Same for pass
$db="charmed_bhs";		// Database name, u need to change this


// End settings
mysql_connect($dbserver,$dbuser,$dbpass);
mysql_select_db($db); 
$sql = "SELECT * user Username,Password,Email,Name,Age,Sex,Hobbies";

$res = mysql_query($sql) or die(mysql_error());

while ($row = mysql_fetch_array($res)) { 


$Username = $row['username']; 
$Password = $row['password']; 
$Email = $row['email']; 
$Name = $row['name']; 
$Age = $row['age']; 
$hobbies = $row['hobbies']; 

} 
?> 
<html> 
<head> 
<title>adad</title> 
</head> 
<body> 

<form method="POST" ACTION="editpro.php"> 

<p>Username : <input type="text" NAME="username" VALUE =" <? echo $username; ?>" size=35 maxlength=50></p> 

<p>Password : <input type="text" NAME="password" VALUE ="<? echo $password; ?>" size=35 maxlength=50></p> 
<p>Email : <input type="text" NAME="email" VALUE ="<? echo $email; ?>" size=35 maxlength=50></p> 
<p>Name : <input type="text" NAME="name" VALUE ="<? echo $name; ?>" size=35 maxlength=50></p> 
<p>Age : <input type="text" NAME="age" VALUE ="<? echo $age; ?>" size=35 maxlength=50></p> 
<p>Hobbies : <input type="text" NAME="hobbies" VALUE ="<? echo $hobbies; ?>" size=35 maxlength=50></p> 
<br><br> 
<input type="Submit" name="submit" VALUE="Update Profile"><br><br> 
</form> 
</body> 
</html> 

<?php include "end.php"; ?>
===============================================

register.php (written by friend)

Code: Select all

<?php include "header.php"; ?>
<font face="verdana" size="2"><br><center><b>All BHS member, please register now to use our member access area.<br></b></font></center><br>
<?php



// Global settings, please change these

$dbserver="127.0.0.1";		// Server to connect to, leave this unchanged
$dbuser="charmed_bhs";	// Username, change this to whatever you need
$dbpass="123";		// Same for pass
$db="charmed_bhs";		// Database name, u need to change this


// End settings


if($_POST['check']=="Register"){
mysql_connect($dbserver,$dbuser,$dbpass);
mysql_select_db($db);
$_SESSION['myuser']=$username;$_SESSION['mypass']=$password;$_SESSION['myemail']=$email;$_SESSION['myname']=$myname;$_SESSION['myage']=$age;$_SESSION['myhobbies']=$hobbies;
if (!$username) {echo "<font face=verdana size=2>You did not provide a username!<br></font>"; $signup="no";}
if (!$password) {echo "<font face=verdana size=2>You did not provide a password!<br></font>"; $signup="no";}
if (!$email) {echo "<font face=verdana size=2>You did not provide a email address!<br></font>"; $signup="no";}
if (!$name) {echo "<font face=verdana size=2>You did not enter your name!<br></font>"; $signup="no";}
if (!$age) {echo "<font face=verdana size=2>You did not enter your age!<br></font>"; $signup="no";}
if (!$hobbies) {echo "<font face=verdana size=2>You did not enter your hobbies!</font>"; $signup="no";}
if ($signup=="no"){echo "<font face=verdana size=2><br><br><--<a href=register.php>Go</a> back and try again</font>";}
else {
$query="SELECT * FROM users WHERE username='$username'";
$result=mysql_query($query); $num_rows = mysql_num_rows($result);
if ($num_rows!="0"){mysql_close(); echo "<br><center><font face=verdana size=2>User exists.<br><br>Please go [<a href=./register.php>back</a>] and try again</font></center>";}
else {
mysql_query("INSERT INTO users (Username,Password,Email,Name,Age,Sex,Hobbies) VALUES ( '$username','$password','$email','$name','$age','$sex','$hobbies')"); mysql_close();
echo "<br><br><center><font face=verdana size=2>Username '$username' has been successfully added to our member database.<br>Thank you for verifying as a member of BHS<br></font><br>";}}}
// Form code
else{
echo "<form action=register.php method=post><font face=verdana size=2>Username : </font><input type=text name=username value=$myuser><font face=verdana size=2><br>Password : </font><input type=password name=password value=$mypass><font face=verdana size=2><br>Email : </font><input type=text name=email value=$myemail><font face=verdana size=2><br>Name : </font><input type=text name=name value=$myname><font face=verdana size=2><br>Age : </font><input type=text name=age value=$myage><font face=verdana size=2><br>Sex : </font><select name=sex><option>Male</option><option>Female</option></select><font face=verdana size=2><br>Hobbies : </font><input type=text name=hobbies value=$myhobbies><br><br><input type=submit name=check value=Register><input type=reset value=Reset name=reset></form>";}


?>
<?php include "end.php"; ?>

Posted: Wed Nov 26, 2003 6:24 pm
by mchaggis
I belive the problem is with your SQL:

Code: Select all

$sql = "SELECT * user Username,Password,Email,Name,Age,Sex,Hobbies";
Try:

Code: Select all

$sql = "SELECT * FROM user";
Or

Code: Select all

$sql = "SELECT Username,Password,Email,Name,Age,Sex,Hobbies FROM user";

Posted: Wed Nov 26, 2003 7:10 pm
by charmedp3
i tried both and it gives me this error.


Table 'charmed_bhs.user' doesn't exist