ציטוט:
נכתב במקור על ידי snirk
ניסתי לעשות את זה .. לא עוזר.
|
תעתיק
PHP קוד:
mysql_select_db($database_gb, $gb);
$query_InstertToSql = "SELECT * FROM search1 WHERE cboGenralPracticeArea LIKE '$cboGenralPracticeArea' AND cboSpecPracticeArea LIKE '$cboSpecPracticeArea' AND cboCity LIKE '$cboCity' AND cboLanguagesSpoken LIKE '$cboLanguagesSpoken' AND cboLawSchool LIKE '$cboLawSchool' AND cboMajorMemberships LIKE '$cboMajorMemberships' AND cboBoardMemberShip LIKE '$cboBoardMemberShip' AND cstreet LIKE '$cstreet' AND cphone LIKE '$cphone' AND cname LIKE '$cname' AND cltdname LIKE '$cltdname' ORDER BY sid DESC";
$InstertToSql = mysql_query($query_InstertToSql, $gb) or die(mysql_error());
$query = mysql_fetch_assoc($InstertToSql);
$total = mysql_num_rows($InstertToSql);
if($total>0) {
while ($row_sql = mysql_fetch_assoc($InstertToSql)) {
echo "
<table style='width: 100%'>
<tr>
<td class='style1'><span lang='he'>שם העסק</span></td>
<td class='style1'><span lang='he'>פלאפון\טלפון</span></td>
<td class='style1'><span lang='he'>רחוב</span></td>
<td class='style1'><span lang='he'>שם מלא</span></td>
</tr>
<tr>
<td class='style1'>$row_sql['cltdname']</td>
<td class='style1'>$row_sql['cphone']</td>
<td class='style1'>$row_sql['cstreet']</td>
<td class='style1'>$row_sql['cname']</td>
</tr>
</table>
";
}
} else
{
echo "אין תוצאות מתאימות";
}