Go Back   CodingForums.com > Search Forums
Reload this Page Search Results

Before you post, read our: Rules & Posting Guidelines

Page 1 of 19 1 2311 Last »
Showing results 1 to 25 of 470
Search took 1.14 seconds. Search: Posts Made By: bauhsoj
Forum: MySQL 10-12-2011, 09:37 PM
Replies: 10
Views: 600
Posted By bauhsoj
Re-arranging the query and removing the...

Re-arranging the query and removing the memberships JOIN fixed the problem.

Thanks! :)
Forum: MySQL 10-10-2011, 09:44 PM
Replies: 10
Views: 600
Posted By bauhsoj
Each product can be in multiple categories so...

Each product can be in multiple categories so have multiple entries in the products_categories table. Not all categories are available to public view, so products whose products_categories are in a...
Forum: MySQL 10-10-2011, 09:32 PM
Replies: 10
Views: 600
Posted By bauhsoj
MyISAM on MySQL 5.0.92. It is a one-to-one...

MyISAM on MySQL 5.0.92.

It is a one-to-one between categories and products_categories. However, products to products_categories is a one-to-many relationship.

Honestly, I've never had to deal...
Forum: MySQL 10-09-2011, 04:23 PM
Replies: 10
Views: 600
Posted By bauhsoj
Tried that. Still not working. I didn't...

Tried that. Still not working.

I didn't start getting the error until I added this join into the mix:
LEFT JOIN
(SELECT id,
AVG(vote_value) *...
Forum: MySQL 10-08-2011, 03:51 PM
Replies: 10
Views: 600
Posted By bauhsoj
Question Too many joins causing unknown column error

When I try to do the query below I end up with error #1054 - Unknown column 'products.id' in 'on clause'

SELECT *
FROM products,
products_categories
LEFT JOIN categories
...
Forum: MySQL 06-16-2010, 09:16 PM
Replies: 5
Views: 1,136
Posted By bauhsoj
There aren't any unique fields. I just want the...

There aren't any unique fields. I just want the combination of all three values to be unique. Will that work for the solution you posted?
Forum: MySQL 06-16-2010, 07:36 PM
Replies: 5
Views: 1,136
Posted By bauhsoj
No, ignore it entirely. This has to be mirrored...

No, ignore it entirely. This has to be mirrored to two different servers by the same script and getting rid of the duplicates is becoming a pain.
Forum: MySQL 06-16-2010, 07:24 PM
Replies: 5
Views: 1,136
Posted By bauhsoj
Question Insert only if no duplicates

I have a table named "categories" with three columns:
login
categoryid
category

Some times categories need to be added automatically based on retrieved data. I need an efficient query that...
Forum: PHP 08-14-2009, 07:34 PM
Replies: 2
Views: 3,040
Posted By bauhsoj
Ha! I saw this very post on the page and totally...

Ha! I saw this very post on the page and totally missed the significance! Thanks so much for pointing this out. It fixed my problem! :D
Forum: PHP 08-14-2009, 04:20 PM
Replies: 2
Views: 3,040
Posted By bauhsoj
ZipArchive::open always fails with ER_OPEN (11)

Everytime I try to do the following:
$zip = new ZipArchive();
$zip_opened = $zip->open($zip_dir . $time . '.zip', ZIPARCHIVE::OVERWRITE);

if ($zip_opened !== true) {
trigger_error('Could not...
Forum: PHP 04-07-2009, 10:26 PM
Replies: 1
Views: 1,494
Posted By bauhsoj
Correction, although phpinfo() shows it as...

Correction, although phpinfo() shows it as loaded, Xdebug does not work at all. :(
Forum: PHP 04-03-2009, 03:59 PM
Replies: 1
Views: 1,494
Posted By bauhsoj
XDEBUG_PROFILE will not start profiler

I cannot get XDEBUG_PROFILE=1 to trigger the profiler when I use it in a URL. It never generates the cachegrind output. I have tried this on Linux running Apache 2.2.11 and PHP 5.2.8 with Xdebug...
Forum: Post a PHP snippet 02-03-2009, 06:52 PM
Replies: 1
Views: 4,515
Posted By bauhsoj
Thanks! This is exactly what I was needing. Those...

Thanks! This is exactly what I was needing. Those one line errors were driving me nuts! :thumbsup:

Do you have one of these that will work for error logs?
Forum: HTML & CSS 04-17-2008, 10:51 PM
Replies: 8
Views: 1,932
Posted By bauhsoj
Thumbs up I went with this one and after some tweaking it...

I went with this one and after some tweaking it worked beautifully:
http://www.pmob.co.uk/temp/3colfixedtest_sourcenone.htm

Thanks for pointing me in the right direction!
Forum: HTML & CSS 04-12-2008, 01:12 PM
Replies: 8
Views: 1,932
Posted By bauhsoj
At the moment I have his example full implemented...

At the moment I have his example full implemented so there is no absolute positioning.

Aside from the right column flying to the left of the screen when a word that is too long for it is entered,...
Forum: HTML & CSS 04-12-2008, 04:27 AM
Replies: 8
Views: 1,932
Posted By bauhsoj
Your layout is terrific but adding a certain...

Your layout is terrific but adding a certain length of unspaced characters to the right column that is too long for it to fit causes the entire column to be flung to the lower lefthand side of the...
Forum: PHP 04-08-2008, 12:56 PM
Replies: 0
Views: 675
Posted By bauhsoj
Question Getting CURL to return unbuffered line data

I need to use CURL to return data fetched from a server. However, I am faced with a very slow server that requires a login beforehand which can thereafter be stored in a cookie for a period of time....
Forum: HTML & CSS 04-05-2008, 01:14 AM
Replies: 8
Views: 1,932
Posted By bauhsoj
Making the columns relative proves to be a...

Making the columns relative proves to be a problem in that case. I need the center column to be in the document before anything else because that holds the document's main content. This is done for...
Forum: HTML & CSS 04-04-2008, 10:52 PM
Replies: 8
Views: 1,932
Posted By bauhsoj
Question Positioning at bottom of screen instead of page

I am testing a three column layout with a header and a footer using only CSS. Ordinarily it works fine but when the center column has less height than the left or right columns (due to amount of...
Forum: PHP 02-22-2008, 10:56 PM
Replies: 0
Views: 1,049
Posted By bauhsoj
Question Using CURL cookies from previous sessions

I am trying to create a PHP script that will login to a site by visiting one page and then access another protected page on that site. This is all easy enough to do. However, I want to know how I can...
Forum: MySQL 02-14-2008, 09:32 PM
Replies: 1
Views: 849
Posted By bauhsoj
Question Point of combined indexes

What is the point of combined (multi-column) indexes and how can I best use them to speed up queries under different circumstances?
Forum: MySQL 02-14-2008, 12:48 AM
Replies: 2
Views: 851
Posted By bauhsoj
Limiting by dates

I have here what should be a no brainer, and perhaps it is the lack of sleep and the long hours today, but I need someone to confirm for me that my logic with the following is on target.

If I want...
Forum: PHP 02-12-2008, 04:06 AM
Replies: 3
Views: 791
Posted By bauhsoj
I just noticed it only happens for mail received...

I just noticed it only happens for mail received in Outlook. I am not seeing this problem for mail sent to the likes of Thunderbird or Gmail.

Here is the code in case anyone has any idea why:...
Forum: MySQL 02-06-2008, 01:19 AM
Replies: 1
Views: 593
Posted By bauhsoj
Question Integrating a subquery only for rows retrieved

I have been doing a LEFT JOIN on two tables: items & prices

However, 10's of thousands of results can come back for a simple query resulting in a very slow query time. I found that I can...
Forum: PHP 02-05-2008, 02:40 PM
Replies: 3
Views: 791
Posted By bauhsoj
Question mail() adding extra lines

When sending mail through PHP using the mail() function I have noticed that plain text messages have two extra newlines at the top of the email message body. I have tried adding trim() to the content...
Showing results 1 to 25 of 470
Page 1 of 19 1 2311 Last »

 
Forum Jump

All times are GMT +1. The time now is 06:50 AM.