8,966 Posted Topics
 | |
| | Make sure you are joining on PK's. Since you check common=0 I'd put an index on that column too. Additional option could be to create a view to hold all the information, so you could query the view instead of all the tables.  |
| | rch1231's solution will work if table2 and table3 are exactly the same. So, if they are not, you need to make sure to change the output so they do match. |
| | [QUOTE=rch1231;1163709]The other problem you are going to run into is that you are using reserved words (variable types ) as field names. timestamp and text are both variable types.[/QUOTE] As long as you keep using the backticks in your queries, this will not be an issue. |
| | You can use the trackPageview() method to record what you want. What exactly do you want ? |
| | Re: Smarty templates If this code is in a default smarty template then the curly brackets (from the stylesheet) denote a template variable. Either change the curly brackets, use {literal} or put the CSS in a separate file. Note that using javascript in a smarty template has the same issue. |
| | Sounds too obvious, but did you put a link to the .js file in the html head ? |
| | You are missing a dot between mysql_error and your string to concatenate them. [code] $result=mysql_query($connect, $sql) or die(mysql_error() . "Query FAIL."); [/code] |
 | I like InnoDB. Use it to contain several booking websites' data. It got very large, although not millions per day. Never had any corrupt data issues. With databases with these sizes I prefer to switch to postgres, oracle or mssql (depending on the customer of course). |
| | I use Polystyle, but it doesn't offer what you ask. But you could ask their support. It may be a feature I haven't found yet (since I don't code like that). |
| | [url]http://php.net/curl[/url] |
| | You see the two "bar" divs. If you make them float left it may be the effect you want. |
| | [url]http://cufon.shoqolate.com/generate/[/url] With Cufon you can turn your font into a javascript file and use it on any site you like. There is also Sifr and Flir, but Cufon is my favourite choice. |
| | Re: Pagination help Something like this, output of the code below: [url]http://www.pritaeas.net/public/php/pagination/[/url] [code] <html> <head> <style> .current { font-weight: bold; color: red; } .previous { } .next { } </style> </head> <body> <?php function createNavigation($current = 1, $total = 1, $enclose = 2, $endpoint = 2) { if ($current < 1) $current = … |
| | [code] $sql = "Select * from table1 where table1.field1 not like '%$name%' "; [/code] |
| | If there is really no additional description in the database, I guess you ronly solution would be to check for specific headers. All file formats have them. Perhaps you kind find a piece of code that does this for you. |
| | |
| | You probably want to set them to width: 100%, margin: 0, padding: 0. |
| | I think the problem you are facing arises from the fact that you use names (varchar) as foreign keys. In most situations you would have a PK integer field, which links all the tables together. The name would be just a column, which could then be easily changed. |
| | You can use a UNION. Sort ASC the ones > 0 and union them with the ones that are zero. |
| | Can you show a code sample, so we can see what you are doing ? Are you calling mysqldump or something similar ?  |
| | There might be a better way, but this should work: [CODE] select batch_number, sum(ExpCounter) from ( select batch_number, sum(acount)/aSize as 'ExpCounter' from HMIExpCount2 where aDate >= '03/01/2010' and aDate <= '03/02/2010' and batch_number = '118705' group by batch_number, asize ) [/CODE] |
| | I find this a strange construction: [code] if ($result1=mysql_query($w)) { echo "nice"; } else { echo "shit"; } while($row1 = mysql_fetch_assoc($result1)) { extract($row1); $first[]=$course_code; echo "<p>$course_status</p>"; } [/code] First you determine if the query has failed or not. Then you execute the while, not taking into account the return value. … |
 | Re: hange page Meta refresh: [url]http://webdesign.about.com/od/metataglibraries/a/aa080300a.htm[/url] |
 | The Microsoft Platform Installer has Expression Web in it. Have used it from time to time. Works fine. |
| | [url]http://www.packtpub.com/jQuery/[/url] |
| | Start with the tutorials at w3schools. The specific CSS you are looking for is :hover |
| | |
| | How do you create your feed ? Are you using a tool, or did you program it yourself. |
| | |
| | You could sort by DAYOFWEEK() which takes a date column as input. Your output would be 1 .. 7 which you can map to the day name as you please. [url]http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_dayofweek[/url] |
| | |
| | That happens when the scrollbar disappears on short pages ...  |
 | In HTML you can <embed> some types of files. However, most browser will not allow you to run an exe file because of security issues. |
| | Do you just want to draw all points that you have ? Connect them by a line ? Or determine the actual circle ? |
| | Re: parse error [code] $result = mysql_query("SELECT * FROM `war` WHERE `user_name`='".$_POST['u_name']."' "); [/code] |
| | The normalization is okay at this point. Is this going to be a live system, or just a test ? Because if you want to book rooms, you'll need to know what rooms are available. Suppose a room cannot be sold due to maintenance. |
| | You are missing the SELECT before the WHERE. See the first example here: [url]http://dev.mysql.com/doc/refman/5.1/en/insert-select.html[/url] |
| | [url]http://www.cssstickyfooter.com/[/url] |
| | For a prototype, I think it's a nice piece of code. Hopefully you can get this project going, so it can evolve to a much mature version. Good luck. |
| | Re: Reg Exp problem If it is not at the beginning of the line, then there is at least one character in front of it. So, start with ^.+ |
| | Have you tried adding the X-Mailer header ? You can find it on the php.net mail page. |
| | How do you handle the AddressableElement ? In your example there are two. Are there always two and appear both on one line ? Or are other situations possible. Anyway, start with this: [code] <xsl:template match="Transaction"> <xsl:value-of select="@TransactionID" disable-output-escaping="yes" />, <xsl:value-of select="@EventDate" disable-output-escaping="yes" />, </xsl:template> [/code]  |
 | Re: multiple tables Select * tries to concatenate all the columns from all the tables, but every column has a dev_id, he cannot return that 4 times. Change it to SELECT tbl_dev_dilligence.*, tbl_dev_dilligence_business.*, tbl_dev_dilligence_director.* (I think) A lesser problem: tbl_dev_dilligence.dev_id = '115' appears twice. I'm guessing one should be tbl_dev_dilligence_business |
 | Simon, it would be really hard for someone here to guess what's going on. I think your best bet at the moment is a change in the userlist. Check whether the user is already in the list before adding (you can use IndexOf). |
| | [code] <xsl:variable name="URL"> <xsl:value-of select="catalog/cd"/> </xsl:variable> <a href="{$URL}"> Link to catalog </a> [/code] |
| |  |
| | I think it should be this: [code] SELECT CountryName, COUNT(*) AS count FROM country c,votes v WHERE c.ID=v.CountryCode GROUP BY v.CountryCode ORDER BY count DESC LIMIT 3 [/code] |
| | Can you tell us where your links are in the xml and where you want them in the output ? I'm not quite sure what you are trying to achieve. |
| | Read the warning: [url]http://php.net/manual/en/language.types.float.php[/url] |
The End.