|
Im sure it takes more memory but my preferred method
is:
$q = pg_Exec("SELECT id FROM article WHERE id=(SELECT MAX(id)
FROM article)");
$data = "" ($q, 0);
$maxid = $data->id; echo "The highest id is ". $maxid;
To me this is more self-documenting and easier to maintian...
culley
>>> Philip Hallstrom <philip@xxxxxxxxxxxxxxxxx> 05/03/01 08:29AM >>> Also... is there any reason you don't just do: SELECT MAX(id) FROM article rather than what you have below? It would get you the same thing wouldn't it and save a query... On Thu, 3 May 2001, Chris Ryan wrote: > Jason, > > Look into the pg_result() function. You would use it something like > this: > > $q = pg_Exec("SELECT id FROM article WHERE id=(SELECT MAX(id) FROM > article)"); > $maxid = pg_result($q,0,0); # pg_result($result,$row,$column_num) > echo "The highest id is ". $maxid[0]; > > Hope this helps. > > Chris Ryan > chris@xxxxxxxxxxxxxxx > > Jason wrote: > > > > Hi, I want to try and optimize my calls to postgreSQL from PHP. If > > I only need one field from a select statement, what should I use? I am > > currently using: > > $q = pg_Exec("SELECT id FROM article WHERE id=(SELECT MAX(id) > > FROM article)"); > > $maxid = pg_fetch_array($q, 0); > > echo "The highest id is ". $maxid[0]; > > What can I use besides an array to get a single value? In general, using > > a single variable always saves more memory than using an array? Thank > > you. > > Jason > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 5: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/users-lounge/docs/faq.html > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your > message can get through to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx) ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster |
