[PHP] QUery success, but blank results/variables

2002-09-09 Thread Patrick Hartnett
Hello everyone..tryin to run this qry against a mysql db, but after it runs, it doesn't assign anything to the variables as it should. If i return all rows, and spit out each record in the result in an array, i have the same problem, but have 24 'blank' records instead of 1. Any ideas? Thanks

[PHP] Login only to get stuck in infinite loop...what's missing?

2002-04-04 Thread Patrick Hartnett
After logging in successfully, i start an infinite loop between index.php and login.php, what's up? Please help. ? // index.php - secure page session_start(); if (!isset($PHP_AUTH_USER)) { // If empty, send header causing dialog box to appear

[PHP] Session Authentication error

2002-04-04 Thread Patrick Hartnett
;); // exit(); // } // else // { // $status = 0; // header(Location: http://dev.e-dbapps.com/customscripts/error.php?e=$status;); // exit(); // } // } //? -Patrick

[PHP] header() question

2002-04-01 Thread Patrick Hartnett
Is it possible to user the target=_top reference when using a header(Location = ...)? If so, anyone have an example. Thanks -patrick _ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com -- PHP

Re: [PHP] header() question

2002-04-01 Thread Patrick Hartnett
IT Manager ___ PaginiWeb.com - Professional Web Design www.PaginiWeb.com Patrick Hartnett [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Is it possible to user the target=_top reference when using a header(Location = ...)? If so

Re: [PHP] Connecting to multiple DB's

2002-04-01 Thread Patrick Hartnett
Not sure about the multiple connections side, but to kill a connection: mysql_close($link); where $link is your connection variable/string hope this helps. -Patrick From: James Taylor [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: PHP List [EMAIL PROTECTED] Subject: [PHP] Connecting to

[PHP] MySQL Connection Error - mysql_select_db

2002-03-30 Thread Patrick Hartnett
here is a function used to authenticate users against mysql database. Problem is, I am not connecting for some reason. I have the db variables: $db_host $db_user $db_pass $db_name They are populated from an include (x.php) in the beginning of the php section. It is getting past the connect

[PHP] MySQL Connection Error - mysql_select_db

2002-03-30 Thread Patrick Hartnett
Thanks for all the help so far, great to have others out there helping. Only way it will let me connect is to explicitly use the connection information in the connect statement and the select_db statements, can't pass in the variables. This seems a little on the insecure side, and a pain. Is

[PHP] Case Statements - lil help please

2002-03-30 Thread Patrick Hartnett
Are case statements not implemented in PHP4? If so, can someone help me debug this one, I seem to have some syntax incorrect, and am not sure what exactly is wrong with the statement. I get a parse error on the first line, but can't find any documentation on case statements in PHP4, so I am

Re: [PHP] Sql results

2002-03-30 Thread Patrick Hartnett
try this, it sees if there is a result, and you can then proceed to do what you need to do. if (mysql_num_rows($result) == 1) //match found { //do something here; } // no match found else { //do something here;

Re: [PHP] Sql results

2002-03-30 Thread Patrick Hartnett
use it after your query to see if there is a result set. Like follows: $result = mysql_query($query) or die (Error in query: . mysql_error()); // if row exists - user/pass combination is correct if (mysql_num_rows($result) == 1) { return 1; }

[PHP] Get Current Filename

2002-03-28 Thread Patrick Hartnett
Trying to build a database which uses the webpage name as one of the selection criteria. (building page specific menus). How do I get the current file name? Can't seem to find any help on this. -Patrick _ MSN Photos is the

[PHP] Get Current Filename HOWTO

2002-03-28 Thread Patrick Hartnett
It seems I spoke to quick...here is how to get the current file name. $this_file = $_SERVER['REQUEST_URI']; echo( $this_file ); the result is formatted as follows: /applications.php _ MSN Photos is the easiest way to share