Jump to content

biffta

New Members
  • Posts

    5
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

biffta's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Thing is you dont Need Mysql to use PHP. BUT...you keep asking what do I need MySQL for. I ask you what do you need PHP for? Thing is if your answer to that question is anything concerning an interactive style of web site, then chancces are you will need a database to keep track of everything on your site. You can do all kinds of things with PHP without a database but it really comes into its own when you do.
  2. I wanted to join the two tables via staff_id then do the update but as this is not possible the two query method will do me just as good! Thanks
  3. you dont need to addslashes as your not going to be inserting the search term into your dbase. Also you will probably have to do $searchterm = $_POST[\'searchterm\']; first as well.
  4. No good sir. is-registered is a set so the quotes are needed! The actual error MySql gives me is which is definately not the case!I believe the problem lies with the fact that I am using two tables and and update statement usually uses only one???
  5. I have the following SQL which gives me the row Im after SELECT * FROM staff, staffemails WHERE staff.users_username=\'$user\' and staff.staff_id = staffemails.staff_id thing is I now want to perform an update on the result of this query. Ive tried UPDATE staffemails SET is_registered =\'0\' WHERE staff.users_username = \'$user\' and staffemails.staff_id = staff.staff_id But that doesnt work! Any ideas????
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.