Try
SELECT teams.*, divisions.id AS divisonid, divisions.name AS divisionname
FROM teams LEFT JOIN divisions ON teams.divisonID = divisions.divisionID
if the ids are the same you can actually also write
ON teams.divisonID
and omit
= divisions.divisionID
... I think.
hth
toby
> I'm looking
i must overlooked that... no wonder my pages all take ages to load *g* ;)
;)
- Original Message -
From: "Martin Towell" <[EMAIL PROTECTED]>
To: "'Kirk Babb'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, January 14, 2004 11:52 PM
Subject: RE: [PHP] multi-table select?
> Thi
i guess
SELECT * FROM `table` WHERE ids REGEXP ',2,|^2,|,2$'
should do it...
hth
toby
- Original Message -
From: "Lowell Allen" <[EMAIL PROTECTED]>
To: "PHP" <[EMAIL PROTECTED]>
Sent: Thursday, January 15, 2004 4:39 PM
Subject: Re: [PHP] regexp with mysql
> > i hope someone can hel
that was explaining the prinicple.
of course you wouldn't do it like this, but pass an id to identify. you
could also send an encryption key...
- Original Message -
From: "CPT John W. Holmes" <[EMAIL PROTECTED]>
To: "Toby Irmer" <[EMAIL PROTECTED]
I have the same problem. Strange: I have a session_start(); before the
header... if I take that out, the image will download as a JPG... so maybe
if you find a way to do things in this script without starting the session
first...
toby
- Original Message -
From: "Larry Brown" <[EMAIL PROT
http://www.sum-it.nl/en200319.php3
Create thumbnail
a.. Cropping and scaling a photo is surprisingly easy with PHP.
b.. Unfortunately the functions imagecreatetruecolor() and
imagecopyresampled() exist only since PHP 4.0.6 using GD 2.0.1. Older PHP
version supports the functions imagecreate()
t to figure out some sorta security without using sessions.
>
> Thanks, for at least pointing me in the right direction. Now if we could
> figure out why this would be happening, that would be great.
>
> Bob
>
> - Original Message -
> From: "Toby Irmer" &l
if you say you don't know much, maybe you are looking for something like this ;)
hth
toby
\n";
foreach($options AS $key => $display)
{
echo " $display\n";
}
echo "\n";
}
//get users from db
$query = " SELECT * FROM users";
$result = mysql_query($query);
w
One way:
hth
toby
- Original Message -
From: "Dave Carrera" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 18, 2004 11:22 AM
Subject: [PHP] Is this possible ?
Hi List,
I have a function that makes a call to mysql based on certain vars.
---example
Function My
RTFM and stop sending messages to this list with a high priority. The
questions you are asking are answered in the first 3 chapters of any good
book about php.
toby
- Original Message -
From: "Radwan Aladdin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 19, 2004 9:13
Go check your code for obvious errors before you post it on this list:
$Random = 'Random'
$result = mysql_query($query1) or die("Query error: " . mysql_error());
Now spot the mistake. If you can't... tough luck.
toby
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: ht
The error is not in that line... check the line before that one.
Here, this might be of use... Copy and paste it:
;
> $result = mysql_query($query1) or die("Query error: " . mysql_error());
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hey everybody,
I am trying to display an .swf-file that is stored outside the webroot.
Just sending the header and doing a readfile on the swf results in the swf
being displayed with the maximum available width and height.
Does anyone know a way of displaying Flash with its correct dimensions if
guess you can't write the tag and just do a
To: "Toby Irmer" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, January 20, 2004 7:12 PM
Subject: Re: [PHP] Flash .swf outside webroot: width and height problems
> From: "Toby Irmer" <[EMAIL PROTECTED]
You can use a token to check if a form has been sent before...
",$this->tokenname,htmlspecialchars($tok));
}
function easyCheck()
{
$tok = $_REQUEST[$this->tokenname];
if (isset($_SESSION[$this->tokenarray][$tok]))
{
return false;
}
else
{
$_SESSION[$this->tokenarray][$tok] =
";
echo "viviane";
?>
hth
toby
- Original Message -
From: "Viviane Hu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 26, 2004 2:13 PM
Subject: [PHP] question PHP - HTML
> Hi,
>
> Je try to use PHP.
> Je wrote to this code
> echo "hello \n";
> echo "
How 'bout
- Original Message -
From: "Richard Kurth" <[EMAIL PROTECTED]>
To: "Richard Kurth" <[EMAIL PROTECTED]>
Sent: Monday, February 02, 2004 7:00 AM
Subject: [PHP] Pulling two field from mysql table into an array
>
> What is the best way to pull two fields from a mys
Hi there,
I am presently coding a little CMS. I want to give users the
possibility to add images to articles as easily and flexibly as
possible.
Does anyone have a recommendation on how to do it? So far, you can
upload an image which then is checked for its dimensions. If
necessary, the user is r
Hi Sam,
I am not sure I know what you want to do...
I tried to recreate your problem:
test.html
window.open("test2.html", "test");
test2.html
document.write(''
Hi Sam,
I did that only because I was too lazy to upload and did the testing
locally so I could grab the value in Javascript.
Of course it works with post as well...
test.html
window.open("test2.html", "test");
test2.html
document.write('
