Jump to content

MadTechie

Staff Alumni
  • Posts

    9,409
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by MadTechie

  1. well from what you have show their nothing i can suggest!
  2. i think its better to get it done in mySQL using the interval may help ie WHERE 'starttime' > DATE_ADD(2007-05-21, INTERVAL 1 MONTH); try looking here
  3. lol true and i foresaw problems and you say its a pain LOL well you know what they sayabout great minds
  4. erm.. well first change $deleteid = $key to $deleteid = $key; also whats the error ? / problem ans please use code tags
  5. EDIT if the field is a date field you could try WHERE MONTH(starttime) = 21 AND DAYOFMONTH(starttime) = 5 AND YEAR(starttime) = 2007 theirs better ways but still just an example!
  6. what type of field is starttime ?
  7. Step #1 read the pdf section in the manual Step #2 when you have a problem with the code post the code and the problem. OR see freelance section
  8. try Javascript as for the session_start() try @session_start();
  9. ok what the "Problem" with your script ? this isn't exactly a training site !
  10. you only used session_start(); in logout!!!!
  11. What about <?php echo " <tbody> <tr> <td>{$prodRow['item']}</td> <td>{$prodRow['size']}</td> <td>£{$prodRow['price']}</td> <td><input type='text' id='qty' name='qty[{$prodRow['id']}]' maxlength='1' size='1' /></td> <input type='hidden' name='product[{$prodRow['id']}]' value='{$prodRow['item']}'> </tr> </tbody>"; ?> <?php foreach ($_POST['product'] as $K => $P) { echo "$P QTY = {$_POST['qty'][$K]}<BR>"; } ?> **UNTESTED and i'm tired!
  12. you sure its not a cacheing issule!
  13. works in FF 2 & IE7 for me! edit: by works i mean i got the exact same results
  14. or if its a short config, just write the whole thing with the mods,
  15. some code would help!! have you got a sample we can try?
  16. you see nothing cos you printed nothing..
  17. can you post your directory structure..
  18. change <?php $sql = mysql_query("INSERT INTO jos_muse_users (MemberID, ContactID, GivenName, FamilyName, Email, AddressAsEmail, HomePhone, BusinessPhone, Mobile, Gender, DateofBirth ,Address1, Address2, PostalCode, SourceForm, NRIC, Race, Nationality, ChildName, ChildDOB, ChildGender, City, State, Country, SourcePortal) VALUES ($SQLq)") or die (mysql_error()); ?> to <?php $query = "INSERT INTO jos_muse_users (MemberID, ContactID, GivenName, FamilyName, Email, AddressAsEmail, HomePhone, BusinessPhone, Mobile, Gender, DateofBirth ,Address1, Address2, PostalCode, SourceForm, NRIC, Race, Nationality, ChildName, ChildDOB, ChildGender, City, State, Country, SourcePortal) VALUES ($SQLq)"; echo $query; $sql = mysql_query($query) or die (mysql_error()); ?> and post the results as for the load data method you have more columes than fields
  19. erm.. i mean can you post more of your code.. theirs nothing we can do without the complete picture.. we have a form great but without the rest we can't help!!!
  20. can you echo $fName; and post the results
  21. LOL you need to chmod the folder your working inn (0777 = full access) you can do this via FTP access (normally right click)
  22. its the path! echo $fName;
  23. can you post the form code as well please
  24. file_exists FALSE for files inaccessible due to safe mode restrictions. However these files still can be included if they are located in safe_mode_include_dir. also we're need to see the middle part of the code!
  25. Sighs.. ok heres a basic idea of the next step of course i don't know your database so this is basic.. <?php $row = 1; $handle = fopen("test.csv", "r"); while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $num = count($data); echo "<p> $num fields in line $row: <br /></p>\n"; $row++; $SQLq =""; for ($c=0; $c < $num; $c++) { echo $data[$c] . "<br />\n"; $SQLq .= "$data[$c],"; } $SQLq = trim($SQLq, ","); //SQL part goes here ie insert into table (field1,field2,field3) VALUES ($SQLq); } fclose($handle); ?> while i normal stick to my guns, we all make mistakes but considering this forum is free support i don't like wasting my time trying to help other so by post 3 exact posts it wastes my time.. to find your own post click and Show the last topics of this person.
×
×
  • 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.