it is giving you the highest id in that table, when you do the insert use


select LAST_INSERT_ID();


this will give you the id of that row, not the highest one in the table

you can do it that way, i would suggest returning a value from a stored procedure like


select LAST_INSERT_ID();

1. very easy (mysql_connect)
2. believe you are looking for an insert statement
3. update, delete, and update statements
4. schema/user privileges

is the user on the system? or is the user only in the database?

and which user are you creating the folders with?

And just as good practice, a database is there for the organization, it doesn't need to be in sequential order.

It may look prettier to you if it is, but just add an order by user_id or whatever...

i don't have a clear idea of what you are wanting

the message_from field has a 3 and it needs to be a 104?

That is the point of the query, you are able to distinguish in the same resultset of who are chaplains and not. You want to use the same column and distinguish code side by checking user_level.

thats because you are assigning it, the is_chaplain column didn't exist and we had to give it values, the user level column does exist

use this in both queries and you will get your 2 or 3

...

yes, i thought you meant you didn't have a way to distinguish

instead of the is_chaplain, substitute the user_level into the query

i think we need to add single quotes around the is_chaplain


//readers
0 as 'is_chaplain'

//chaplains
1 as 'is_chaplain'

SELECT assignment.Id, assignment.Candidate, assignment.`Section`, assignment.Team, assignment.Chaplain, assignment.Reader, tbl_user.Id, CONCAT_WS(' ', `tbl_user`.name_pre, `tbl_user`.name_first,...

If you need the results separated, then why not issue 2 queries?

Or add an additional column to the rows for the union,
for readers 0 as IS_CHAPLAIN
for chaplains 1 as IS_CHAPLAIN

i don't get what the difference is in the concat of the chaplain, you are using the same columns

can you show what the concat difference is?

f_name field is just pre + first + last + suffix

it will use the same formatting for both readers and chaplains

if you want this field different, please explain more clearly with an example of...

WHERE tbl_user.Id= assignment.Reader OR tbl_user.Id = assignment.Chaplain


i think this is what you are looking for with the additional where

Should work, but you might want to use this for strings

if you don't care about case use strcasecmp instead strcmp

if equal they will return 0


if(strcmp($email1, $email2)==0){
echo...

maybe at least enter the first letter of the county, lol hope they won't mess that up

you can do it as select it from the mysql side


select time1, time2, addtime(time1,time2)
from table

what happens if you just use

setcookie(ID_my_site);
setcookie(Key_my_site_);

session is only for the time the user has your site opened

if you need expiry time after you close the browser, use cookies as architact stated

agree with kavitha

use this to destroy the session

session_destroy();


this to reset the cookie
if its cookie just set to its name

i use javascript for client side validation, not for functionality

lets say for a field that will be submitted needs to be a minimum of 8 characters, they type 4, and i can use javascript to warn...

If they have javascript disabled, you'll never be able to update the quantites.

Think of adding an item, the same as changing quantities, overall it is a change.

You could repost the quantities...

Its all up to you. Typically you would not let the user know how many attempts they have left and just display a message after they have locked themselves out, that their account has been locked and...

It is a constant battle to keep up with security and hackers or what not.

The only thing you can do is try and stay ahead of the game.
Make users have secure passwords, if user's are complaining,...

Yes, do the other checks first like the link showed and if they ARE EMPTY, then rely upon the REMOTE_ADDR.

The problem will be that if your users are behind the proxy, you will be blocking all of them from the same ip address without using the additional code.
If they aren't behind the proxy...

One more thing, just in case they are behind a proxy, this might be better for getting the ip.

http://roshanbh.com.np/2007/12/getting-real-ip-address-in-php.html

Here's a link of how to get the ip address
http://www.plus2net.com/php_tutorial/php_ip.php

Then just set up table along the lines of

BLOCKED_IP
FAILED_LOGIN_ATTEMPTS
LAST_FAILED_TIME

When...

Once again, hackers might keep trying the passwords, but you might want to try an approach of blocking ip's. 5 attempts at an ip with an incorrect password, record the ip in a table, and pull back...

A good way would be to include the parameters in the query string



<a href="www.thispage.com?county=Chaffee&state=Colorado"> Chaffee </a>