[SOLVED]ambiguous??please help...
Posted: Wed Jul 06, 2005 5:48 am
another error...code below:
error is
thanx in advance
Code: Select all
<?
$id = $_GET['pid'];
$fn = $_SESSION['firstname'];
$uid = $_SESSION['userID'];
$query = "SELECT projecttitle, location firstname FROM projects AS p, profile AS pr
WHERE p.userID = pr.userID AND projectID='$id'";
$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$row[0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$row[1]&'pid'];
$fn = $_SESSION['firstname'];
$uid = $_SESSION['userID'];
$query = "SELECT projecttitle, location firstname FROM projects AS p, profile AS pr
WHERE p.userID = pr.userID AND projectID='$id'";
$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$row[0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$row[1]</td>
</tr>
";
}
else
{
echo 'system error!<br>'.mysql_error();
}what is this??when i try to get the value of the other fields, it is fine...but this location field...Column 'location' in field list is ambiguous
[/quote:ef746082dE p.userID = pr.userID AND projectID='$id'";
$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "e;
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї1]</td>
</tr>
"e;;
}
else
{
me'];
$uid = $_SESSION['userID'];
$query = "SELECT projecttitle, location firstname FROM projects AS p, profile AS pr
WHERE p.userID = pr.userID AND projectID='$id'"e;;
$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "e;
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%&am;amp;lt;?
$id = $_GET['pid'];
$fn = $_SESSION['firstname'];
$uid = $_SESSION['userID'];
$query = "SELECT projecttitle, location firstname FROM projects AS p, profile AS pr
WHERE p.userID = pr.userID AND projectID='$id'"e;;
$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "e;
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї1]</td>
</tr>
"e;;
}
else
{
de below:
Code: Select all
<? $id = $_GET['pid']; $fn = $_SESSION['firstname']; $uid = $_SESSION['userID']; $query = "SELECT projecttitle, location firstname FROM projects AS p, profile AS pr WHERE p.userID = pr.userID AND projectID='$id'"e;; $result = @mysql_query($query); if ($result) { $row = mysql_fetch_array($result, MYSQL_NUM); echo "e; <table width=100% border=1> <tr> <td width=20%><b/>Project Title</td> <td width=80%>$rowї0]</td> </tr> <tr> <td width=20%><b/>Project Title</td> <td width=80%>$rowї1]</td> </tr> "e;; } else { echo 'system error!<br&de below:error is = $_SESSION['firstname'];Code: Select all
<? $id = $_GET['pid']; $fn = $_SESSION['firstname']; $uid = $_SESSION['userID']; $query = "SELECT projecttitle, location firstname FROM projects AS p, profile AS pr WHERE p.userID = pr.userID AND projectID='$id'"e;; $result = @mysql_query($query); if ($result) { $row = mysql_fetch_array($result, MYSQL_NUM); echo "e; <table width=100% border=1> <tr> <td width=20%><b/>Project Title</td> <td width=80%>$rowї0]</td> </tr> <tr> <td width=20%><b/>Project Title</td> <td width=80%>$rowї1]</td> </tr> "e;; } else { echo 'system error!<br>'.mysql_error(); }
$uid = $_SESSION['userID'];
$query = "SELECT projecttitle, location firstname FROM projects AS p, profile AS pr
WHERE p.userID = pr.userID AND projectID='$id'";
$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$row[0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$row[1]</td>
</tr>
";
}
else
{
echo 'system error!<br>'.mysql_error();
}
error is
what is this??when i try to get the value of the other fields, it is fine...but this location field...Column 'location' in field list is ambiguous
thanx in advancee'];
$uid = $_SESSION['userID'];
$query = "e;SELECT projecttitle, location firstname FROM projects AS p, profile AS pr
WHERE p.userID = pr.userID AND projectID='$id'";
$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "e;
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%1]
<?
$id = $_GET['pid'];
$fn = $_SESSION['firstname'];
$uid = $_SESSIONї'userID'];
$query = "e;SELECT projecttitle, location firstname FROM projects AS p, profile AS pr
WHERE p.userID = pr.userID AND projectID='$id'";
$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$row[0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї1]<$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$row[0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$row[1]</td>
</tr>
";
}
else
{
echo 'system error!<br>'.mysql_error();
}
error is
what is this??when i try to get the value of the other fields, it is fine...but this location field...Column 'location' in field list is ambiguous
thanx in advancet;?
$id = $_GET['pid'];
$fn = $_SESSIONї'firstname'];
$uid = $_SESSIONї'userID'];
$query = "e;SELECT projecttitle, location firstname FROM projects AS p, profile AS pr
WHERE p.userID = pr.userID AND projectID='$id'"e;;
$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "e;
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї1]</td>
</tr>
"e;;
}
else
{
echo 'system error!<br>'.mysql_error();
}
error is
what is this??when i try to get the value of the other fields, it is fine...but this location field...Column 'location' in field list is ambiguous
thanx in advance'$id'";
$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$row[0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$row[1]</td>
</tr>
";
}
else
{
echo 'system error!<br>'.mysql_error();
}
error is
what is this??when i try to get the value of the other fields, it is fine...but this location field...Column 'location' in field list is ambiguous
thanx in advanceION['userID'];
$query = "SELECT projecttitle, location firstname FROM projects AS p, profile AS pr
WHERE p.userID = pr.userID AND projectID='$id'"e;;
$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "e;
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї1]</td>
</tr>
"e;;
}
else
{
echo 'system error!<br>'.mysql_error();
}
error is
C $_GET['pid'];
$fn = $_SESSION['firstname'];
$uid = $_SESSIONї'userID'];
$query = "e;SELECT projecttitle, location firstname FROM projects AS p, profile AS pr
WHERE p.userID = pr.userID AND projectID='$id'"e;;
$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "e;
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї1]</td>
</tr>
"e;;
}
else
{
echo 'system error!<br>'.mysql_error();
}
error is
Column 'location' in field list is ambiguous
[/quote:de below:
error isCode: Select all
<? $id = $_GET['pid']; $fn = $_SESSION['firstname']; $uid = $_SESSION['userID']; $query = "SELECT projecttitle, location firstname FROM projects AS p, profile AS pr WHERE p.userID = pr.userID AND projectID='$id'"; $result = @mysql_query($query); if ($result) { $row = mysql_fetch_array($result, MYSQL_NUM); echo " <table width=100% border=1> <tr> <td width=20%><b/>Project Title</td> <td width=80%>$row[0]</td> </tr> <tr> <td width=20%><b/>Project Title</td> <td width=80%>$row[1]</td> </tr> "; } else { echo 'system error!<br>'.mysql_error(); }
what is this??when i try to get the value of the other fields, it is fine...but this location field...
thanx in advance
$id = $_GET['pid'];
$fn = $_SESSION['firstname'];
$uid = $_SESSION['userID'];
$query = "SELECT projecttitle, location firstname FROM projects AS p, profile AS pr
WHERE p.userID = pr.userID AND projectID='$id'"e;;
$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "e;
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї1]</td>
</tr>
"e;;
}
else
{
echo 'system error!<br>'.mysql_error();
}
error is
what is this??when i try to get the value of the other fields, it is fine...but this location fLECT projecttitle, location firstname FROM projects AS p, profile AS pr
WHERE p.userID = pr.userID AND projectID='$id'";
$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$row[0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$row[1]</td>
</tr>
";
}
else
{
echo 'system error!<br>'.mysql_error();
}
error is
what is this??when i try to get the value of the other fields, it is fine...but this location field...
thanx in advancede below:
error isCode: Select all
<? $id = $_GET['pid']; $fn = $_SESSION['firstname']; $uid = $_SESSION['userID']; $query = "SELECT projecttitle, location firstname FROM projects AS p, profile AS pr WHERE p.userID = pr.userID AND projectID='$id'"; $result = @mysql_query($query); if ($result) { $row = mysql_fetch_array($result, MYSQL_NUM); echo " <table width=100% border=1> <tr> <td width=20%><b/>Project Title</td> <td width=80%>$c] <? $id = $_GET['pid']; $fn = $_SESSION['firstname']; $uid = $_SESSION['userID']; $query = "SELECT projecttitle, location firstname FROM projects AS p, profile AS pr WHERE p.userID = pr.userID AND projectID='$id'"; $result = @mysql_query($query); if ($result) { $row = mysql_fetch_array($result, MYSQL_NUM); echo " <table width=100% border=1> <tr> <td width=20%><b/>Project Title</td> <td width=80%>$row[0]</td> </tr> <tr> <td width=20%><b/>Project Title</td> <td width=80%>$row[1]</td> </tr> "; } else { echo 'system error!<br>'.mysql_error(); }
what is this$_SESSION['firstname'];
$uid = $_SESSION['userID'];
$query = "e;SELECT projecttitle, location firstname FROM projects AS p, profile AS pr
WHERE p.userID = pr.userID AND projectID='$id'"e;;
$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "e;
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї1]</td>
</tr>
"e;;
}
else
{
echo 'system error!<br>'.mysql_error();
}
error is
what#1111;'firstname'];
$uid = $_SESSION['userID'];
$query = "SELECT projecttitle, location firstname FROM projects AS p, profile AS pr
WHERE p.userID = pr.userID AND projectID='$id'"e;;
$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "e;
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї1]</td>
</tr>
"e;;
}
elde below:
error isCode: Select all
<? $id = $_GET['pid']; $fn = $_SESSION['firstname']; $uid = $_SESSION['userID']; $query = "SELECT projecttitle, location firstname FROM projects AS p, profile AS pr WHERE p.userID = pr.userID AND projectID='$id'"; $result = @mysql_query($query); if ($result) { $row = mysql_fetch_array($result, MYSQL_NUM); echo " <table width=100% border=1> <tr> <td width=20%><b/>Project Title</td> <td width=80%>$row[0]</td> </tr> <tr> <td width=20%><b/>Project Title</td> <td width=80%>$row[1]</td> </tr> "; } else { echo 'system error!<br>'.mysql_error(); }
what is this??wh#1111;'userID'];
$query = "SELECT projecttitle, location firstname FROM projects AS p, profile AS pr
WHERE p.userID = pr.userID AND projectID='$id'";
$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$row[0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$row[1]</td>
</tr>
";
}
else
{
echo 'system error!<br>'.mysql_error();
}
error is
what is this??when i try to get the value of the other fields, it is fine...but this location field...
projects AS p, profile AS pr
WHERE p.userID = pr.userID AND projectID='$id'";
$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї1]</td>
</tr>
"e;;
}
else
{
echo 'system error!<br>'.mysql_error();
}
error is
what is this??when i try to get= mysql_fetch_array($result, MYSQL_NUM);
echo "
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї0]</td>
</tr>
<lt;?
$id = $_GET['pid'];
$fn = $_SESSION['firstname'];
$uid = $_SESSION['userID'];
$query = "SELECT projecttitle, location firstname FROM projects AS p, profile AS pr
WHERE p.userID = pr.userID AND projectID='$id'";
$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$row[0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$row[1]</td>
</tr>
";
}
else
{
echo 'system error!<br>'.mysql_error();
}
error is
what is this??when i try to get the value of the other fields, it is fine...but this location field...
thanx in advancetle, location firstname FROM projects AS p, profile AS pr
WHERE p.userID = pr.userID AND projectID='$id'"e;;
$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "e;
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$rowї1]</td>
</tr>
"e;;
}
else
{
echo 'system error!<br>'.mysql_error();
}
[/php:1:e
<?
$id = $_GET['pid'];
$fn = $_SESSION['firstname'];
$uid = $_SESSION['userID'];
$query = "SELECT projecttitle, location firstname FROM projects AS p, profile AS pr
WHERE p.userID = pr.userID AND projectID='$id'";
$result = @mysql_query($query);
if ($result)
{
$row = mysql_fetch_array($result, MYSQL_NUM);
echo "
<table width=100% border=1>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$row[0]</td>
</tr>
<tr>
<td width=20%><b/>Project Title</td>
<td width=80%>$row[1]</td>
</tr>
";
}
else
{
echo 'system error!<br>'.mysql_error();
}
error is
thanx in advance