If field is empty help

[herghost]

Hi all,

 

I have this:

<?php
session_start();
include('login/functions.php');
$username = $_SESSION['username'];
$check = mysql_query("SELECT email FROM user_profile WHERE username = '$username'");
$a = mysql_fetch_field($check);
if(empty($a))
{
header('Location: complete.php');
}


?>

 

However if the field is empty, ie no email address for user then nothing happens?

 

Am going about this the right way?

 

Cheers

[xyph]

You want to use mysql_num_rows() for this

[herghost]

Same problem

 

The row itself will exist, as its created on first login (twitter oauth)

 

However on first login email will not be filled in the row.

 

I have

<?php

session_start();

include('login/functions.php');

$username = $_SESSION['username'];

$check = mysql_query("SELECT email FROM user_profile WHERE username = '$username'");

$a = mysql_num_rows($check);

if(!$check)

{

echo mysql_error();

}

if(empty($a))

{

header('Location: complete.php');

}

 

 

?>

 

The query doesnt fail so its not that

 

[xyph]

Oh, i see what you're doing now.

 

mysql_fetch_field will return an object, so empty might not trigger.

 

TRy mysql_result($check, 0)

[herghost]

Perfect! Thanks:)

 

<?php
session_start();
include('login/functions.php');
$username = $_SESSION['username'];
$check = mysql_query("SELECT email FROM user_profile WHERE username = '$username'");
$num = mysql_result($check, 0);
if(empty($num))
{
header('location: complete.php');
}

?>