whats wrong with my update statement. I can not see it.

[csphard]

$sql = "update tbl_listings
set address = '" . $strAddress . "',city = '" . $strCity . "',tg = '" . strTg . "',beds = '" . $strBeds . "',baths = '" . $strBaths . "',terms = '" . $strTerms . "',sqft = '"
. $strSqft "', lot = '" . $strLot . "',price = '" . $strPrice . "',status = '" . $strStatus . "' where l_id ='" . $strId . "'";

Howard

 

[feherke]

Hi

For example a missing dollar sign ( $ ) :

[navy]$sql[/navy] [teal]=[/teal] [green][i]"update tbl_listings[/i][/green]
[green][i]set address =  '"[/i][/green] [teal].[/teal] [navy]$strAddress[/navy] [teal].[/teal] [green][i]"',city = '"[/i][/green] [teal].[/teal] [navy]$strCity[/navy] [teal].[/teal] [green][i]"',tg = '"[/i][/green] [teal].[/teal] [highlight][red]$[/red][navy]strTg[/navy][/highlight] [teal].[/teal] [green][i]"',beds = '"[/i][/green] [teal].[/teal] [navy]$strBeds[/navy] [teal].[/teal] [green][i]"',baths = '"[/i][/green] [teal].[/teal] [navy]$strBaths[/navy] [teal].[/teal] [green][i]"',terms = '"[/i][/green] [teal].[/teal] [navy]$strTerms[/navy] [teal].[/teal]  [green][i]"',sqft =  '"[/i][/green]
[teal].[/teal] [navy]$strSqft[/navy] [green][i]"', lot = '"[/i][/green] [teal].[/teal] [navy]$strLot[/navy] [teal].[/teal] [green][i]"',price = '"[/i][/green] [teal].[/teal] [navy]$strPrice[/navy] [teal].[/teal] [green][i]"',status = '"[/i][/green] [teal].[/teal] [navy]$strStatus[/navy] [teal].[/teal]  [green][i]"' where l_id  ='"[/i][/green] [teal].[/teal]  [navy]$strId[/navy] [teal].[/teal] [green][i]"'"[/i][/green][teal];[/teal]

Using an editor with syntax highlighting feature helps finding such typos.

Feherke.

http://rootshell.be/~feherke/

 

[csphard]

thanks. I am new to php. Can you name free editors

 

[feherke]

Hi

I am new to php. Can you name free editors

But not new to Tek-Tips. So you have no excuse not reading faq434-4252 . ;-)

Personally I use Midnight Commander's built-in editor. Years ago on Windows I used ConTEXT.


Feherke.

http://rootshell.be/~feherke/

 

[IPGuru]

I used to use gPHPedit, but I quite like geany
it copes with HTML, PHP javascript C & C++ & is also available on windoze if necessary