Jump to content

astaroth

New Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Contact Methods

  • MSN
    astakas@hotmail.com

Profile Information

  • Gender
    Not Telling

astaroth's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. actually it\'s a newbie question..... i need to make a table inside a php code... do i have to write like $sql=(create temporary table KWTemp type=heap (ID int auto_increment primary key not null, KW varchar(255) not null)\"); OR can i it work without the $sql just (create temporary tabel ....)
  2. I have problem.... i need a count of how many firms name are searched in the table of Requests, The firm ID is in the table Com... $name=("SELECT SUBSTRING(Name,1,4) FROM Com WHERE Com.ComID=\'$CID\'"); $query=("SELECT count(*) as CD FROM Com LEFT JOIN Requests ON Com.ComID=Requests.ID WHERE Action=\'search\' && Keyword like \'%$name%\'"); $result=mysql_query("$query"); while($r = mysql_fetch_array($result)) { $r[CD]; } The problem is that SQL dont accepts $name in Keyword like \'%$name%\'\"); May be someone can help.....any ideas?? :?:
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.