[PHP-DB] Strings

Can anyone advise on how to surround a string variable in a query. I select a string code from a column using: $result = mysql_query("SELECT * FROM $TA WHERE Profileid = '$profileid'"); $row = mysql_fetch_array($result); I then want to extract from a second table an id that relates to the code

[PHP-DB] PHP problem with Postgresql

Hi, I've migrated a system using PHP4.0.3pl1 and PostgreSQL 7.0.2 over a RedHat 5.1 Linux to a new one using PHP4.0.4pl1 and PostgreSQL 7.0.2 on a RedHat 7.0 box. I've noticed a strange behaviour on one of my web sites; if I try to execute more than 2 query over an open connection, all the queries

[PHP-DB] PHP / MYSQL message board ?

Hi all I would like to find some documentation about how to create my own Php / Mysql driven message board. This is purly for my own educational interests. Any pointers and help appreciated Email: [EMAIL PROTECTED] kill the NOSPAM to send emial Thank you in advance Dave C -- PHP Database

Re: [PHP-DB] Strings

In article <003801c0afa2$2d5853e0$890083ca@oemcomputer>, [EMAIL PROTECTED] ("Mick Lloyd") wrote: > Can anyone advise on how to surround a string variable in a query. I select > a string code from a column using: > > $result = mysql_query("SELECT * FROM $TA WHERE Profileid = '$profileid'"); > $r

Re: [PHP-DB] if () and () - newbie Q

In article <000f01c0af50$e5092480$6609ee8d@pmg>, [EMAIL PROTECTED] ("Michael Gerholdt") wrote: > what about something like 'isNull' ? I don't see any documentation in the > PHP online manual nor is 'null' even mentioned in the index of my Core PHP > book. You must not have looked very hard. Ne

[PHP-DB] MYSQL Trouble with the IN operator

Could someone please give their insight? I'm having trouble with this query... SELECT CONCAT(c.l_name, ", ", c.f_name) name FROM contractor c WHERE c.contractor_id NOT IN (select c.contractor_id FROM contractor c, task_assign t WHERE c.contractor_id = t.contractor_id AND t.task_id

Re: [PHP-DB] MYSQL Trouble with the IN operator

In article <9937to$794$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Jen") wrote: > SELECT CONCAT(c.l_name, ", ", c.f_name) name > FROM contractor c > WHERE c.contractor_id NOT IN > (select c.contractor_id > FROM contractor c, task_assign t > WHERE c.contractor_id = t.contractor_id > A

Re: [PHP-DB] MYSQL Trouble with the IN operator

MySQL doesn't support nested selects. At 04:13 PM 3/18/01 -0500, Jen wrote: >Could someone please give their insight? >I'm having trouble with this query... > >SELECT CONCAT(c.l_name, ", ", c.f_name) name >FROM contractor c >WHERE c.contractor_id NOT IN > (select c.contractor_id > FROM c

[PHP-DB] Lotus Approach

Im using Win Me, Lotus Approach, Xitami web server and I have downloaded MyuSql for Windows. I am trying to get my localhost page to display a form where I type say an authors name, and the php will go and get the relevant info from the Approach dvIV. How do I do this. I have read some tutorials b

[PHP-DB] Re: [PHP] how do i get a variable type? - not that simple

i can't though, the variable and its value comes out of a string .. like this.. $var_string = "var1=this_is_a_value|var2=4.5|var3=another_value|var4=3.1415"; then i extract the pairs of vars and vals, then I need to determine if val is string or integer. - Original Message - From: "Mic

Re: [PHP-DB] Re: [PHP] how do i get a variable type? - not that simple

You could use ereg/preg to determine whether it: a) consists of nothing but digits from beginning to end, example: ^[0-9]+$ b) consists of nothing but digits separated by a single decimal, example: ^[0-9]+[.][0-9]+$ c) doesn't match the first two conditions, and therefore assume it is a string.

Re: [PHP-DB] DB Abstraction

Hello Jordan, On 11-Mar-01 09:47:16, you wrote: >I thought it was about time I started using a db abstraction class. Problem >is, there are so many out there that I don't which one to start using? If you are looking for a database abstraction package, I suppose you are looking that assures a s

[PHP-DB] Can PHP for Oracle randomly access rows in a result set?

Can PHP for Oracle randomly access rows in a result set? I have read documentation for both Oracle functions (ora_*) and Oracle 8 functions (OCI_*) but cant seem to find a way to randomly access rows in a result set like you can with PostgreSQL or MySQL ... whats the story here?! Are we FORCED to

[PHP-DB] Need space!!! php w/ oracle support

This semester I am enrolled in a database management class using Oracle. A couple of the projects we have to do ( next week!! ) is embedded SQL. I have convinced my instructor to let me use PHP for these projects. The problem is that our school server does not have PHP installed and won't do it