|
|
Posted by Raj on 10/20/05 21:03
Hi,
If I enter in a browser
http://localhost/~raj/fdd/start.php?s=tfdd
The folllowing script outputs
9tfdd99
It appears that the script doesn't get as far as the SQL. I don't know why. I
dontl get informed of any errors.
$num does not get populated. I think it should be 0 if the query above it
returns no values. Can someone tell me why it doesn't get populated at least
with a zero..
Please help.
Thanks,
Raj (newbie)
Here is the code:
start.php
<?php
session_start();
session_destroy();
include("./general_scripts_etc/header1.php");
$s=$_GET['s'];
print("9");
print($s);
print("9");
$query="SELECT * FROM site_data WHERE site_name=$s";
$result=@mysql_query($query);
$num=mysql_num_rows($result);
print($num);
print("9");
if ($num==0)
{
$query="SELECT * FROM site_data WHERE site_number='1'";
$result=@mysql_query($query);
while ($Row=mysql_fetch_array($result))
{
$_SESSION['site_name']=$Row[site_name];
$_SESSION['site_logo_location']=$Row[site_logo_location];
$_SESSION['site_admin_email']=$Row[site_admin_email];
$_SESSION['site_number']=$Row[site_number];
ob_end_clean();
header("Location: intro_page.php");
}
}
if ($num==1)
{
while ($Row=mysql_fetch_array($result))
{
$_SESSION['site_name']=$Row[site_name];
$_SESSION['site_logo_location']=$Row[site_logo_location];
$_SESSION['site_admin_email']=$Row[site_admin_email];
$_SESSION['site_number']=$Row[site_number];
ob_end_clean();
header("Location: intro_page.php");
}
}
include("./general_scripts_etc/footer1.php");
?>
header1.php
<?php
ob_start();
session_start();
include('../outer/mysql_connect_fdd.php');
//limit is number of users listed per search page
$limit=10;
//live_limit is time to wait till offline
$live_limit=15*60;
//the limit to the number of pages appearing on the bottom of pages
$menu_max=25;
//log refrsh time
$log_refresh=30;
//time to wait till wipe instant message - seconds
$instant_message_wipe=15*60;
//time to wait till wipe old other - seconds
$other_points_wipe=30*24*60*60;
//address to send photos for verification
$photo_verify_address="http://www.freedatingdatabase.com/admin777/photo_verifi
cation.php?user_id="
?>
footer1.php
<?php
ob_end_flush();
?>
mysql_connect_fdd.php
<?
define('DB_USER', 'lkjsdflkdf');
define('DB_PASSWORD', 'lkhjdsflkhj');
define('DB_HOST', 'localhost');
define ('DB_NAME', 'db1');
$dbc=@mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not connect
to database. Please try later. Error: '.mysql_error());;
mysql_select_db(DB_NAME);
@mysql_select_db (DB_NAME) OR die ('Could not select the
database:'.mysql_error());
?>
Navigation:
[Reply to this message]
|