Dose anyone have an answer to this question?

Anon

I have a script below, I use this scrip to retrive data from my MySQL database. I have been able to make this script show a spacifyed web page if the result of the query is negative (see line # 32, 33). Now my problem is, I wish to make a specific web page disply if the result is posative? How should I do this? I can not figure it out! Please email me a revised script at "webmaster@dns.li" if you can help.

<body>

<?php

mysql_connect (localhost, dbase, anerson1);

mysql_select_db (domainnames);

if ($domain_name == "")
{$domain_name = '';}

$result = mysql_query ("SELECT * FROM aarp
WHERE domain_name LIKE '$domain_name'
");

if ($row = mysql_fetch_array($result)) {

do {
print $row["domain_name"];
print ("");
} while($row = mysql_fetch_array($result));

print ("<CENTER>WE ARE VERY SORRY!</CENTER>");
print ("");
print ("<CENTER>THE NAME THAT YOU HAVE SELECTED IS ALREADY TAKEN.</CENTER>");
print ("");
print ("<CENTER>PLEASE TRY ANOTHER NAME.</CENTER>");
print ("");
print ("<CENTER><a href=\"http://www.web2.web/netnames/.aarp.html\">CLICK HERE TO SEARCH AGAIN!</a></CENTER>");
print ("");
} else
include("http://liberty.phpwebhosting.com/~dbase/search/.aarp2.html")

</body>

Anon

Try using the header function. However to use this cannot have any output before it. In your case remove <BODY> and your prints. After the test, you can switch to the positve or negative page, eg.

header("Location:http://www.web2.web/netnames/.aarp.html");

Anon

I am not sure that I understand that. Can you make the explenation a bit clearer?

Anon

I finaly found the answer! Thanks to everyone that tryied to help me!
<body>

<?php

mysql_connect (localhost, dbase, anerson1);

mysql_select_db (domainnames);

if ($domain_name == "")
{$domain_name = '%';}

$result = mysql_query ("SELECT * FROM aarp
WHERE domain_name LIKE '$domain_name'
");

if ($row = mysql_fetch_array($result))
{ include "http://liberty.phpwebhosting.com/~dbase/search/.aarp2.html"; }
else
{ include"http://liberty.phpwebhosting.com/~dbase/register/.aarpregister.html"; }

</body>