Jump to content

Zane

Administrators
  • Posts

    4,362
  • Joined

  • Last visited

  • Days Won

    11

Everything posted by Zane

  1. This post belongs in the MSSQL Help Forum not in Dreamweaver Moving....
  2. how are you assigning $file...show a little more code I'm assuiming it's an upload file array but I can't be too sure and if that is the case remember you have to include the name of the file upload input box from you HTML E.G if you're box looks like this [code]<input type="file" name="pictures[]" />[/code] you're print statement must be [code]print $_FILES['pictures']['type'];[/code]
  3. please don't name you're topics with something like HELP ME... titles are meant to give people an idea of what's inside If you would could you come up with a decent title..you will get more help that way to and don't start a new topic.... and as for you're question...you'll have to use URL variables AKA GET vars like display?id=89 would pull up the profile info for profile id #89 with an SQL statement
  4. do you have anymore code to show like the one you're using to do this regex... would help a lot more
  5. Well concept-wise you're either going to have set up a cron job to update everyone in your databases remaining usage time, every day or have it run a script to check that every time they log in.... If you just have a small based thing I would go with the second option just add some code to your login script, where after they've successfully logged in it runs a check to see if they have lapsed their limit yet or not...
  6. [quote]is there a way to select the 3 name fields into one. [/quote] do you mean concatenating them into one field if that's the case you can do this [code] SELECT CONCAT(liezen.ADRESSEN, kirchdorf.ADRESSEN, gmunden.ADRESSEN) as allNames [/code] Note* they won't be separated by any spaces with that code you'd have to include the spaces for that like [quote]CONCAT(gmunden.ADRESSEN, ' ', liezen.ADRESSEN)[/quote]
  7. well I know for one that you can't put a php variable in single quotes and expect to use it's value but instead of just changing it to double quotes like you'll probably do try this '{$yourvar}' so for all those variables you're listing do like this VALUES ('{$servicetag}', '{$description}', '{$provider}',....etc makre sure you use curly braces if that doesn't do it you can get an actual error message by putting this on your $results line $results = mysql_query($qryupdate) or die(mysql_error());
  8. are you displaying your picture like this? [code]$imgsrc="fish.jpg" imagejpeg($imgsrc);[/code]
  9. Welll here [code]mail("$username", "$title", "$body")[/code] you're aren't even passing your headers and you don't need to double quote your variables try this [code]mail($username, $title, $body, $headers)[/code]
  10. yeah this is backwards...as fenway said [QUOTE] catid        subcatid item        couches item        beds item        desks item        refrigerator event      tickets event      concerts event      clubs event      sports event      parties event      charity events rental      sublets rental      parking [/QUOTE] go the other way [CODE] category      parentCategory item            root rental          root event          root couches item   beds item desks item refrigerator item tickets event concerts event clubs event sports event parties event charity events  event sublets rental parking rental [/CODE] and suppose couches had two sub categories....making a 'sub-sub' just had them as category - parent leather    - couches fabric      - couches there's no levels it's just referencing basketball - sports birthday - parties 21st birthdays - birthday and so on
  11. when you're laying this DB structure out just completely get the word sub categories out of your head all you need to think about is that every category has a parent [quote=fenway] You're simply relating two UID, one of the child category, one of the parent category.  You can do this recursively forever, so it doesn't matter how many levels down you go. [/quote] exactly for instance you have category 1 category 2 category 3 category 4 category 5 in another column you have their parents so if category 5 is a parent of category 3..... it's  a 'sub-category' of 5
  12. I think fenway means to put all the categories whether a sub cat or not into the same table and have a column with it's parent category something like catID  |      catName      |  catParent  |    specType   0            academics                        root              regItem   1            anAcademicsubCat            academics              regItem   2            aSubSub                        anAcademicsubCat              regItem I hope that makes sense
  13. [quote]switch on your errors[/quote] good point...
  14. try redoing this line to look like this then....that's the only last thing I can think of [code]echo "<option value='" . $row['font_name'] . "'>" . $row['font_name'] . "</option>"; [/code] or [code]echo "<option value='{$row['font_name']}'>{$row['font_name']}</option>";[/code] both are the exact same thing....just depends on how YOU want it to look.....code-wise they only real significant change I did though was to add quotes to your key [quote]$row[[size=12pt][color=red]'[/color][/size]font_name[size=12pt][color=red]'[/color][/size]][/quote]
  15. you probably have an SQL error or return error redo you're $result line to look like this [code]$result = mysql_query("SELECT `font_name` FROM `fonts`") or die(mysql_error());[/code] you could have mispelled your column name in the Database or somthing like that
  16. [quote]I am looking for something similar to a C structure, where data is tightly packed, and names for the elements do not need to be stored. [/quote] Well, you don't HAVE to store the names of the elements I think the default structure of an array is sorted by index unless one happens to have a stringed key. I don't know if I'm on the right track exactly to what you're asking but.... if you don't want an associative array, one with string indeces and want to avoid the 'repeats' maybe have a shema element at the beginning of the array to aesthetically please you're coding....or whatever but overall...you don't need the keys and as for your question about adding to the end of the array it should still work
  17. you can either use this PHP line on you're download page [code]header("Content-disposition: attachment; filename=yourfile.xls");[/code] or you can go to your Apache http.conf file and add this line to the bottom of it.........and restart the server [code]AddType application/x-excel xls[/code]
  18. maybe I'm understanding this wrong....are you appending the non paying user info inside the same table as the paying users' info? another question [quote] what it is that a user can only pay for the service once they activate there account then they login then pay so that why an id is there ok. [/quote] ..what? so do they pay for the activation and then pay for something else when they ARE activated? I'm lost
  19. Well, I guess if you're not going to have anything else on the error page other than......the 404 you could just flat out redirect to ajflkjdslfkjsdlkajflakf.html which I'd assume doesn't exist but you'd do it through HTML and not a PHP function....meaning echo out [quote] <META http-equiv="refresh" content="0; URL=somerandomarrayofletters.html">[/quote]
  20. Go to the top of you're install file and put this [code] $permit = 0777; chmod("../conf_global.php", $permit); chmod("../cache", $permit); chmod("../cache/lang_cache/", $permit); chmod("../cache/skin_cache/", $permit); [/code] when you're done installing make a [size=10pt][b]copy[/b][/size] of you're install.php file erase everything in it and replace with this [code] $permit = 0644; chmod("../conf_global.php", $permit); chmod("../cache", $permit); chmod("../cache/lang_cache/", $permit); chmod("../cache/skin_cache/", $permit); echo "Permissions Changed Back to " . $permit; [/code] and then of course open that copy in your browser
  21. If you're trying to create you're own Custom 404 Pages, you'll have to edit the 404.shtml in your Apache or IIS configuration Most of the time you can just have all you're error pages do the same thing and just send the error message to one of you're PHP scripts along with whatever information you want. But you have to do that in that 404.shtml file That is if that's what you're trying to do
  22. you should just be able to have a defaulted number pattern like 00000000 and then just extract it like you are so you'll never have a 4 character line
  23. Try this [code]SELECT CONCAT(firstname, ' ', lastname) As fullname FROM database GROUP BY fullname[/code]
  24. var_dump is a print statement in itself...you can't print a print object if that makes sense I'm surprised you haven't mentioned an error or something but anyway... var_dump(headers_list()); should be sufficient as well as var_dump(headers_sent());
  25. just switch the order of these two and it should work require_once("wwc_const.php"); require_once("wwc_functions.php"); just require the funcitons.php first and then const.php
×
×
  • 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.