[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 f

[PHP] Session Authentication error

2002-04-04 Thread Patrick Hartnett
pts/error.php?e=$status";); // exit(); // } // } //?> -Patrick Hartnett toymaster e-dbapps.com _ MSN Photos is the easiest way to share and print your photos: http://photos

[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. http://dev.e-dbapps.com/customscripts/checklogin.php";); exit; } ?> e-DBapps.com: Home **stuff** CHECKLOGIN.php http://dev.e-dbapps.c

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] Connecti

Re: [PHP] header() question

2002-04-01 Thread Patrick Hartnett
ut _blank? I don't have the >answer >for this last question. > >-- > > >Best regards, >George Nicolae >IT Manager >___ >PaginiWeb.com - Professional Web Design >www.PaginiWeb.com > > >"Patrick Hartnett" <[EMAIL PROTECTE

[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 --

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; }

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;

[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 k

[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] 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] 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 an

[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 easi