Search DaniWeb - scott-wilson

Re: Extracting values from capturing groups in regex 2 Months Ago by Tom_45 …;<td>53</td><td>Scott</td><td>Alicia</td>…;<td>480</td><td>Wilson</td><td>Jordyn</td>… TikTok, itâ€™s time to chat to LunaTik designer Scott Wilson 13 Years Ago by WASDted [ATTACH=RIGHT]18554[/ATTACH]Scott Wilson is not a noob when it comes to the worlds … likely enjoying the aesthetics, ergonomics and usability provided by Wilson’s influence. Recently Scott Wilson decided to turn to the [URL="https… thought ‘I need to wear this all the time?’ [B]Scott Wilson:[/B] Well, I think the idea was an obvious one… Re: TikTok, itâ€™s time to chat to LunaTik designer Scott Wilson 13 Years Ago by WASDted That's great! I hope you use it well. Yes, Apple's design talents are amazing. I think Scott Wilson did a great job complementing that with this striking product. Win! Simple Q - max array limit? small mistake? 13 Years Ago by jonsan32 … 100% dedication, you won't be able to do this.-- Wilson Mizner"; r_text[87] = " In sports, you simply aren… performance, or just finish the raceits up to you. -Dave Scott, Triathlete "; r_text[196] = " I've always made a… Re: Simple Q - max array limit? small mistake? 13 Years Ago by jonsan32 … 100% dedication, you won't be able to do this.-- Wilson Mizner"; r_text[87] = " In sports, you simply aren… performance, or just finish the raceits up to you. -Dave Scott, Triathlete "; r_text[196] = " I've always made a… Merging two queries 13 Years Ago by MargateSteve … the club. Initially took over the number one shirt from Scott Chalmers-Stevens but injury saw him sidelined until November. Upon… Lordswood and Chatham Town.', NULL); INSERT INTO `players` VALUES (38, 'Wilson', 'Wayne', '1985-09-12', 3, 'http://www.margate-fc.com… Re: Cannot write to output file. 15 Years Ago by PaladinHammer …KS 64415 MICHAEL MILLER 973 Birch Olathe KS 64457 BARBARA WILSON 1029 Apple Riverside MO 64028 WILLIAM MOORE 670 Apple …KS 64892 KENNETH HILL 287 Birch Leawood MO 64463 DONNA SCOTT 805 Apple Fairway KS 64962 STEVEN GREEN 348 Walnut …Olathe MO 64948 BRENDA COOPER 845 Apple Olathe MO 64361 SCOTT RICHARDSON 246 Oak Fairway MO 64849 AMY COX 187 … Re: TikTok, itâ€™s time to chat to LunaTik designer Scott Wilson 13 Years Ago by lapssone yes, you are a very successful designer Re: TikTok, itâ€™s time to chat to LunaTik designer Scott Wilson 13 Years Ago by sarausa Really big fan of you. Can we meet together for a while? Re: TikTok, itâ€™s time to chat to LunaTik designer Scott Wilson 13 Years Ago by mass223 This is a remarkable idea and people will love it. Re: TikTok, itâ€™s time to chat to LunaTik designer Scott Wilson 13 Years Ago by CanaznFTW I was lucky enough to find this in it's early stages and have purchased the Red LunaTik with my backer #. It is an amazing product. Re: TikTok, itâ€™s time to chat to LunaTik designer Scott Wilson 13 Years Ago by WASDted Thank you for the feedback Canazn. Have you received yours yet? Have you actually used it? It certainly seems like a cool product to me. Re: TikTok, itâ€™s time to chat to LunaTik designer Scott Wilson 13 Years Ago by CanaznFTW WASDted, I have receive my LunaTik and do utilize it every day. The case is very sturdy although I always worry about hitting it on something. So even if I did I don't think it would affect it. The band is some form of silicone and is very durable and the strap holder works well. Looks like an amazing watch and I've gotten some cool … Re: TikTok, itâ€™s time to chat to LunaTik designer Scott Wilson 13 Years Ago by CanaznFTW Just in case you guys wanted to take a look. :) CanaznFTW Re: TikTok, itâ€™s time to chat to LunaTik designer Scott Wilson 13 Years Ago by BrianJSwandoff I love the striking design A bold statement made by a watch - I love it BrianJSwandoff Re: Simple Q - max array limit? small mistake? 13 Years Ago by scrappedcola Just in glancing it looks like you have a new line in this one and you can't have newlines within a string like this or it will think it's an unterminated string. [CODE] r_text[52] = "<a href='http://www.youtube.com/watch_popup?v=H86W8MxD1Ps' target='_blank'> Click here for the inspirational sports story of <b>Derek Redmond</b… Re: Simple Q - max array limit? small mistake? 13 Years Ago by scrappedcola I do all my coding in vi. Both the linux and windows versions offer line numbering and format highlighting(the biggest lifesaver as you can see quickly if you have and un-terminated string). But for what it's worth I think most of your IDE/code editors will do this (short of your basic Notepad). If you've not used vi before I would suggest going … Re: Merging two queries 13 Years Ago by smantscheff An interesting problem. I cannot get it to work, though, because MySQL keeps telling me "ERROR 1054 : Unknown column 'scorer' in 'on clause" Does anyone else have this problem, too? And maybe a solution? And kudos for Steve for supplying a complete test case as a starting point. Re: Merging two queries 13 Years Ago by MargateSteve That is very puzzling as I have just tried it again myself and it runs with no errors! If it helps, I do have both of these running online. The first one is [GOALS QUERY](http://www.margate-fc.com/content/1st_team/stats/scorers.php) and the second one, although a bit of a mess as it is only a test page, is [APPEARANCES QUERY](http://www.margate-fc… Re: Merging two queries 13 Years Ago by smantscheff Intermedia result: switch the table sequence in your join clauses from [CODE]FROM goals, games INNER JOIN players [/CODE]to [CODE]FROM games, goals INNER JOIN players [/CODE]and likewise [CODE]FROM appearances, games INNER JOIN players [/CODE] to [CODE]FROM games, appearances INNER JOIN players [/CODE] to get the query to run (on mysql 5.1.41-… Re: Merging two queries 13 Years Ago by MargateSteve Oops! That will teach me to post stuff late at night! I put the sample players table data in the original post but forgot it in the dump. The full players table is [URL="http://www.margate-fc.com/misc/players_dump.sql"]PLAYERS TABLE[/URL]. I will try the suggestions when I get home from work. I think you may be onto something with the … Re: Merging two queries 13 Years Ago by smantscheff Try this: [ICODE]create view view1 as SELECT *, COUNT(CASE WHEN games.competition = 1 AND appearances.type = 1 THEN 1 ELSE NULL END) AS lgest, COUNT(CASE WHEN games.competition = 1 AND appearances.type = 2 THEN 1 ELSE NULL END) AS lgesub, COUNT(CASE WHEN games.competition = 1 AND appearances.type = 3 THEN 1 ELSE NULL END) AS lgebench, COUNT(… Re: Merging two queries 13 Years Ago by MargateSteve Firstly, apologies for not getting back sooner but I had to go to Scotland for a few days. The VIEWS approach is so nearly there but there is just one little thing I cannot solve with it. Using the code you posted, everything worked fine other than it would only show players who had scored goals (view2). It is pulling the right information … Re: Merging two queries 13 Years Ago by smantscheff The problem is that both views contain the same column names for the same tables. While the mysql command line interface handles this quite gracefully, the PHP interface identifies columns by column names only, without the table prefix. Therefore the player.* columns from view1 are merged with or overwritten by the player.* columns of view2. This… Re: Merging two queries 13 Years Ago by MargateSteve Absolutely perfect! I tried one aggregate to see if it worked [CODE] SELECT view1.player_id as theRealId, view1.surname as theRealSurname, view1.firstname as theRealFirstname, [B][COLOR="Red"]view1.lgemins/view2.lgegls as lminpg[/COLOR][/B], view1.*, view2.* FROM view1 LEFT JOIN view2 on view1.player_id=view2.player_id[/CODE]and it … Re: Merging two queries 13 Years Ago by smantscheff I'm glad to have been of help. Yes, views can simplify complicated queries a lot. One drawback in MySQL is that they are stored in an very explicit form with all table prefixes and each column listed separately. Have a look at SHOW CREATE VIEW view1. If you add a column to one of the tables of the view, it won't show up in the view until you …