how to code not empty

[snowfox]

I need a code to check to see if a table has data. If it contains any data, I want to redirect it.

I have tried this code, but it doesn't work

<?php

if($totalRows_basic > 0){
header("Location:http://localhost/setup.php");
}

?>

I have played around with using =notEmpty and that doesn't work. I am not sure how to do this, can someone help me?

[dagon]

on the face of it there is no reason why the above should not work, have you echoed the value of $totalRows_basic?

[snowfox]

I added an echo and it still does not work, any other suggestions?

[dagon]

what does echo return? how is $totalRows_basic set?

[snowfox]

The echo is not showing anything, when running I get a http 500 error. This is the same error that I got in the beginning.

The table basic is set up with first_name, last_name, address1, address2, city, state, zip, home_phone, cell_phone, work_phone.

I am setting this up on a usb stick so that only one person can use this information.

So I only want one entry in the table basic. If there is information in that table I want to send them to the update page so they can change address, phone, etc.

If you have any other ideas on how to accomplish this I am open to suggestions.

[dagon]

how would you know it returns nothing if you get a http 500 error? the server error means you want see any results from php.