stems Ltd.
http://www.violasystems.com
[EMAIL PROTECTED]
Mobile +358 50 343 5159
> -Original Message-
> From: Jason Wong [mailto:php-general@;gremlins.com.hk]
> Sent: 7. marraskuuta 2002 11:51
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP] Help me learn! with an explanation of
> these t
On Thursday 07 November 2002 16:28, Steve Jackson wrote:
> Finally I have it!
if this is your final code then you still don't "have it" !
> Cheers to all that helped. I was querying twice when I didn't need to
> and as Jason said not doing anything with the extracted information.
> extrac
Message-
> From: Jason Wong [mailto:php-general@;gremlins.com.hk]
> Sent: 7. marraskuuta 2002 10:06
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP] Help me learn! with an explanation of
> these two functions.
>
>
> On Thursday 07 November 2002 15:15, Steve Jackson wrote:
On Thursday 07 November 2002 15:15, Steve Jackson wrote:
> My second query still doesn't return anything? Even with $orderid = $row
> removed as Jason suggested.
What exactly do you mean by "doesn't return anything"?
a) Does the second query fail?
b) Do you get any errors?
If no to both (a) and
My second query still doesn't return anything? Even with $orderid = $row
removed as Jason suggested.
This is my current function.
function get_order_numbers()
{
$conn = db_connect();
$query = "select orders.orderid from orders, email where orders.orderid
= email.orderid and email.checked='no'";
$
On Wednesday 06 November 2002 21:46, Steve Jackson wrote:
> It doesn't contain a single result. It returns 16 order numbers (which
> is correct - 8 should be in the table emails with no checked and
> therefore the query has worked and pulled out 8 from the orders table
> also). What I want the fun
> On Wednesday 06 November 2002 16:52, Steve Jackson wrote:
> > Ok this is starting to get complex! (For me anyway)
> > This is my function:
> > function get_order_numbers()
> > {
> > $conn = db_connect();
> > $query = "select orders.orderid from orders, email where
> > orders.orderid = email.orde
On Wednesday 06 November 2002 16:52, Steve Jackson wrote:
> Ok this is starting to get complex! (For me anyway)
> This is my function:
> function get_order_numbers()
> {
> $conn = db_connect();
> $query = "select orders.orderid from orders, email where orders.orderid
> = email.orderid and email.che
At 09:52 06.11.2002, Steve Jackson said:
[snip]
>function get_order_numbers()
>{
>$conn = db_connect();
>$query = "select orders.orderid from orders, email where orders.orderid
>= email.orderid and email.checked='no'";
>$result = mysql_query($query) or die("E
Ok this is starting to get complex! (For me anyway)
This is my function:
function get_order_numbers()
{
$conn = db_connect();
$query = "select orders.orderid from orders, email where orders.orderid
= email.orderid and email.checked='no'";
$result = mysql_query($query) or die("Error: cannot select
At 08:58 06.11.2002, Steve Jackson said:
[snip]
>Joins. Cool. Never heard of them before now but have started
>experimenting with them.
>What does this error mean?
>
>Error: cannot select orderid
>select orderid from orders, email where orders.orderid = email
Mobile +358 50 343 5159
> -Original Message-
> From: 1LT John W. Holmes [mailto:holmes072000@;charter.net]
> Sent: 5. marraskuuta 2002 16:59
> To: [EMAIL PROTECTED]; PHP General
> Subject: Re: [PHP] Help me learn! with an explanation of
> these two functions.
>
>
> Y
syntax,
though.
Check the MySQL manual and read the chapter on JOINs.
---John Holmes...
- Original Message -
From: "Steve Jackson" <[EMAIL PROTECTED]>
To: "PHP General" <[EMAIL PROTECTED]>
Sent: Tuesday, November 05, 2002 9:50 AM
Subject: [PHP] Help me le
die("Error: cannot fetch
order$query2".mysql_error());
extract(mysql_fetch_array($result2));
}
- Original Message -
From: "Steve Jackson" <[EMAIL PROTECTED]>
To: "PHP General" <[EMAIL PROTECTED]>
Sent: Tuesday, November 05, 2002 8:50 AM
Subj
Can someone run over these functions I have written to explain if my
logic is correct.
I'm still new to PHP and am trying to get my head round it!
This first function is to collect a list of order numbers from my
database where checked = no.
Am I correct in assuming that the variable $orderid will
15 matches
Mail list logo
