Search found 17 matches

by r_barlow
Tue Aug 15, 2006 10:30 am
Forum: Databases
Topic: Multiple Query Statement
Replies: 1
Views: 205

Multiple Query Statement

Hey, Is there a way to string together multiple queries into one statement? Ex: ------------- INSERT INTO news (article, date) VALUES ('blah blah', CURDATE()); INSERT INTO news (article, date) VALUES ('blah blah blah', CURDATE()); ------------- In Query Browser you have to execute each line separate...
by r_barlow
Mon Aug 14, 2006 1:59 pm
Forum: PHP - Code
Topic: MySQL Query Error Result
Replies: 2
Views: 303

MySQL Query Error Result

Hey,

If you try do an update query using the mysql_query() function that has an error in it... is there anyway to capture that error?

if i do something like

$result = mysql_query($sql);

$result will only return the number of affected rows, and if there is an error it doesn't return anything.
by r_barlow
Thu Aug 10, 2006 11:21 am
Forum: General Discussion
Topic: New PHP Site, Old Google Indexes
Replies: 3
Views: 434

Ahh yeh I guess thats probably it. I have another quick question that is related. For the meta description/keywords, is it good to have different ones for every page in the website? I think somebody told me that it's ok to have the same description for each page but different keywords. Just checking...
by r_barlow
Thu Aug 10, 2006 10:43 am
Forum: General Discussion
Topic: New PHP Site, Old Google Indexes
Replies: 3
Views: 434

New PHP Site, Old Google Indexes

Hey, I've recently redeveloped the company website from a static HTML page to a dynamic mysql/php one. The page has been live for about a month or so now and I've noticed something pretty disturbing. When I search for my site in google using the "site:" before the URI, the list of indexes ...
by r_barlow
Tue Aug 08, 2006 6:26 pm
Forum: Databases
Topic: SQL Count Problem
Replies: 1
Views: 265

SQL Count Problem

When you are using a COUNT with a GROUP BY, how do you make it so this returns 0 if what you're grouping by doesn't have anything in the condition. For example: SELECT p.categoryid, COUNT(p.categoryid) FROM products p, product_categories pc WHERE p.categoryid = pc.categoryid GROUP BY p.categoryid; R...
by r_barlow
Thu Jul 06, 2006 11:42 am
Forum: Javascript
Topic: Transparent Flash
Replies: 0
Views: 1220

Transparent Flash

Hey, I have a flash element that overflows part of the page so I need the bg transparent. The code I have has worked perfectly for all browsers/browser settings/system settings I have tested with... but of course when my boss viewed it at home... the background wasn't transparent. He's using IE but ...
by r_barlow
Tue Jul 04, 2006 1:57 pm
Forum: Javascript
Topic: Windows Accessibility Test
Replies: 3
Views: 1551

I've already tried the whole transparency thing and trying to edit the images i have is next to impossible. Also, I have some flash content that has the same issue.. its already transparent back but some of the buttons have granient backgrounds which I figured i'd replace with white if i can do this...
by r_barlow
Tue Jul 04, 2006 12:26 pm
Forum: Javascript
Topic: Windows Accessibility Test
Replies: 3
Views: 1551

Windows Accessibility Test

Is there a way to determine whether windows accessibility options have the "ignore" colors feature selected? Usually, my background is redish but when this option is selected, it turns to white. Several of my images have the redish background in order to appear transparent. If there is a w...
by r_barlow
Fri Jun 16, 2006 5:26 pm
Forum: PHP - Code
Topic: Session Variables
Replies: 8
Views: 632

Thanks, that works but now I have included code to connect to a mysql db in order to validate the login and I get this error on session_start() Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\Program Files\Apache Softw...
by r_barlow
Fri Jun 16, 2006 3:44 pm
Forum: PHP - Code
Topic: Session Variables
Replies: 8
Views: 632

Session Variables

I'm trying to create session variables to hold a username and password. The following code generates the following error: $user = $HTTP_POST_VARS['user']; $pass = $HTTP_POST_VARS['pass']; session_start(); session_register("username"); $username = $user; Warning: session_start() [function.s...
by r_barlow
Fri Jun 02, 2006 1:06 pm
Forum: PHP - Code
Topic: Ensure DB Connection
Replies: 4
Views: 429

Thanks a lot for the help. Yeh I'd do it that way but I don't know if all of my pages are going to be querying information. I just want to double check to make sure everythings fine before querying on this page instead of relying on the page that is including it. Everything works beautifully now tho...
by r_barlow
Fri Jun 02, 2006 11:01 am
Forum: PHP - Code
Topic: Ensure DB Connection
Replies: 4
Views: 429

Ensure DB Connection

Hey, I have a page I'm including in several others that lists information from MySQL. Since all of the pages that will have this page included will be querying information as well, I don't want to bother opening a new connection to the database. The problem is I want to test whether the connection i...
by r_barlow
Thu Jun 01, 2006 4:03 pm
Forum: Javascript
Topic: xhtml <img> name
Replies: 4
Views: 895

Thanks a lot!! If getElementById isn't very good... how should I access the images? right now I have: function imgOn(imgName, prodName) { if (document.images) { document.getElementById(imgName).src = prodName.src } } function imgOff(imgName) { if (document.images) { document.getElementById(imgName)....
by r_barlow
Thu Jun 01, 2006 2:19 pm
Forum: Javascript
Topic: xhtml <img> name
Replies: 4
Views: 895

xhtml <img> name

Hey,

I have an image which I've set its name property because its involved in some javascript rollover.

When I try to validate the page in XHTML strict it says the name has been deprecated.

If I can't give the <img> a name, how am I supposed to access it with javascript?
by r_barlow
Mon May 29, 2006 4:05 pm
Forum: PHP - Code
Topic: Output Shortcut
Replies: 4
Views: 349

Awesome.. thanks a lot!!