tibberous

I have a record called post that has an auto id and an integer called owner. If a post is a root post (not a reply), I was it's owner value to be equal to it's id. Is this possible to do with one query, or does it have to be 2?

That looks perfect! Awesome man, thanks.

I have a site that I do not host about would like to add web stats to it. I was thinking something like what wordpress uses - thoughts?

Pretty sweet.

It really needs a better design - even the simplest of header / menu's, and a background / border would make the site a lot better.

Check it out: fourseasonsrefreshment.com Only 3 of the 6 pages are done - what do you guys think so far?

The image enlarging is neat, but it would have been a lot less annoying to just have it show up fully enlarged.

I could use joins, but what I was looking for is a way to get a result set like: id - name - phoneNumbers 1 - Dave - 555-555-5555, 555-555-5555 2 - Bob - 555-555-5555, 555-555-5555, 555-555-5555 So basically take and return multiple rows as a single value, almost like the count function.

Yeah, so if I have 100 users, I end up doing 101 queries. $result = mysql_query("select `id`, `name` from users"); while($user = mysql_fetch_assoc($result)){ $sresult = mysql_query("select * from phoneNumbers where owner=".$user['id']); // gets called 100 times // loop through phone numbers } Basically what I am trying to do is like a subquery, but where I turn several returned rows into one aggregate result.

I am, I'm trying to combine them into one record when I do the select - Otherwise, I have to do a query, then do another query for each result, to get the phone numbers.

I have two tables, users and phoneNumbers. A user can have any amount of phone numbers. I was to select all of a users phone numbers for a user, as a comma separate field. So, if Joe was my users name, and have 3 phone numbers, my recordset would look like: id: 4 name: Joe phoneNumbers: 555-5555, 567-7890, 754-9000 I was thinking something like: select `id`, `name`, (select --- from phoneNumbers where phoneNumbers.owner=users.id) as `phoneNumbers`from users where `name`='Joe'

Thanks

I have an array, and I need to know what the current index is. So, lets say I do: $arr = array(); $arr[] = 'one'; $arr[] = 'two'; $arr[] = 'three'; I next index would be 3. I can find that by going count($arr). But, what if I unset an element in $arr? Then count would not return 3. Any idea how to find what the next available spot is?

What do you think? jdwaterproofing.com Just looking for design critique - not worried about xhtml / css / coding standards.

I am looking to add a comments/message board system to my site. Basically I am laying the site out so that each of my projects has one page dedicated to it. What I am looking for is a comment system that allows responses to individual comments - so someone can ask a question and get replied to. What I'm really looking for is something that that is cool looking, maybe using ajax / jquery. This is a good example, but it is written in Python of all things... http://scrumptious.tv/

Fixed. Since c:\dev is outside the apache folder, I had to add this to the main httpd.conf file: <Directory "C:/dev"> Order allow,deny Allow from all Options +Indexes </Directory> The +Indexes was needed, but since it's just my dev directory, I figured I might at well turn it on.

In httpd-vhosts.conf: <VirtualHost 127.0.0.3:80> ServerAdmin trenttompkins@site.com DocumentRoot "C:/dev" ServerName 127.0.0.3 ServerAlias 127.0.0.3 </VirtualHost> in c:\dev I have a file called index.htm If I go to: http://127.0.0.3 I get a forbidden error And if I go to: http://127.0.0.3/index.htm I get: You don't have permission to access /index.htm on this server. Any idea what would be wrong? The regular server works.

Awesome! That's exactly what I was looking for.

I have the nameserver on an important site setup to a nameserver hooked to a domain name that I need to use for something else. I want to switch it's nameserver to a different one, but was hoping I could make sure the nameserver worked before I switched it. To explain better: myimportantapp.com uses ns1.domainineed.com and ns2.domainineed.com I create two new nameservers. Is there a way I can test the new nameservers, without changing it for anyone else?

It's a dedi. I think what happened i that a guy that used to do work for the company got a virus that stole his FTP passwords. I ended up just restoring the sites from some old backups.

I have a couple website that have had malware code added to them. In general, the code is either an iframe, an externally linked javascript file, or an eval( base64_decode( 'u65r...')). I thought about just using regex, but I was wondering if there is already a program to remove it.

I am putting a CMS thing together and need to add a calendar. I don't need anything too elaborate, was thinking something something simple that ran off a single table. That way I could rewrite the admin code into my admin, but use the frontend it comes with. Any recommendations?

I actually used that as the basis for a backup system I wrote. I was using wget but it had trouble if a directory was overly nested, so I ended up writing the entire system as a PHP script that wrote out and executed a WinSCP script. I'm pretty sure you can't use it to connect directly to another computer, at least without running an FTP server.

For some reason I always have trouble with my personal site. A good idea is probably to get the content together before you do anything, at least then you'll know what kind of information you need to make room for.

I use WinSCP all the time. Is there a way to do a direct transfer with it?