|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
PHP & PostgreSQL
I'm having a bit of trouble getting predicates to work in a SELECT statement,
< WHERE fromlocation LIKE 'Leeds' > works but < WHERE fromlocation LIKE '$xstart' > and < WHERE fromlocation LIKE '".$xstart."' > do not. The contents of $xstart print out fine using: < print $_REQUEST['xstart'] ; > I want to use the xstart variable as a predicate and according to the documentation I have seen, LIKE '$xstart' should work. $query = "SELECT fromlocation,tolocation,driver,emptyseats,journeyd ate,text,return,dateentered FROM tjourney WHERE fromlocation LIKE '$xstart' order by 1,2,4"; Help, Andy --------- Red Hat Linux 9.0 PHP PostgreSQL |
|
#2
|
||||
|
||||
|
RE: PHP & PostgreSQL
|
|
#3
|
|||
|
|||
|
RE: PHP & PostgreSQL
Cracked it! Many thanks
|
![]() |
| Viewing: Codewalkers Forums > Other Technologies > Database Help > PHP & PostgreSQL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
|