RE: [PHP] Simple Problems taking me hours to solve!

2002-11-01 Thread Petre Agenbag
ts order by > > receipt_id DESC LIMIT > > > 0,1"; > > > $order = mysql_query($query); > > > $myrow = mysql_fetch_array($order); > > > $my_id = $myrow["orderid"]; > > > $my_id = $orderid; > > > return $orderid; > > >

Re: [PHP] Simple Problems taking me hours to solve!

2002-11-01 Thread Petre Agenbag
No, it should not return what you want. When you do $orderid = mysql_query($query); all this does is actually execute the query, and returns an array containing the actual result set. What you need to do from here is to do: $myrow = mysql_fetch_assoc($orderid); Now, what you have is an associati

[PHP] Simple Problems taking me hours to solve!

2002-11-01 Thread Steve Jackson
This is the query I am running on my database: $query = "select orderid from receipts order by receipt_id DESC LIMIT 0,1"; $orderid = mysql_query($query); That should return the last record in the DB? Correct? I currently get a number returned which is the number plus 1. IE if 423 is the las