Search found 17 matches
- 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...
- 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.
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.
- 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...
- 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 ...
- 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...
- 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 ...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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)....
- 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?
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?
- Mon May 29, 2006 4:05 pm
- Forum: PHP - Code
- Topic: Output Shortcut
- Replies: 4
- Views: 349