Jump to content

LiamG

Members
  • Posts

    46
  • Joined

  • Last visited

    Never

Posts posted by LiamG

  1. From what I understand it is possible to use PHP and Access (although, please try MySQL).

     

    Try phpinfo()-ing your system:[php:1:de862a6f46]<?php

    phpinfo();

    ?>[/php:1:de862a6f46]I think it depends on your system.

     

    HTH, LiamG.

     

    /*edit - I found what you are looking for. Under \"dbx\" in your phpinfo() file, it says the databases that you can use. MySQL, MSSQL etc.

  2. Well, glad you figured it out :!: But, I would warn all those using DWMX (as I do) because the PHP/MySQL code (as I hear is the CFM, ASP and JSP code) is VERY messy.

     

    It uses very unconventional - legal, but unconventional - coding styles that is very hard to edit and therefore debug.

     

    I use DWMX and would recomment it to anyone, but not because of its PHP/MySQL compatibility, I use it for the layout tool!

     

    HTH, LiamG.

     

    (edit) - check this out http://www.i-source101.com/read.php?articleid=12

  3. I\'ve had a look at this a few times, so I figured you guys would get it right first off, a new pair of eyes and a new brain is all I need:

    $addnews_sql = "INSERT INTO `news` (`subject`, `username`, `body`) VALUES (`$_POST[\'subject\']`, `$_POST[\'username\']`, `$_POST[\'body\']`)";

    returns the error:

    Unknown column \'\' in \'field list\'
    while my SCHEMA for that table is:
    CREATE TABLE news (

     newsid int(11) NOT NULL auto_increment,

     subject text NOT NULL,

     username text NOT NULL,

     posted timestamp(14) NOT NULL,

     body longtext NOT NULL,

     PRIMARY KEY  (newsid)

    ) TYPE=MyISAM;

    Thanks guys,

     

    LiamG.

  4. First, it says \"Print\" because of the line [php:1:6c27594e10]print \"Connected!\";[/php:1:6c27594e10]If you don\'t want it to say that, delete the line! YAY! One down.

     

    Next, it says array for a reason unknown to me, however if you put a @ before the comment mysql_fetch_array you might find it will supress that. I don\'t REALLY know though.

     

    HTH,

     

    LiamG.

  5. Call me dumb, call me stupid. Go ahead, make my day.

     

    I know how to do this, I just have a brain that loses cells often. As Homer once said, \"I don\'t wanna take an Adult Ed class Marge, coz everytime I learn something new, it pushes something old out of my brain. Like the time I took a wine tasting class and forgot how to drive\".

     

    Anyway, as we all know (and love) that with mySQL, the DATE format is in YYY-MM-DD. YAY!

     

    I have an $sql query:

    [php:1:83022e15d7]

    $sql=\"SELECT * FROM `table` WHERE 1 AND `category` = \'wateva\' ORDER BY \'date\'\";

    [/php:1:83022e15d7]

    Now, I want that to display, DD-MM-YYYY.

     

    Yet again, call me dumb and stupid, how do I do that?

     

    Thanks,

     

    Liam Geteu.

×
×
  • 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.