Hi Guys.. hopefully someone can help with this.
Code:
$query = "select t.id, t.thread_index, t.pattern_index,
t.avail, p.id, p.type, p.colour, p.colourID, p.manufacturer FROM
kcs_patternthreads t LEFT JOIN kcs_threads p ON t.thread_index = p.id
WHERE t.pattern_index = $id";
if (strftime("%H") == "03")
{
header( "Location: maintainence.php" );
exit;
}
Note the exit; line.
Aaron
-Original Message-
From: J. Michael Roberts [mailto:[EMAIL PROTECTED]
Sent: July 24, 2003 10:09 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Line of code should work...
Well...
I actually solved this an hour ago.
$query = "select t.id, t.thread_index, t.pattern_index, t.avail, p.id,
p.type, p.colour, p.colourID, p.manufacturer FROM kcs_patternthreads t
LEFT JOIN kcs_threads p ON t.thread_index = p.id WHERE t.pattern_index =
$id";
$thread_manufacturer = '';
]
Sent: July 24, 2003 10:29 AM
To: Aaron Wolski
Cc: 'J. Michael Roberts'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Line of code should work...but doesn't
this may work, but i hesitate, i've _never_ had to use exit to get my
code
to excecute a redirect. and i'm heavily relia
EMAIL PROTECTED]
> Sent: Thursday, July 24, 2003 10:29 AM
> To: Aaron Wolski
> Cc: 'J. Michael Roberts'; [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] Line of code should work...but doesn't
>
>
>
> this may work, but i hesitate, i've _never_ had to use exit
Hi Guys,
Code:
echo "\n";
$query = "select t.manufacturer, t.id, t.colour, t.colourID, t.type,
p.thread_index FROM kcs_threads t LEFT JOIN kcs_patternthreads p ON t.id
= p.thread_index WHERE p.pattern_index = '$id' OR p.pattern_index IS
NULL ORDER BY t.colourID";
$thread_manufacturer
As usual.
John knows best.
Thanks!
Aaron
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: July 25, 2003 3:05 PM
To: Aaron Wolski; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] query and display acting weird...
Probably need:
ORDER BY t.manufacturer, t.colourID
Hi Guys,
Have a multiple select box. I'm trying to group columns and display
records under their paired groupings.
Code:
echo "\n";
$query = "select t.manufacturer, t.id, t.colour, t.colourID, t.type,
p.thread_index FROM kcs_threads t LEFT JOIN kcs_patternthreads p ON t.id
= p.thread_index
>>I'd suggest you pick up an SQL book or do some more reading if you
don't
>>understand that.
>>--
>>---John Holmes...
John,
Do you have a good book recommendation for MySQL.. I'm looking for more
knowledge on improving my queries, etc. LEFT JOINS were completely
unfamiliar (still are) until
Hi Guys,
Rather long topic I know. Sorry if it annoyed anyone.
Hopefully someone can help here with the logic on this.
I have a query where I am getting one column (designers) in a Table,
ordered alphabetically.
Right now.. this query is displaying EVERY distinct result (45 in
total). This
s
Family Tree The
Fanci That
Full Circle Designs
G-J
J-M
M-P
P-S
S-V
V-Y
Y-Z
I've tried a few placements of the foreach loop but nothing seems to
work. Any ideas?
Thanks!
-Original Message-
From: Ramil G. Sagum [mailto:[EMAIL PROTECTED]
Sent: July 29, 2003 11:38 PM
To: [EMAIL PR
Sorry all but getting kinda desparate here :(
Trying a few different things and still nothing seems to work.
Does anyone have a kick in the right direction that I could explore
here?
Sorry for the repost.
Thanks
Aaron
-Original Message-
From: Aaron Wolski [mailto:[EMAIL PROTECTED
Hi All,
This is OT but I am in need of serious help.
I am rewriting URL's for a site and came across an issue with spaces in
URLS having %20 applied to them. I can't seem to find a solution with
mod_rewrite to get rid of the %20 and replace with - (hyphen) so I am
hoping someone can help me her
hing in the database?
http://us4.php.net/manual/en/function.urldecode.php
> -Original Message-----
> From: Aaron Wolski [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 31, 2003 3:14 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] updating a column based on info from
> anothe
Hi All,
Sorry for OT post but need some info.
Does anyone know a good tutorial that explains regular expressions in
DUMMY terms?
I have a list of characters that I need to check to see if they are in a
string. I tried creating an array of the characters but some of them are
like ' " and ` wh
Hi All,
I'm trying to get some code to display like:
Manufacturer 1
Type 1
Type 2
Type 3
Manufacturer 2
Type 1
Type 2
Type 3
Manufacter 3
Type 1
Type 2
Type 3
My code is:
{$manufResult
['manufacturer']}";
Hi guys,
I have the following query which returns FINE through the console but
not in PHP
select t.id, t.colour, t.colourID, t.price, t.type, g.thread_index,
g.groupNameUrl FROM kcs_threads t LEFT JOIN kcs_threadgroups g ON t.id =
g.thread_index WHERE g.groupNameUrl = '0-500'
The error I
ts!
Aaron
-Original Message-
From: Matt [mailto:[EMAIL PROTECTED]
Sent: August 3, 2003 10:11 AM
To: Aaron Wolski; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] query works fine on console but not with PHP -
why?
- Original Message -
From: "Aaron Wolski" <[EMAIL PROTECTED]>
To
help me in future debugging.
Thanks again to all.
Aaron
-Original Message-----
From: Aaron Wolski [mailto:[EMAIL PROTECTED]
Sent: August 3, 2003 10:08 AM
To: 'Matt'; '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] query works fine on console but not with PHP -
why? SOLVED
Hi and
Hi All,
Been trying to come up with a way to make the following queries into one
which would speed up the processing I think.
Code:
$mQuery = db_query("SELECT manufacturer FROM kcs_threads GROUP BY
manufacturer ORDER BY manufacturer");
while ($mResult = db_fetch($mQuery)) {
Same here.
I get it all the time.
Aaron
-Original Message-
From: David Blomstrom [mailto:[EMAIL PROTECTED]
Sent: August 3, 2003 10:53 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Renaming .htm pages to .php
Thanks for all the tips.
Incidentally, I just noticed that I'm getting e-mai
Hi Guys,
I've tried several different things with the following 2 queries but
nothing seem to help. I've stared at the code and reworked it for hours
on end and frankly I am getting frustrated.
I'm only posting the queries themselves without the PHP code as the
entire section is quite long. If
Ok.. I echo'd out the queries AND the num_rows returned for each loop
and this is what I got:
Manufacturer Query is: SELECT DISTINCT manufacturer FROM kcs_threads
ORDER BY manufacturer
Manufacturer Rows Returned Are: 5
Left Join Query is: select t.type, t.newUrlType, g.threadType,
g.groupNam
Hi All,
I'm trying to display results across 3 cells - for example:
#5 Perle Cotton
223 | 225 | 301
304 | 326 | 333
#12 Perle Cotton
211 | 223 | 224
225 | 356 |
#4 Braid
95 | 100HL | 102
Right NOW it is displaying like:
#5 Perle Cotton
223 | 225
301 | 304| 326
#12 Perl
UNIQUE gradient (gradient)
This is causing your issue. You have stated that new records cannot
match an already established record with the same name under gradient.
HTH
Aaron
-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]
Sent: August 5, 2003 1:44 PM
To: [EMAIL PROTECTED]
Sub
>From what I can see is that you're not actually looping anything?
while( !$done ) {
$row = mysql_fetch_row( $result );
if( !$row ) {
$done = 1;
}
This doesn't loop through your query, least not in my eyes it doesn't.
Why not:
while ($rows = mysql_fetch_array
Seeing code might help us.
Aaron
> -Original Message-
> From: Jeff [mailto:[EMAIL PROTECTED]
> Sent: August 8, 2003 10:44 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Sorting issue
>
> Why would a mysql db think that 55 was greater than 14000.
>
> I have several headings that display
Here's some functions I use in my development which save on connect and
query calls for me.
//General Purpose Utilities.
//db_connect connects to the database server and selects the proper
database.
//Arguments: None
//Returns: Nothing
function db_connect() {
mysql_pconnect("localhost",
Sent: August 5, 2003 10:02 AM
To: Aaron Wolski
Subject: RE: [PHP-DB] incrementor in loop is not incrementing.. any
thoughts?
Is that a copy/paste? You're showing newlines which I don't see in the
pasted code ...
> -----Original Message-
> From: Aaron Wolski [mailto:[EMAIL PR
tand it as much as possible *shrugs*
Aaron
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: August 5, 2003 9:08 AM
To: Aaron Wolski; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] displaying result across 3 cells - where did I go
wrong?
From: "Aaron Wolski&quo
--Original Message-
From: Adam Alkins [mailto:[EMAIL PROTECTED]
Sent: August 6, 2003 8:16 AM
To: Aaron Wolski
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Don't know why query works this way
Quoting Aaron Wolski <[EMAIL PROTECTED]>:
> Here's some functions I use in my devel
301 0
304 0
326 0
333 0
211 0
223 0
224 0
225 0
356 0
95 0
100HL 0
102 0
Obviously $z is not incrementing. ANY clue why?
Thanks!
Aaron
Aaron Wolski, Project Manager
Martek Business Solutions Inc.
www.martekbiz.com <http://www.martekbiz.com/>
905-780-9574
[EMAIL PROTECTED]
First, are you sure there is data in $my_array?
Add this after you set the array:
echo """.print_r($my_array)."";
You'll need to loop through the array , writing each line in the file at
a time.
Something like:
//open the file stuff here
foreach ($my_array AS $values)
{
fputs($fp, $va
y too?
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: August 17, 2003 11:48 AM
> To: Aaron Wolski
> Cc: 'PHP-DB'; 'OpenSource'
> Subject: RE: [PHP-DB] array issue
>
>
> This may or may not make sense for your iss
tion system not seen by many users.
Aaron
> -Original Message-
> From: OpenSource [mailto:[EMAIL PROTECTED]
> Sent: August 17, 2003 12:28 PM
> To: Aaron Wolski
> Cc: PHP-DB; [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] array issue
> Importance: High
>
> Hey guys
Hi Richard,
When you submit the form, why not have a hidden field in the form like:
Then use that 'backtopage' variable in your script where you direct the
results to.
Or.. if you don't want to use a hidden field.. parse the URL to get the
referrer?
HTH
Aaron
> -Original Message-
>
Hi All,
Having a brain laps and not sure where in the manual to look and sadly I
need a QUICK solution.
I have a date formatted in a table like: 20030826132457
Now.. I went to MySQL timestamp from UNIX timestamps because I like the
readability of them when just looking at the Tables. How woul
Hi Guys,
I really hope you don't mind the OT post but I've looked everywhere and
can't seem to find a solution to my problem.
I am passing a var in a session (not in the URL) to my secure checkout
area and it's not capturing the variable.
I know there is a problem with using sessions across n
Well...
Having never done this I would assume it's the same with and form field
you want to use as an array (multiple selections).
Create a few different fileselect fields all with the same name but
adding in [] to make it an array.
Then just loop through the array.. copying the file to the serv
The other option is...
You create a pop-up menu system.
That have the file form field to select from a location. When you upload
the image it populates a HTML display table so you can see it and also
allows you to select another image.
When you are done.. you close the pop-up menu and that's th
101 - 140 of 140 matches
Mail list logo