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.orderid and email.checked='no' Column: 'orderid' in field list is ambiguous My query function syntax is: function get_order_numbers() { $conn = db_connect(); $query = "select orderid from orders, email where orders.orderid = email.orderid and email.checked='no'"; $result = mysql_query($query) or die("Error: cannot select orderid<BR>$query<BR>".mysql_error()); while( $row = mysql_fetch_array($result)) { extract($row); $orderid = $row; return $orderid; } } What does it mean ambiguous? Cheeky error! Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] 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. > > > Your first function is only going to return one row of > 'checked=no' records. The second function will only return > one column of the result. > > What you want is a JOIN. You can do all of this with a single > query. Without knowing the format of your tables exactly, I > can't give you the 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 learn! with an explanation of these > two functions. > > > > 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 be > an array of > > results returned? How can I check this? > > > > function get_live_orders() > > { > > $conn = db_connect(); > > $query = "select orderid from email where checked='no'"; $result = > > @mysql_query($query); > > if(mysql_numrows($result)>0) > > $orderid = @mysql_fetch_array($result); > > return $orderid; > > } > > > > This second function is to take these order numbers and > compare them > > to order numbers in a second table and return the result of > that. So > > if order number 100001 is in the first array from the above > function > > and there is a number 100001 in the second query result I > want to take > > all the data in that row and return it. > > > > function get_order_details() > > { > > $orderid = get_live_orders(); > > $conn = db_connect(); > > $query = "select * from orders where orderid='$orderid'"; $result = > > @mysql_query($query); if (!$result) > > return false; > > $result = mysql_result($result, 0, "orderid"); > > return $result; > > } > > > > I haven't actually run this yet but I'd like someone to > explain to me > > what these functions will do so I am not just copy pasting code and > > hoping to get it right eventually! Probably I have written > this wrong > > anyway and would like help before I actually attempt to do > what I am > > after. I'll look back on this tomorrow so any help will be greatly > > appreciated. Kind regards, > > Steve Jackson > > Web Developer > > Viola Systems Ltd. > > http://www.violasystems.com > > [EMAIL PROTECTED] > > Mobile +358 50 343 5159 > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php