[SOLVED] A simple question... yet hard for me :(

[npsari]

if ($Location='') {
     print "No location";
} else {
     print "Location available";
}

 

 

Some users leave the Location-field empty (when submiting their details)

 

Therefore, no Location is saved in the database

 

So, I did the above code which shows if Location is empty or not

 

But it always gives me 'Location available' 

 

Is there any way to do it

[clown[NOR]]

try changing

if ($Location='') {

 

to

if ($Location == '') {

[trq]

<?php

  if (!isset($Location) || empty($Location)) {
     print "No location";
  } else {
     print "Location available";
  }

?>

[clown[NOR]]

or you can use that 

[npsari]

Ok, thanks, i will try them both now

[npsari]

I tried both, they dont work

 

Is it a problem that the field type is VARCHAR ?

 

This is the whole code Iam using too

 

<?php
$con = mysql_connect("localhost","name","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("database", $con);

$result = mysql_query("SELECT * FROM users");

while($row = mysql_fetch_array($result))
  {
  echo $row['Title']; print"<br><br>\n";


  if (!isset($Location) || empty($Location)) {
     print "No location...";
  } else {
     print "Location available";
  }

  
}

mysql_close($con);
?>

[sasa]

add line

$Location = "row['Location'];

before if and after while

[boo_lolly]

where is location being set? as in where is this line:

$Location = ?????????

 

[npsari]

SaSa.. Can you show me how plz

 

paste the code with your part ... if you can

 

I am a noobie afterall

[npsari]

where is location being set? as in where is this line:

$Location = ?????????

 

 

boo I dont understand what you mean

 

Can you explain please your question 

[sasa]

$result = mysql_query("SELECT * FROM users");

while($row = mysql_fetch_array($result))
  {
  echo $row['Title']; print"<br><br>\n";

$Location = $row['Location']; // or the your name for location in db

  if (!isset($Location) || empty($Location)) {
     print "No location...";
  } else {
     print "Location available";
  }

  
}

mysql_close($con);
?>

[npsari]

DONE GUYS

 

THAKS