shenniko

Hi Aftermath, I think waht your trying to do cant be done without the use of Div's/Tables.. What i think your trying to do (correct me if im wrong) is something like below:- [u]title[/u]--------------------------------------------------------------------------------------------datestring So the Title is on the left hand side, and the datestring on the right hand side, both on the same line.. With HTML that cant really be done without the use of tables or Div's.. Also with the below code "<h6 style="align: right">" PHP might not like it 100% as you are using double quotes within double quotes... if you putting double quotes in a string you should really use single quotes for the start/end of the string.. e.g '<h6 style="align: right">' If i was right about the layout your looking for try something like below:- [code] $datestring = $day . $date . $month . "," . $year; if ($name && $tag) { echo '<table width="100%" align="left"><tr><td><u>' . $title . '</u></td>' . '<td align="right">' . $datestring . '</td></tr><tr><td colspan="2">' . $newdate . '</td></tr><tr><td colspan="2">' . $name . '</td></tr><tr><td>' . $tag . '</td></tr></table>'; } [/code] Shenn

Hi Guys, Need a little help.. I've got an XML page that im parsing into my MySQL Database, but the Date/Time is in Unix Date/Time... How Can i Convert the Unix Date Time, and insert it into my MySQL Database??? Ive tried the below code, but its not working.. [code] $sGMTMySqlString = gmdate("Y-m-d H:i:s", $availTime); $tParsedTime = strtotime($sGMTMySqlString . " GMT"); $Query = "INSERT INTO tblresources (MyPlanet,MyName,MyType,MyCD,MyCR,MyDR,MyER,MyFL,MyHR,MyMA,MyOQ,MyPE,MySR,MyUT,MyAvail) VALUES (\"$MyPlanet\", \"$MyName\", \"$MyType\", \"$MyCD\", $MyCR, $MyDR, $MyER, $MyFL, $MyHR, $MyMA, $MyOQ, $MyPE,$MySR,$MyUT, $tParsedTime)"; [/code] And my MyAvail field in my MySQL DB is in DateTime format... Any Ideas? thanks in advance Shenn

Hi, I'm still learning PHP, and have had a look on the internet for a good tutorial on Parsing XML files to my MySQL DB, but i cant find any... Does anyone know of any good tutorials for Parsing XML data into a MySQL database? Thanks in advance Shenn

Hi Guys need a little help, Pretty new to MySQL and PHP, as i started learing ASP thought Access DB's... Ive created a sort of search function for my members section, so you can search by Username.. How do you create a "LIKE" statement? E.g say i enter Da into the search box, it will bring Everything back with "Da" in the database? All i need is the WHERE tblCharacter.Character LIKE '$Character'"; Or whatever the code is. thanks in advance shenn

Sorry for the quick noob question, but whats UNSIGNED/UNSIGNED ZERO FILL etc?? Thanks in advance shenn

Hi guys, Pretty new to MySQL, ive mainly been using Access DB to do most of my Database work. I've started building a PHP site with MySQL, and im a little stuck.. Which Collation should i be using? and whats the differance? Im using phpadmin to create all my MySQL tables and at the moment my database is auto setting the Collation to "latin1_swedish_ci". Also, on a side note, For my user profiles, im using TINYINT.. would that mean the max number of users it would go upto would be 9999? and if so would it be better for me to change it to BIGINT? (if i expect more than 9999 users to join my site?) Thanks in advance Shenn