PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
i created this code from the mysql manual on their site but it dosnt seem to want to work. what it is ment to do is when the id is stated in the url (as blah.php?mail=14) it replaces what is in the table coloum new for the row with id 14 , for the word Old.
thanks for that. i now have another thaught. i am wanting to display on my main page saying how many NEW emails the user has got. i dont have much of an idea of where to start on this one so i dont have much of a dtarting poit sorry :s
Following on from feyd's comment... When using count rather than using
count(*) use count(fieldname) single field. For large tables this speeds things up considerably especially if the column is an indexed integer.
OK thanks for that. its now working good . I now have another question (i think its pointless making lots of new topics when i can just use this one, Stops the board being filled with my problems :p).
i have my login script which uses the else funcltion. it checks the username and password and thenif they are incorrect it includes the login form so they can login again. if they are correct then it includes the members home page. what i am wanting it to do is send them to another pages after they have sucesfully logged in. how could i do that ??
i bet its really simple :S
Thanks
Eric
[EDIT] oh and also how can i disconnect from a database so that i can connect to another one without closing the php tags ?>
aggghhhh!!! :S i have just gone and delete my login script and only have my first copy as backup :S i have tried it and it only wants to throw back this error -