Помогнете!!!!

Статус
Not open for further replies.
M

macmen

Registered
Значи имам следния проблем.
Създадох LOGIN система при нея няма никакав проблем.
Обаче когато искам да извадя информацията от базата данни ми дава грешка
ето тази:
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 'where `id` = ''' at line 6
абе аз ли сам глупав или не мога да разбера каква е грешката.


Ето скипта:

това е за myprofile.php той е копиран от друг скрипт.



<?
include 'dbc.php';
$qData = "SELECT * FROM `users` where `id` = '$_SESSION[id]'";
$rData = mysql_query($qData) or die(mysql_error());
if(mysql_num_rows($rData) == '1')
{
echo "<br><center><b>No record found in database.</b></center>";
}
else
{
$aData = mysql_fetch_array($rData);














echo"<center><h2>My Profile</h2>";



echo'<table border="0" width="60%">';
echo "<tr>
<td width=\"100%\" class=\"tdbrown\" valign=\"top\" colspan=\"2\"></td>
</tr>";

echo"<tr>
<td width=\"30%\" class=\"tdlightbrown\" valign=\"top\" style=\"padding-left:3px\"><strong>Username:</strong></td>
<td width=\"70%\" class=\"tdlightbrown\" valign=\"top\" style=\"padding-left:3px\">$aData[User_name]</td>
</tr>";
echo"<tr>
<td width=\"30%\" class=\"tdlightbrown\" valign=\"top\" style=\"padding-left:3px\"><strong>Password:</strong></td>
<td width=\"70%\" class=\"tdlightbrown\" valign=\"top\" style=\"padding-left:3px\">$aData[Password]</td>
</tr>";
echo"<tr>
<td width=\"30%\" class=\"tdlightbrown\" valign=\"top\" style=\"padding-left:3px\"><strong>First Name:</strong></td>
<td width=\"70%\" class=\"tdlightbrown\" valign=\"top\" style=\"padding-left:3px\">$aData[full_Name]</td>
</tr>";
echo"<tr>
<td width=\"30%\" class=\"tdlightbrown\" valign=\"top\" style=\"padding-left:3px\"><strong>Last Name:</strong></td>
<td width=\"70%\" class=\"tdlightbrown\" valign=\"top\" style=\"padding-left:3px\">$aData[user_familiq]</td>
</tr>";
echo"<tr>
<td width=\"30%\" class=\"tdlightbrown\" valign=\"top\" style=\"padding-left:3px\"><strong>Email Address:</strong></td>
<td width=\"70%\" class=\"tdlightbrown\" valign=\"top\" style=\"padding-left:3px\">$aData[user_email]</td>
</tr>";
echo"<tr>
<td width=\"30%\" class=\"tdlightbrown\" valign=\"top\" style=\"padding-left:3px\"><strong>City:</strong></td>
<td width=\"70%\" class=\"tdlightbrown\" valign=\"top\" style=\"padding-left:3px\">$aData[City]</td>
</tr>";
echo"<tr>
<td width=\"30%\" class=\"tdlightbrown\" valign=\"top\" style=\"padding-left:3px\"><strong>Zip Code:</strong></td>
<td width=\"70%\" class=\"tdlightbrown\" valign=\"top\" style=\"padding-left:3px\">$aData[Zip_Code]</td>
</tr>";
echo"<tr>
<td width=\"30%\" class=\"tdlightbrown\" valign=\"top\" style=\"padding-left:3px\"><strong>State:</strong></td>
<td width=\"70%\" class=\"tdlightbrown\" valign=\"top\" style=\"padding-left:3px\">$aData[State]</td>
</tr>";
echo"<tr>
<td width=\"30%\" class=\"tdlightbrown\" valign=\"top\" style=\"padding-left:3px\"><strong>Country:</strong></td>
<td width=\"70%\" class=\"tdlightbrown\" valign=\"top\" style=\"padding-left:3px\">$aData[Country]</td>
</tr>";


echo'</table><br><br><a href="editprofile.php">Edit Profile</a></center>';
}

?>



това е за editmyprofile.php


<?
include"dbc.php";
$qData = "select * from `users` where `id` = '$_SESSION[id]'";
$rData = mysql_query($qData) or die(mysql_error());
if(mysql_num_rows($rData) == '1')
{
echo (`<br><center><b>No record found in database.</b></center>`);
}
else
{
$aData = mysql_fetch_array($rData);
if(isset($_POST[Are]))
{
$Username = $_POST[Username];
$full_name = $_POST[First_Name];
$user_familiq = $_POST[user_familiq];
$user_email = $_POST[user_email];





$q1 = "update `users` set
`full_name` = '$First_Name' ,
`user_familiq` = '$user_familiq' ,
`Email_Address` = '$user_email ' ,

where `id` = '$_SESSION[id]'";
mysql_query($q1) or die(mysql_error());

header("location:myprofile.php");
}
else
{




if($aData[Status] == Active)
{
$CheckedStatus0 = "checked";
}
elseif($aData[Status] == Suspend)
{
$CheckedStatus1 = "checked";
}


?>



<script language="JavaScript">
function usersignup(theForm)
{



if (theForm.First_Name.value == "")
{
alert("Please enter your First Name.");
theForm.First_Name.focus();
return (false);
}

if (theForm.Last_Name.value == "")
{
alert("Please enter your Last Name.");
theForm.Last_Name.focus();
return (false);
}

if (theForm.Email_Address.value == "")
{
alert("Please enter your Email Address.");
theForm.Email_Address.focus();
return (false);
}

var checkEmail = "@.";
var checkStr = theForm.Email_Address.value;
var EmailValid = false;
var EmailAt = false;
var EmailPeriod = false;
for (i = 0; i < checkStr.length; i++)
{
ch = checkStr.charAt(i);
for (j = 0; j < checkEmail.length; j++)
{
if (ch == checkEmail.charAt(j) && ch == "@")
EmailAt = true;
if (ch == checkEmail.charAt(j) && ch == ".")
EmailPeriod = true;
if (EmailAt && EmailPeriod)
break;
if (j == checkEmail.length)
break;
}

if (EmailAt && EmailPeriod)
{
EmailValid = true
break;
}
}
if (!EmailValid)
{
alert("Please enter Valid Email Address");
theForm.Email_Address.focus();
return (false);
}

if (theForm.City.value == "")
{
alert("Please enter your City.");
theForm.City.focus();
return (false);
}

if (theForm.Zip_Code.value == "")
{
alert("Please enter your Zip Code.");
theForm.Zip_Code.focus();
return (false);
}

if (theForm.State.value == "")
{
alert("Please enter your State.");
theForm.State.focus();
return (false);
}

if (theForm.Country.value == "")
{
alert("Please enter your Country.");
theForm.Country.focus();
return (false);
}
}
</script>

<center>
<h2>Edit profile</h2>
<form name="form1" method="POST" enctype="multipart/form-data" action="editprofile.php" onsubmit="return usersignup(this)">
<table border="0" width="400">


<tr>
<td width="252">First Name:</td>
<td width="549"><input type="text" name="First_Name" size="15" value="<?=$aData[full_name]?>" maxlength="50"></td>
</tr>

<tr>
<td width="252">Last Name:</td>
<td width="549"><input type="text" name="Last_Name" size="15" value="<?=$aData[user_familiq]?>" maxlength="50"></td>
</tr>

<tr>
<td width="252">Email Address:</td>
<td width="549"><input type="text" name="Email_Address" size="25" value="<?=$aData[user_email]?>" maxlength="150"></td>
</tr>




<tr>
<td width="252"> </td>
<td width="549"> </td>
</tr>
<tr>
<td width="252"> </td>
<td width="549"><input type="submit" value="Save Changes" name="Are"></td>
</tr>

</table>
</form>
</center>

<?

}
}
?>



благодаря предварително !!!!!
 
На първо четене:

...use near 'where `id` = '''

т.е. подаваш празна стойност за id.

Онова, което виждам веднага още в първата ти заявка е грешка в изписването на сесийния масив:

$_SESSION[id]

трябва да е:

$_SESSION['id']

Или заявката ще е:

$qData = "SELECT * FROM `users` where `id` = '".$_SESSION['id']."'";

:?:
 
да видях си грашката ама не става
пак ми изкарва сащата грешка

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 'where `id` = ''' at line 6
 
Статус
Not open for further replies.

Back
Горе