neylitalo

It's a "security threat" (not much of one), but it is also an essential part of AJAX, the latest buzzword in the tech world. So, out of curiosity (sparked by ober), how many of you disable Javascript? I don't. See this post for more details.

[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] * FROM `table_name` WHERE (xyz AND wer) OR mnb [!--sql2--][/div][!--sql3--]

if you're planning on deploying the application, then yes, you would have to have it on all day. However, if you're just using it as a development machine, it would be on anyway, right? You're using it to develop the application! But somehow I think you want to deploy it. If you haven't already, you need to find a web host (or a server in the intranet) that has Apache (or some other web server), PHP, and MySQL installed. Some good web hosts with PHP and MySQL: 1and1, Inc. (http://www.1and1.com) (one that I've used for client's sites) Ace-Host.net (http://www.ace-host.net) (the one I'm using now) Web Host Freaks (http://www.webhostfreaks.com) (the owners of this site and it's sisters)

I think I remember reading the thread where 72dpi was in the process of designing the new site... I wasn't around when it happened, but I read it. On-topic, I'm going to play with AJAX ASAIGH. (translates to: as soon as I get home ) I'm hearing all this hype about it and can't resist the coolness of the whole idea... imagine not even having to refresh! Yay!

I know absolutely nothing about AJAX, but I would possibly be able to help out with some small stuff. I don't have a lot of free time, but I could do some stuff when I do.

I see nothing wrong with that. But why can't you just make the username primary, and then check the username to do the UPDATE?

how are you trying to access the computer, from the remote computer? Give details about the setup. Is the server behind a firewall? What URL are you using to access the server? Give any relevant details.

You don't find MySQL for "your apache", but rather for your platform. Link to MySQL for Windows. You'll have to pick the mirror. phpMyAdmin can be found at (drum roll) http://www.phpmyadmin.net for completely free.

The documentation is wonderful for this. Apache install PHP install MySQL install. I suggest you install them in that order. Once you get it going, feel free to post with questions.

[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--]RENAME TABLE `table_original` TO `table_new` [!--sql2--][/div][!--sql3--] MySQL manual for RENAME TABLE

Please take care to post in the correct forum - read the descriptions of each board below the board's title. I've moved this one to MySQL Help. Thanks!

no problem - I found it in my travels of the Maguma website, and I was so impressed that I couldn't resist letting everybody know. When you find a piece of software like that, you just can't keep it a secret. EDIT: I've been using PHP Designer 2005 lately, too, but Maguma kicks the crap out of it.

I would suggest adding a field for every possible "extra" in the car, and set it to 0 or 1 depending on if it has the feature.

ober, we're talking about two different products - you're talking about Maguma Workbench; I'm referring to Maguma Studio. I know what you mean about the memory errors - Workbench was yelling about that all the time. However, Studio has no such problems. Studio does look kind of childish, but it's not enough to cause a problem for me. see this link to get to the Maguma Studio page.

After much trial-and-error, I have discovered an IDE that is, in all aspects, beautiful. For those of you who have tried Maguma Workbench and said "I would love to use it - but I don't want to spend $90-$250", this is for you. Maguma Studio is a free IDE that is basically Workbench without all the little modules that make your life somewhat easier. Just a few of the little features of Maguma Studio: - Syntax highlighting (naturally) - PHP parsing, so you can test your scripts before deploying them - Auto-indent code blocks (and RETURNS THE INDENT when you close the block!) - Code-completion (with function syntax) - USER-DEFINED function syntax - AMAZING! - Open Source And if you feel like spending $25, you can - Use breakpoints - Encode your code - use CVS accounts - manage your FTP servers and probably more that I have yet to click on and see the "Only available in the Pro or Desktop versions etc. etc." dialog for. And I believe it's out there for Linux as well - can anybody confirm this? I think they only allow you to download the file that matches your HTTP_USER_AGENT or something. To learn about Maguma Studio - http://www.maguma.com/Maguma_Studio.502.0.html You may have to register, but it's free and takes about 30 seconds. Find the download for Studio about halfway down the page at http://support.maguma.com/download I know I'm going to dig up the $25 for the Pro version as soon as I can.

the LIMIT clause is messed up... This query is trying to get 20 records, starting at the -20th record. That isn't going to work. The first number has to be >= 0. what is the purpose of this query?

please point out line 98... and in the future, enclose your code in the BBCode PHP or CODE tags. Preferably [ PHP ], without the spaces. Look at the buttons above your post area. I'm thinking you would want something like this... [!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--][span style=\"color:#0000BB\"]<? $host [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"mysqlservername\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$username [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"username\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$password [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"password\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$db [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"databasename\"[/span][span style=\"color:#007700\"]; @[/span][span style=\"color:#0000BB\"]mysql_connect[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$host[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$username[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$password[/span][span style=\"color:#007700\"]) or die([/span][span style=\"color:#0000BB\"]mysql_error[/span][span style=\"color:#007700\"]()); @[/span][span style=\"color:#0000BB\"]mysql_select_db[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$db[/span][span style=\"color:#007700\"]) or die([/span][span style=\"color:#0000BB\"]mysql_error[/span][span style=\"color:#007700\"]()); [/span][span style=\"color:#0000BB\"]?>[/span] [/span][!--PHP-Foot--][/div][!--PHP-EFoot--] And you shoud rename db.inc to db.inc.php or something ending with .php. If you leave it as .inc, I could just navigate to http://www.yourdomain.com/db.inc and it would show me the username and password for your database server.

you need to use absolute paths. (I think that's what sikofitt's trying to say) ie: c:\php\ext

Please clarify... I'm confused.

moving to MySQL forum...

ryan's right - I made an oops. Mattyspatty - I have the following database structure (never mind that it's different than yours; the idea is the same) mysql> select * from user_stats; +----------+--------+--------+--------+--------+ | username | stat_1 | stat_2 | stat_3 | stat_4 | +----------+--------+--------+--------+--------+ | matty | 0 | 1 | 2 | 3 | | bart | 0 | 1 | 2 | 3 | | timmy | 0 | 1 | 2 | 3 | | neal | 0 | 1 | 2 | 3 | +----------+--------+--------+--------+--------+ 4 rows in set (0.00 sec) I run the following query: [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] * FROM user_stats WHERE username LIKE '%m%' OR username LIKE '%t%' [!--sql2--][/div][!--sql3--] I get the following results: mysql> select * from user_stats where username like '%m%' or username like '%t%'; +----------+--------+--------+--------+--------+ | username | stat_1 | stat_2 | stat_3 | stat_4 | +----------+--------+--------+--------+--------+ | matty | 0 | 1 | 2 | 3 | | bart | 0 | 1 | 2 | 3 | | timmy | 0 | 1 | 2 | 3 | +----------+--------+--------+--------+--------+ 3 rows in set (0.00 sec) So do I. The IE one is true, too... somebody actually thought it was broken, but it was a "feature" Way to go, Bill! EDIT: MySQL version 4.1.14

try the following: [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] DISTINCT * FROM user_stats WHERE username LIKE '%m%' AND username LIKE '%t%' [!--sql2--][/div][!--sql3--] The DISTINCT will make it only return unique values. EDIT: actually, you may want to only return a specific column... I'm not sure how the DISTINCT is going to behave with multiple columns. Say, something like [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] DISTINCT username FROM user_stats WHERE username LIKE '%m%' AND username LIKE '%t%' [!--sql2--][/div][!--sql3--] EDIT (again): modified the queries for "incorrect" syntax... if you have an AND clause, you should say what column the second part of the WHERE needs to look at.

instead of using the shortened pathnames ("C:/Progra~1/hMailS~1/PHPWeb~1/") use the full path names. ("C:/Program Files/hMailS...etc"). You have to put the actual name of the folder, not the shortened one.

Haha! Beautiful. Just beautiful. EDIT: AndyB, I feel your pain Off-topic-but-not-really, check out this picture. It's just too bad that it's a hoax :X

translates to: "I'm a newb..." Being young and good at the technology is nothing. Being old(er) AND good at new technology, though, that's super cool. I can't wait until I'm 50 and saying "Yep... you probably don't remember it, but I used to code in PHP!" and still keeping up with the new technology. I'm impressed with those of you who know how cool it is to have 9600 baud AND know how to write PHP, et al. Allow me to electronically shake your hand. SYN.