Redirection problem

Anon

I have a table named test and in the table there is a column named questionone. I want to query the table to see if either 1 0r 0 is in the table and then redirect if either number is there. Something like this.

mysql_query("SELECT questionone FROM test WHERE id = $session[id]");
if (questionone == '0' || '1')
{
header("Location: /moduleone/answererror.php?".SID );
}

This doesn't work and I am not getting errors. Is there a way to do this?

Anon

I was putting the code inside my form check hidden fields. When I moved it to the top of the page and checked it first before even checking the form the problem was solved and the page redirected.

Anon

php wont give you any errors because its not php's area to give the error, its the browsers area.

try this.

header("Location: http://www.none.com/newpage.php");

try typeing

/moduleone/answererror.php

into your location bar, wont work right? neither would putting that in LocationL part of the header() hehe 🙂

more info here
www.php.net/manual/function.header.php
www.w3.org/Protocols/rfc2616/rfc2616-sec14.html#sec14.30

Chris Lee

Anon

if you put

output_buffering = On

in your php.ini, usually in
/usr/local/lib/php.ini

you can then use header() anywhere in your code.

Chris Lee

Anon

I was wrong I can't solve the problem. I want to query the database to see if there is a number 1 or number 0 in it. If there is I want to redirect to another page otherwise do nothing. This code will redirect to the new page no matter what is in the database. Basically I want to redirect if anything is in the database. Is there a way to do this?

mysql_query("SELECT questionthree FROM test WHERE id = '$session[id]'");
if ( questionthree == '1' || '0' )
{
header("Location: http://www.newpage.net/moduleone/answererror.php?".SID );
}

Anon

Isn't the problem:

if ( questionthree == '1' || '0' )

Which should be

if ( questionthree == '1' || questionthree == '0' )

-Walter

Anon

Justin,

There's two additional problems in your code here. Maybe they
are just typos if you were entering this by hand, but if you
cut-and-pasted it you are in for trouble in the near future:

(1) You don't actually call one of the mysql functions to
actually retrieve the results of the query.

(2) there's no dollarsign in front of the variable 'questionone'

(3) this logical expression is missing something:

if (questionone == '0' || '1')

What you undoubtely meant to write was:

if ($questionone == '0' || $questionone == '1')