string problem

From: Date: Mon, 10 Jul 2006 11:27:39 +0000
Subject: string problem
Groups: php.general 
Request: Send a blank email to php-general+get-239245@lists.php.net to get a copy of this message
Hi all , I am using PHP 4.3.2 , MYSQL database and Red Hat Entreprise OS. I have the SQL statement which store in $str variable as shown below : How to get the '%WS-X5225R%' from $str variable ? $str = " SELECT DISTINCT(tbl_chassis.serial_no),tbl_card.card_model, ";
    "tbl_chassis.host_name,tbl_chassis.chasis_model,tbl_chassis.country,";
"tbl_chassis.city,tbl_chassis.building, "tbl_chassis.other,tbl_chassis.status,tbl_chassis.chasis_eos,tbl_chassis.chasis_eol,tbl_chassis.chasis_user_field_1,tbl_chassis.chasis_user_field_2,tbl_chassis.chasis_user_field_3" "from tbl_chassis tbl_chassis,tbl_card tbl_card "
"WHERE tbl_chassis.serial_no = tbl_card.serial_no AND tbl_card.card_model LIKE'%WS-X5225R%'";
thanks

« previous php.general (#239245) next »