Forum: MySQL  Mar 3rd, 2008 |
| Replies: 4 Views: 284 Re: Help please
SELECT X.key, coalesce(a,0) AS ao, b FROM B RIGHT JOIN
(SELECT * FROM B ORDER BY b LIMIT 0 , 100) AS X
ON B.key = X.key ORDER BY ao desc LIMIT 0, 50
is what I ended up with (I think...). This takes... |
| Forum: MySQL Mar 2nd, 2008 |
| Replies: 4 Views: 284 |
| Forum: MySQL Mar 2nd, 2008 |
| Replies: 4 Views: 284 Help please
Say you have 3 tables
A (Key, a)
B (Key, b)
C (Key, c)
How would you select say 10 from A ordered by a, from 50 from B ordered by b, from 100 from C ordered by c? All the keys represents the same... |
| Forum: Web Browsers Dec 20th, 2007 |
| Replies: 4 Views: 483 |
| Forum: Web Browsers Dec 15th, 2007 |
| Replies: 4 Views: 483 Complaint to the European Commission
Again, Microsoft is being accused of stifiling competition by releasing IE with it's OS. Maybe I'm turning over two pages at once, but wouldn't it more stifiling to not release it? How am I supposed... |
| Forum: Website Reviews Dec 13th, 2007 |
| Replies: 7 Views: 760 Re: My first website
I made my website in the first week of term and haven't revisited it since. Too busy with uni and that. Basically, my site has 5000 pages that I crawled off the web in 48 hours of continuous crawling... |
| Forum: Website Reviews Nov 21st, 2007 |
| Replies: 7 Views: 760 Re: My first website
I'll fiddle with the style-sheet.
I'd appreciate comments on my content from someone with good English skills. Also, any techs with a bright idea about extending functionality.
Please read the news? |
| Forum: Website Reviews Nov 17th, 2007 |
| Replies: 7 Views: 760 Re: My first website
I'll fiddle with the style-sheet.
I'd appreciate comments on my content from someone with good English skills. Also, any techs with a bright idea about extending functionality. |
| Forum: Website Reviews Nov 15th, 2007 |
| Replies: 7 Views: 760 My first website
This is my first web site and is no where near complete, although that is in terms of content. Could I have feedback and ideas please.
http://www.1stclick.co.uk |
| Forum: PHP Oct 15th, 2007 |
| Replies: 9 Views: 620 |
| Forum: PHP Oct 15th, 2007 |
| Replies: 9 Views: 620 Re: Regular expressions and formatting
Also, you'd need something like:
if (instr("<br />", substr($row[0],$i,80))){
$i+= 80-(instr("<br />",substr($row[0],$i,80))+5);
}
In that fix I put up to stop you wrapping half way through a line... |
| Forum: PHP Oct 15th, 2007 |
| Replies: 9 Views: 620 Re: Regular expressions and formatting
I read this on a forum somewhere:
Either your clean_var or mysql_less_safe functions are probably escaping the \r and \n characters using addslashes or mysql_real_escape_string. If that's the case,... |
| Forum: PHP Oct 15th, 2007 |
| Replies: 9 Views: 620 Re: Regular expressions and formatting
$qry = "SELECT Post FROM POST WHERE ID = " . $_GET['threadID'];
$rset = mysql_query($qry);
$row = mysql_fetch_array($rset);
echo $row[0];
I haven't really looked at the problem with a word being... |
| Forum: PHP Oct 14th, 2007 |
| Replies: 9 Views: 620 Re: Regular expressions and formatting
Changed it to
nl2br(str_replace($bad,$good,mysql_real_escape_string($_POST['Post'])))
but still no <br /> tags are ending up in the database. The POST is coming from a textarea, if this... |
| Forum: PHP Oct 13th, 2007 |
| Replies: 9 Views: 620 |
| Forum: PHP Oct 11th, 2007 |
| Replies: 9 Views: 620 Regular expressions and formatting
I'm trying to get some post data formatted for output on a browser and I can't use pre tags becuase the width attribute isn't supported anymore and it doesn't really work. I also need to break up a... |
| Forum: HTML and CSS Oct 5th, 2007 |
| Replies: 13 Views: 2,422 Re: Do you validate?
It could be argued that the stricter browsers are the ones that are actually making our life harder. Personally, I find coding for IE much easier. It's just a case of who's more stubborn W3 or... |
| Forum: Geeks' Lounge Oct 3rd, 2007 |
| Replies: 7 Views: 391 |
| Forum: Geeks' Lounge Oct 3rd, 2007 |
| Replies: 7 Views: 391 Re: Valid markup
Looked it up. Seems pretty cool. I guess under that framework your approach is more rational unified than agile. I guess it works better for those large projects that needs a team and has many... |
| Forum: HTML and CSS Oct 3rd, 2007 |
| Replies: 13 Views: 2,422 Re: Do you validate?
http://validator.w3.org/check?uri=http://www.google.com
LOL. If you can make $25bn without meeting the standard W3 can kiss my ass if they think I'm gonna waste anymore of my time and my customers... |
| Forum: Geeks' Lounge Oct 2nd, 2007 |
| Replies: 7 Views: 391 Re: Valid markup
"The guy made the correct decision to not hire you if you call yourself a web designer/developer yet aren't able to use current technology to do the job."
What guy? Not hire me for what? What are... |
| Forum: Geeks' Lounge Oct 2nd, 2007 |
| Replies: 7 Views: 391 Valid markup
I'm pretty new to web development. Being a tech, I have found the whole scripting and SQL side natural to pick up. However, the markup does my nut. Why do you hear so much noise on forums about... |
| Forum: C++ Apr 6th, 2006 |
| Replies: 4 Views: 831 |
| Forum: C++ Apr 6th, 2006 |
| Replies: 4 Views: 831 It compiles but crashes when executed - help!
Can anyone tell me why the following ligitimate code does not work, creating a linked list of characters from stdin?
struct Nodec {
char element;
Nodec *edge;
};
void Nodecin(Nodec... |
