[SOLVED] no user with id echo

[runnerjp]

<?php

  

  session_start();

  require_once '../settings.php';



  $query = "SELECT * FROM users WHERE Username = '$username' LIMIT 1"; 

  if ($result = mysql_query($query)) {

    if (mysql_num_rows($result)) { 

      $array = mysql_fetch_assoc($result);

      $pemail = $array['Email'];

      $puser = $array['Username'];

  $pid = $array['ID'];

    } else {

      echo "No users found with id $id<br />";

    }

  } else {

    echo "Query failed<br />$sql<br />" . mysql_error();

  }

$sql = "SELECT `ext` FROM `user_images` WHERE `user_id`='$pid' LIMIT 1"; 

$q = mysql_query($sql) or die("Error running query:".mysql_error());

if($q && mysql_num_rows($q) > 0){

  $row = mysql_fetch_array($q);

  if(!empty($row)){

    echo "<img src='http://www.runningprofiles.com/members/images/".

         $pid . "." . $row['ext']

         . "' />";

  }

}else{

  echo '<img src="images/pic.jpg">';

  }

?>

 

where it says no users with id.. how can i make it so only that comes up as at the moment it shows no users with id but also shows the other information?

[revraz]

Change your logic so when the record is found you do the rest of your code, and if not, it returns the error and then their is no code after.

 

You only want to take action if it found what you want it to.

[runnerjp]

ok  so could i have example to work with or link as i dont quite get you lol

[revraz]

Something like this

 

<?php
  session_start();
  require_once '../settings.php';
  $query = "SELECT * FROM users WHERE Username = '$username' LIMIT 1"; 

  if ($result = mysql_query($query)) {
    if (mysql_num_rows($result)) { 
      $array = mysql_fetch_assoc($result);
      $pemail = $array['Email'];
      $puser = $array['Username'];
  	$pid = $array['ID'];		
		$sql = "SELECT `ext` FROM `user_images` WHERE `user_id`='$pid' LIMIT 1"; 
		$q = mysql_query($sql) or die("Error running query:".mysql_error());

		if($q && mysql_num_rows($q) > 0){
  				$row = mysql_fetch_array($q);

							 if(!empty($row)){
    							echo "<img src='http://www.runningprofiles.com/members/images/". $pid . "." . $row['ext']  . "' />";
  						}
	}
else {

  echo '<img src="images/pic.jpg">';
  	}
} 
else {
      echo "No users found with id $id<br />";
    }
  } 
else {
    echo "Query failed<br />$sql<br />" . mysql_error();
  }
?>

[runnerjp]

ohhh so have the bumph 1st then add no user last ahh that makes sence

[revraz]

Yeah, I wasnt sure what you were actually doing, but you want it to flow logically.  No point going through all the code if one part isn't valid right?

[runnerjp]

ah yes buuuuut what if you want to add a table into the mix

 

<?php
  session_start();
  require_once '../settings.php';
  $query = "SELECT * FROM users WHERE Username = '$username' LIMIT 1"; 

  if ($result = mysql_query($query)) {
    if (mysql_num_rows($result)) { 
      $array = mysql_fetch_assoc($result);
      $pemail = $array['Email'];
      $puser = $array['Username'];
  	$pid = $array['ID'];		
		$sql = "SELECT `ext` FROM `user_images` WHERE `user_id`='$pid' LIMIT 1"; 
		$q = mysql_query($sql) or die("Error running query:".mysql_error());

		if($q && mysql_num_rows($q) > 0){
  				$row = mysql_fetch_array($q);

							 if(!empty($row)){
    							echo "<img src='http://www.runningprofiles.com/members/images/". $pid . "." . $row['ext']  . "' />";
  						}
	}
else {

  echo '<img src="images/pic.jpg">';
  	}
} 
else {
      echo "No users found with id $id<br />";
    }
  } 
else {
    echo "Query failed<br />$sql<br />" . mysql_error();
  }
?>



<table width="100%">

  <tr>

    <td colspan="3"><div align="center">Welcome to <?echo "$puser"?>'s profile</div></td>

  </tr>

  <tr>

    <td width="162">your id is no <?echo "$pid"?></td>

    <td width="711"></td>

    <td width="100">

  </td>

  </tr>

</table>

[revraz]

You only want to add the table if there was an ID, so you'll have to mix it with your PHP.

 

You can either keep PHP on and use echo or you can exit PHP, do the HTML, then turn PHP back on.

 

 

[runnerjp]

what would be the best way??  how would i turn php off if their is no id then turn it back on again :S

[revraz]

No best way really, it's your preference.

 

And you just do this:

 

<?php
echo "PHP is on";
?>
HTML is on
<?php
echo "PHP is back on";
?>

[runnerjp]

ahh yer but i have php in my table... dam lol how would i mix it in the the php??

 

sorry lots of questions but you explain it well

[revraz]

The exact same way

<table>
<tr>
<td>HTML</td>
<td><?php echo "PHP" ?></td>
</tr>
</table>

 

[runnerjp]

oh no ok i can allready do that   just i dont want the table to apear if no id is found

[revraz]

Right, so you put that part up in the code where the ID is found.

[runnerjp]

what would i just echo it?

[revraz]

Up to you.  Either echo or turn off PHP, do your html, then turn php back on.

[runnerjp]

yes but i dont get how that works  to echo a table

[revraz]

echo "<table><tr><td>Hi</td></tr></table>";

[runnerjp]

ok i tried

 

<?php
  session_start();
  require_once '../settings.php';
  $query = "SELECT * FROM users WHERE Username = '$username' LIMIT 1"; 

  if ($result = mysql_query($query)) {
    if (mysql_num_rows($result)) { 
      $array = mysql_fetch_assoc($result);
      $pemail = $array['Email'];
      $puser = $array['Username'];
  	$pid = $array['ID'];		
		$sql = "SELECT `ext` FROM `user_images` WHERE `user_id`='$pid' LIMIT 1"; 
		$q = mysql_query($sql) or die("Error running query:".mysql_error());

		if($q && mysql_num_rows($q) > 0){
  				$row = mysql_fetch_array($q);

							 if(!empty($row)){
    							echo "<img src='http://www.runningprofiles.com/members/images/". $pid . "." . $row['ext']  . "' />";
  						}
	}
else {

  echo '<img src="images/pic.jpg">';
  	}
} 
echo '<table width="100%">

  <tr>

    <td colspan="3"><div align="center">Welcome to <?echo "$puser"?>'s profile</div></td>

  </tr>

  <tr>

    <td width="162">your id is no <?echo "$pid"?></td>

    <td width="711"></td>

    <td width="100">

  </td>

  </tr>

</table>

'
else {
      echo "No users found with id $id<br />";
    }
  } 
else {
    echo "Query failed<br />$sql<br />" . mysql_error();
  }
  ?>

 

but get unexpected T_STRING, expecting ',' or ';' on line 31

[revraz]

You are already in PHP since you used Echo so this line isnt valid

 

<td colspan="3"><div align="center">Welcome to <?echo "$puser"?>'s profile</div></td>

 

you just need

 

<td colspan="3"><div align="center">Welcome to '.$puser.'\'s profile</div></td>

 

[revraz]

You also may have it placed wrong since I dont see a ending } and you dont have a semi colon at the end.

[runnerjp]

so hav ei put it wrong  by just echoing it

[runnerjp]

<?php
  session_start();
  require_once '../settings.php';
  $query = "SELECT * FROM users WHERE Username = '$username' LIMIT 1"; 

  if ($result = mysql_query($query)) {
    if (mysql_num_rows($result)) { 
      $array = mysql_fetch_assoc($result);
      $pemail = $array['Email'];
      $puser = $array['Username'];
  	$pid = $array['ID'];		
		$sql = "SELECT `ext` FROM `user_images` WHERE `user_id`='$pid' LIMIT 1"; 
		$q = mysql_query($sql) or die("Error running query:".mysql_error());

		if($q && mysql_num_rows($q) > 0){
  				$row = mysql_fetch_array($q);

							 if(!empty($row)){
    							echo "<img src='http://www.runningprofiles.com/members/images/". $pid . "." . $row['ext']  . "' />";
  						}
	}
else {

  echo '<img src="images/pic.jpg">';
  	}
} 
echo '<table width="100%">

  <tr>

    <td colspan="3"><div align="center">Welcome to '.$puser.'\'s profile</div></td>

  </tr>

  <tr>

    <td width="162">your id is no '.$puser.'</td>

    <td width="711"></td>

    <td width="100">

  </td>

  </tr>

</table>


else {
      echo "No users found with id $id<br />";
    }
  } 
else {
    echo "Query failed<br />$sql<br />" . mysql_error();
  }
  ?>

 

getting Parse error: syntax error, unexpected T_ELSE, expecting ',' or ';' in /home/runningp/public_html/members/profile.php on line 50

[revraz]

You need a ending quote ' after your /table and you need a semicolon ; to end the statement as well as a } probably too.

[runnerjp]

  echo '<img src="images/pic.jpg">';
  	}
} 
{
echo '<table width="100%">

  <tr>

    <td colspan="3"><div align="center">Welcome to '.$puser.'\'s profile</div></td>

  </tr>

  <tr>

    <td width="162">your id is no '.$puser.'</td>

    <td width="711"></td>

    <td width="100">

  </td>

  </tr>

</table'>;

 

tried it and didnt respond well lol