Go Back   CodingForums.com > Search Forums
Reload this Page Search Results

Before you post, read our: Rules & Posting Guidelines

Page 1 of 20 1 2311 Last »
Showing results 1 to 25 of 500
Search took 0.91 seconds. Search: Posts Made By: homerUK
Forum: MySQL 02-18-2008, 11:10 AM
Replies: 1
Views: 596
Posted By homerUK
join problem

hi guys,

I've got another problem with my join. I have two tables

orgparamanswers
=============
orgParamID
year
answer
servicelineID
Forum: MySQL 01-15-2008, 10:35 AM
Replies: 2
Views: 735
Posted By homerUK
cheers -that seems to just get one record!? Not...

cheers -that seems to just get one record!? Not sure what's up with it!
Forum: MySQL 01-14-2008, 05:34 PM
Replies: 2
Views: 735
Posted By homerUK
SQL join help needed (again!)

I have two tables which I need to join... I assumed i needed a LEFT join. I need ALL the results from tableA and their corrisponding records from tableB.

tableA
=========
orgparamID
name...
Forum: PHP 11-29-2007, 08:25 AM
Replies: 19
Views: 1,645
Posted By homerUK
I would probably set up the informtion you want...

I would probably set up the informtion you want to show in a session? eg:

at the top of register.php, add

session_start();

then in the code

// SEND APPLICANT TO SUCCESSFUL PAGE
header...
Forum: PHP 11-28-2007, 05:19 PM
Replies: 3
Views: 778
Posted By homerUK
I tried this code from your example: $arr...

I tried this code from your example:


$arr [1]["1.01"]["R11101"]["is_high_level"] = 0;
$arr [1]["0.00"]["R11100"]["is_high_level"] = 0;
$arr [1]["1.02"]["R11102"]["is_high_level"] = 1; ...
Forum: PHP 11-28-2007, 02:36 PM
Replies: 3
Views: 778
Posted By homerUK
still not having any luck - anyone able to help?

still not having any luck - anyone able to help?
Forum: PHP 11-22-2007, 10:22 AM
Replies: 3
Views: 778
Posted By homerUK
multi dimensional array sort

Hi guys,



I'm now having sorting the MD array...


$arr [1][1.01][R11101][is_high_level] = 0;
$arr [1][0.00][R11100][is_high_level] = 0;
$arr [1][1.02][R11102][is_high_level] = 1;
Forum: PHP 11-22-2007, 10:07 AM
Replies: 2
Views: 530
Posted By homerUK
cool - thanks for that. I'll give it a go!!

cool - thanks for that. I'll give it a go!!
Forum: PHP 11-21-2007, 09:13 AM
Replies: 2
Views: 530
Posted By homerUK
array question

Hi guys,

what's the best way to get a list of results from the DB in to an array? I want to get a default list of items, then perform additional queries on them. eg

...
Forum: MySQL 11-09-2007, 01:12 PM
Replies: 4
Views: 1,006
Posted By homerUK
yeah that's what i was thinking. Thanks :) ...

yeah that's what i was thinking. Thanks :)

So it wouldnt matter if there ended up being thousands of rows?
Forum: MySQL 11-09-2007, 12:17 PM
Replies: 4
Views: 1,006
Posted By homerUK
performance vs many records

Hi guys,

I'm after a little advice. I currently have 300 records in table "metrics". These metrics are assigned to users. So each user has access to the 300 metrics. by default, my SQL will load...
Forum: PHP 10-02-2007, 05:01 PM
Replies: 1
Views: 693
Posted By homerUK
preg for XML

Hey - I need some help with (I think it's the right thing to use) PREG_replace.

I am exporting data to XML and it's having a nightmare with some characters in the text. I'd like to have a...
Forum: PHP 09-04-2007, 10:13 AM
Replies: 4
Views: 765
Posted By homerUK
worked perfectly!! thanks!! :)

worked perfectly!! thanks!! :)
Forum: PHP 09-03-2007, 06:06 PM
Replies: 4
Views: 765
Posted By homerUK
yeah that's the sort of thing - maybe I should be...

yeah that's the sort of thing - maybe I should be clearer about what's in the array!! I was cutting the code down so that I could try and get a quick answer..




while ($row =...
Forum: PHP 09-03-2007, 04:16 PM
Replies: 4
Views: 765
Posted By homerUK
referencing array data

Hey,

I've got an array which I've made up with data from the database. It's looking like this at the moment:


$staff_array[$staffID] = $db_row['staff_id'];


how would I then loop through...
Forum: MySQL 08-31-2007, 09:32 AM
Replies: 2
Views: 841
Posted By homerUK
excellent, that's done the trick!! :) thanks!

excellent, that's done the trick!! :) thanks!
Forum: MySQL 08-30-2007, 05:17 PM
Replies: 2
Views: 841
Posted By homerUK
multiple SUM queries - nested?

me again with more SUM related queries, sorry!!

I have a table now (another one!) which is structured like this (with some dummy data)


processID field orgID answer...
Forum: MySQL 08-30-2007, 05:10 PM
Replies: 8
Views: 934
Posted By homerUK
sorry, the code here was for testing to see what...

sorry, the code here was for testing to see what outcome I got, hence I left in the name column - it's not there for the main SQL in the code. Sorry (but thanks for the pointer!!)



It was hard...
Forum: MySQL 08-30-2007, 10:50 AM
Replies: 8
Views: 934
Posted By homerUK
cheers matey... I still couldn't get it to work...

cheers matey... I still couldn't get it to work properly, so I've partly cheated.

Two SQL statements now.
first one:


select DISTINCT(d.driverID), d.name FROM drivers d WHERE d.processID IN...
Forum: MySQL 08-29-2007, 03:38 PM
Replies: 8
Views: 934
Posted By homerUK
what about selecting a distinct record? for...

what about selecting a distinct record? for example,


driverID answer orgID
0050 100 RED1

driverID name processID
0050 ABC 1.01
0050 ABC 1.02
0050 ABC 2.01
Forum: MySQL 08-29-2007, 03:28 PM
Replies: 8
Views: 934
Posted By homerUK
ah yeah, that's done the trick - I didn't use the...

ah yeah, that's done the trick - I didn't use the where driverID = driverID to link the tables!! thanks!!
Forum: MySQL 08-29-2007, 01:57 PM
Replies: 8
Views: 934
Posted By homerUK
sum() in SQL

hey guys,

I'm trying to do an SQL statement to sum up the following data. (using two tables joined)


/* DRIVER ANSWER */

DRIVERID ORGID ANSWER
==========================
0010 RED1 100
Forum: MySQL 08-16-2007, 11:07 AM
Replies: 2
Views: 632
Posted By homerUK
datestamp on records?

hey,

this is a massive long shot, but is there any sql query which can be done to get the update or creation date of a record?? I've not used a datestamp or anything - I just wondered if there was...
Forum: JavaScript programming 08-02-2007, 04:27 PM
Replies: 4
Views: 671
Posted By homerUK
I can see how it's done in PHP, but I need it to...

I can see how it's done in PHP, but I need it to be done using Javascript before the form is submitted... cheers!
Forum: JavaScript programming 08-02-2007, 02:45 PM
Replies: 4
Views: 671
Posted By homerUK
validate radio buttons

Hi guys,

Hopefully a fairly simple one.
I've three sets of two radio buttons. I ask a question and the user selects yes or no.


Do you like milk?
<input type="radio" name="q1" value="Y">...
Showing results 1 to 25 of 500
Page 1 of 20 1 2311 Last »

 
Forum Jump

All times are GMT +1. The time now is 04:44 AM.