gizmola

No, that will not work what you want is something like this: SELECT id, count(*) as countof FROM ( SELECT id FROM table WHERE city='delhi' and subjects LIKE '%math%' UNION ALL SELECT id FROM table WHERE state='Delhi' and subjects LIKE '%math%' UNION ALL SELECT id FROM table WHERE city='delhi' and (subjects LIKE '%math%' or qualifications LIKE '%math%' ) UNION ALL SELECT id FROM table WHERE state='Delhi' and (subjects LIKE '%math%' or qualifications LIKE '%math%' ) ) as allusers Group by id ORDER BY countof DESC

You do not understand what trim does. Perhaps you should re-read the description of the function where it says: Notice the emphasis I've added to 2 words in that description.

Try this simpler regex: '/(width="[^"]+")/i',

Insert a row into the admin table, which you told me is empty.

Did you expend so much as 1 minute looking around before you posted this? http://www.phpfreaks.com/forums/index.php?topic=119433.0 There's also a thread on editors/IDE's over on flingbits: http://forums.flingbits.com/topic/38-php-editors/

If you want a link to do nothing, just have the href url be "#".

One query, order by locationID, typical while mysql_fetch loop for the rows in your php code and use a variable that declare outside the loop which you compare to the locationID for the row you just fetched. When it changes you know it's time to do whatever special stuff you need to do for each individual locationID.

I'd do: foreach($xml->tripDetails->tripDetail as $tripDetail) { $t = $tripDetail.attributes(); echo $t['type']; }

Do you have mysql command line (shell) access to your server, or do you have a phpMyAdmin installation you can use? You need to insert a row for the admin. The code appears to be working correctly as best as I can tell from your description of the situation. Since there is no row, it just shows you the error msg.

That entire script is 100% dependent on jquery. $(document).ready is jquery. Best/fastest way is to source it from the Google CDN: http://docs.jquery.com/Downloading_jQuery#CDN_Hosted_jQuery

Let's see the query you currently are using.

Well... this code makes use of jquery. I didn't look that carefully at your script but I don't see where you're including the jquery library. Also, your page snippet is not well formed, and there is none of the divs that are referenced or for that matter markup of any kind. It's not going to work if you don't have a well formed html document.

Just for completeness the answer to this question is to use the php DateTime class which is not limited in range to 32 bit timestamps.

In the contentlocker.php script comment out the header() call and see what happens.

Is there a user in the admin table? Based on looking at this code, the username and passwd are stored in plaintext, so there shouldn't be much question about it.

Did you try debugging what is going on using firebug?

You seem to have a bunch of different questions. First off, your questions about mailing can be most simply addressed by reading mail. I personally wouldn't want a system where I had to individually approve every user. Usually people automate that by emailing a validation url that the user can then click on or type into a browser. As for your issues, again, you need to provide a code snippet of what you have that isn't working (your Login script?), as well as any errors the script is generating.

Yes. This is not an issue, even for a table that has an auto_increment key, because mysql will only auto_increment when you omit the auto_increment column in the INSERT or pass a NULL value. dawsha's code looks like it could work for you.

I took out your database credentials --- i don't think you really want the world to know them. I'm not sure what you are asking. Clearly the things you want to do are typical, so there's no question of whether or not they can be done with php. When you "login" to your system, that has nothing to do with the mysql user/password that would be configured for use by php. We really can't help you without specific code and specific errors.

I don't know of anything nor would I hold my breath for such a tool. With phpMyAdmin freely available there's just not much of a market for this type of program. Also MySQL provides the MySQL workbench for free, so there's very few commercial tools (mysqlyog comes to mind) out there for mysql. I used to maintain a list of them on the old mysqlfreaks site, but that went the way of the Dodo and so did the list. Most MySQL servers are locked down to localhost access for security reasons, and it's an effort to even get the server configured to accept client application connections, which probably further contributes to the lack of demand. Every host that provides mysql defaults to phpMyAdmin in their cpanel.

Write a conversion program. Do you know PHP?

Read this: http://www.mnot.net/cache_docs/

What is the document root for apache set to. Run: And check that the configuration matches what you expect. It doesn't seem like the doc root matches what you think it does.

You didn't provide the output you are getting.

You can run Parallels or VMware or Sun virtualbox which is free. You still need a licensed copy of windows to install, but it's a good solution, and you can actually test against various different versions of windows and different IE versions by creating multiple virtual machine images.