[Resolved] grabbing a field from query

crawfd

All I simply want to do is a grab the status field value from the query and print it .....below isn't working.


$query = "Select status FROM $table_users WHERE username = '".$_SESSION['username']."'";
mysql_query($query);

print "Your current Account Type: $status <br><br>";

bubblenut


$query = "Select status FROM $table_users WHERE username = '".$_SESSION['username']."'";
$res=mysql_query($query) or die("SQL: $query<br />\nError: ".mysql_error());
if($row=mysql_fetch_array($res)) {
  echo('Your current Account Type: '.$status.'<br />');
} else {
  echo('The provded username '.$_SESSION['username'].' could not be found<br />');
}

Running the query ([man]mysql_query()[/man]) returns a MySQL resource, you then must use PHP MySQL fetch functions to retrive specific data from the resultset. Normally you'd be using [man]mysql_fetch_array()[/man] with a while loop but as this query is only expected to return one row an if will suffice. You could add an extra level of checking in by also checking that there's not more than one row by using the [man]mysql_num_rows()[/man].

HTH
Bubble

crawfd

It doesn't seem to print $status, ..so I tried adding my db connection right above the query and it still doesn't print $status. Not sure what I'm doing wrong...I checked status field..spelled correctly, and also users is the name of the table in the journals db.....hmph. Want it to print whatever value is in the status field..

$db = @mysql_connect('localhost','','');
mysql_select_db('journals');

$query = "SELECT status FROM users WHERE username = '".$_SESSION['username']."'"; 
$res=mysql_query($query) or die("SQL: $query<br />\nError: ".mysql_error()); 
if($row=mysql_fetch_array($res)) { 
  echo('Your current Account Type: '.$status.'<br /><br>'); 
} else { 
  echo('The provded username '.$_SESSION['username'].' could not be found<br />'); 
}

MrCool

instead of $status have you tried $row['status'] ?

bubblenut

Originally posted by MrCool
instead of $status have you tried $row['status'] ?

:o Sorry, my mistake. Lazy Sunday and not paying attention 😉

crawfd

Yeah that work's, .......but why doesn't '.$status.' work ? just out of curiosity ....

Adding '$row['status']' did the trick...............

MrCool

well, simply because you don't say what $status is. $row specifies the mysql_fetch_array🆒