mens
-
Posts
52 -
Joined
-
Last visited
Never
Everything posted by mens
-
mysql_connect client doesnt support authentication protocol requested by server
mens replied to devWhiz's topic in MySQL Help
Because bommobco is the user you are currently authenticated as. You are trying to change a password on an account, which is not the same as which you are authenticated as, and you do not have sufficient set of administrator privileges to do so. PS. to see the username of the connected user, run query SELECT USER(). -
Server time. But as said, use timestamps for age of entries; you could also set a trigger to update the time of the entry automatically. Creating a field called "date_added", and assigning it as INT(integer) with eight to ten lengths. Only then, would your query be: SELECT `charId` FROM queue WHERE shipType = '$charShipType ' ORDER BY entryTime ...and don't use the MySQL delimiter(;), it will spew errors as PHP doesn't support multiple queries in that fashion. Also, you then need to select it: eg. $rowNumber = mysql_fetch_assoc($rowNumber);/php] That would return an array of charId[i]s[/i], ordered by the time they were inserted.
-
A "wap site" is just like any other, it just uses a different set of markup rules. Most modern mobile browsers with WAP 2.0 uses XHTML Mobile Profile(a stripped down version of XHTML), but also supports other doctypes. Mobile sites tend to use less graphical content, and have fluid web styles so it can expand to the specific mobile browsers settings. You can try using your own mobile to go to "http://www.phpfreaks.com", it may not entirely be aligned properly into the browser, but it should show up none the less. A simple(very simple) idea to get you started is just using XHTML MP, with some PHP mixed into it. <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE html PUBLIC "-//WAPFORUM//DTD XHTML Mobile 1.2//EN" "http://www.openmobilealliance.org/tech/DTD/xhtml-mobile12.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en"> <head> <title>Hello world</title> </head> <body> <p> <?php echo 'This content printed out with PHP'; ?> </p> </body> </html> Source(s): http://en.wikipedia.org/wiki/XHTML_Mobile_Profile