Jump to content

eranwein

Members
  • Posts

    22
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

eranwein's Achievements

Member

Member (2/5)

0

Reputation

  1. how do i increment a record field which is a type of datetime to be it's initial value plus let's say one year. i want to use one UPDATE query, and not SELECT and then UPDATE. for example '2004-11-15 10:11:48' will be 2005-11-15 10:11:48.
  2. i have in my project something like 300 querys. all built with "mydb.", so i'm guessing this is not the reason... btw, whenever i forgot to call "mydb." it failed to run.
  3. just did. it doesnt work
  4. i have two tables: tblItem and tblItemColor. i want to delete some records from the tblItemByColor table. this is the query i'm trying: DELETE FROM mydb.tblItemByColor WHERE item_number = 10 AND (color_number = 6 OR color_number = 9) no rows are effected by running it, although there are records with those properties.
  5. gave it a shot. it doesnt work
  6. it's a submit() function that operates "post" method and it's action is the addres of the other page.
  7. i have a function that adds a record to a table and then redirects the user to a different page where he should see all of the table's records, including the one that was just added. the problem is that the second page shows all of the records except the one that was just added. after a lot of testings, i've tried to manualy refresh the database (mysql-front). after i did that, i've refreshed my page and lost record was found. is that the way it suppose to be? if so, is there a function in php that refreshes the database?
  8. the missing ; is not relavent because it's not copy+paste from the code. how do io set my error reporting to display my problam?
  9. i need to check if an uploaded file exists. i'm using file_exists($filename). as i understand, the $filename should be the path and name of the uploaded file. $_FILES['uploadedFile']['name'] returns only the name but not the path. so how do i do it?
  10. i know that it's a problem most of you didnt encounter with, but still... i'm trying to upload files. this is the code i'm using: if (move_uploaded_file($_FILES['uploadedFile']['tmp_name'],$file_path)) print "file insert" else print "file not insert"; when i'm trying to upload files containing hebrew words, it doesnt do anything. it doesnt even print "file not insert". is there any configuration i have to do ?
  11. i have an array stored in $_SESSION. ($_SESSION['some_array']). how do i remove it from the session without using unset() for each of the array values?
  12. i have a tsble field which is defined as varchar(11) for storing mobile phone number. the values should be in this format: 999-999999. when i run an UPDATE query, it stores it with different value and without the "-". but when i write it directly to the database with mysql-front there is no problem. so, what should i do? let me just say that i know about the option of seperating the two values into two different fields, but i would prefer it to be done as explained.
  13. thanks. works great. to all the others who reads it, notice that there is a missing $ on date2. thanks again, eran
×
×
  • 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.