[PHP] PHP and MSSQL (and Access????)

2003-12-31 Thread Hunter, Jess
Well, with using the MyODBC drivers you could create and maintain a MySQL database through MsAccess. That way you could have the best of all worlds (please don't flame me for saying that). Using MySQL as the database backend, PHP for a web front end and MsAccess as an administrative GUI for your u

[PHP] Page Redirects - How can it be done

2003-12-17 Thread Hunter, Jess
I have created a simple login/authentication script to help protect some of my PHP pages. Here is where I am running into a little trouble in understanding. Let's Say I have the following pages protected Page1.php Page2.php Page3.php If the user is not logged in, the "inc." file will send them

RE: [PHP] chill out

2003-04-03 Thread Hunter, Jess
Well as a relative newbie with little to no programming experience here is my 2 cents worth. I have found that I myself have asked some of the "simple" questions, while some people respond with "RTFM" I have had the good fortune of having an understanding sole shoot me back a snippet of code with

[PHP] Getting Results for a month from a date field

2003-03-26 Thread Hunter, Jess
I have a field named "hiredate" and it is in the typical MySQL format (-MM-DD) what I am trying to do it be able to create a query that when I put in a particular month it will give me the results regardless of the year the person was hired. This is so I can generate a "anniversary" report to

[PHP] Still having a problem with IF/ELSE Statement

2003-03-06 Thread Hunter, Jess
I want to tahnk those that responded to my previous post, seems I was doing this all the wrong way. I am still having an issue with the syntax: if("$status=='active'"){ echo("active line\n"); }else{ echo("inactive line\n"); }; When I display an employee record that has the employment status $Row

[PHP] Newbie Problem with an IF Statement

2003-03-05 Thread Hunter, Jess
I have a short bit of code that contains an if/else that is causing me some trouble, I am sure that the answer is staring me straight in the face, and I am not seeing it. Can someone take a look and see where I am coding wrong? if ("[status]='active'"){ print ("the active line\n"); } else { pri

[PHP] Doing a Multiple Search

2003-03-04 Thread Hunter, Jess
I know this must be an easy solution, just not seeing what it is. I have tried to add several options to the below code but can't seem to get it right. Here is the Base Line I am working with: $Query="SELECT * from $TableName WHERE lastname='$Array[lastname] AND firstname='$Array[firstname]' ";

[PHP] Newbie look for some content specific tutorials

2003-02-27 Thread Hunter, Jess
Greets all, First time poster here and a 1 week old PHP/Mysql programmer I have bought several books and scoured the net for any and all PHP/MySQL tutorials. Here is the problem I am running into: 1. The docs tell how to access MySql through the MySql monitor 2. any docs that tutor how to make P