Re: [PHP-DB] strings of variables,php, sql

2003-11-25 Thread Joffrey Leevy
--- George Patterson <[EMAIL PROTECTED]> wrote: > On Mon, 24 Nov 2003 21:36:29 -0800 (PST) > Joffrey Leevy <[EMAIL PROTECTED]> wrote: > > > Would appreciate in anyone can help me. > > > > Let's say I do a query in php, eg. $query = > "select > > shed from structure"; With the mysql_fetch_array

Re: [PHP-DB] strings of variables,php, sql

2003-11-24 Thread George Patterson
On Mon, 24 Nov 2003 21:36:29 -0800 (PST) Joffrey Leevy <[EMAIL PROTECTED]> wrote: > Would appreciate in anyone can help me. > > Let's say I do a query in php, eg. $query = "select > shed from structure"; With the mysql_fetch_array > function and a loop I could see all the values stored > in the

[PHP-DB] strings of variables,php, sql

2003-11-24 Thread Joffrey Leevy
Would appreciate in anyone can help me. Let's say I do a query in php, eg. $query = "select shed from structure"; With the mysql_fetch_array function and a loop I could see all the values stored in the column, shed, using the command: echo $shed; Let's say now that I am carrying over a variable

[PHP-DB] Strings

2001-03-19 Thread Mick Lloyd
CC/Steve Thanks for the advice. I managed to get the "... Code = '".$row['Primaryexpertise']."'" option working but not the others. Thanks again. Regards Mick Lloyd [EMAIL PROTECTED] Tel: +44 (0)1684 560224 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PR

RE: [PHP-DB] Strings

2001-03-19 Thread Steve Brett
$row[Primaryexpertise] //not like this $row['Primaryexpertise'] //like this $row["Primaryexpertise"] //or like this >i always user double quotes with postgrtesql and it works like a treat. > the difference seems to be with mysql. Also, even though simple variable references are expanded within

Re: [PHP-DB] Strings

2001-03-18 Thread CC Zona
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

[PHP-DB] Strings

2001-03-18 Thread Mick Lloyd
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