Postingan lainnya
error di query
halo gan ini penyebab nya apa yah? saya pernah coba pake mssql_query tapi gak pernah error kenapa ini error yah?
<?php
$servername = "SERVER";
$username = "hpuser";
$password = "paiho@adminweb";
$dbname = "phmis";
// membuat koneksi
$koneksi = mssql_connect($servername, $username, $password, $dbname);
if($_POST['rowid']) {
$id = $_POST['rowid'];
$sql = ("SELECT * from [cust_pric] where cp_cid='$id'");
$result = mssql_query($koneksi, $sql); // koneksinya didalam query jgn diluar
while($row = mssql_fetch_assoc($result) ){
?>
<table class="example">
<tr>
<td>cp_cid</td>
<td>:</td>
<td><?php echo $row['cp_cid']; ?></td>
</tr>
<tr>
<td>cp_mate</td>
<td>:</td>
<td><?php echo $row['cp_mate']; ?></td>
</tr>
<tr>
<td>cp_hues</td>
<td>:</td>
<td><?php echo $row['cp_hues']; ?></td>
</tr>
</table>
<?php
}
}
mssql_close($koneksi);
?>
5 Jawaban:
<pre> if($_POST['rowid']) { $id = $_POST['rowid']; $sql = ("SELECT * from cust_pric where cp_cid='$id'"); $result = mysqli_query($koneksi, $sql); // koneksinya didalam query jgn diluar while($row = mysqli_fetch_assoc($result) ) </pre>
coba gan
Tanggapan
Ini mssql bukan mysql
yakin ada [ ] di query nya?
<pre> SELECT * from [cust_pric] where cp_cid='$id' </pre>
iyah gan kalo mssql server query nya harus pakai []
ane pake sql server gan jadi harus mssql bukan mysqli
coba dibalik dan [] dihilangkan <pre> $sql = ("SELECT * from cust_pric where cp_cid='$id'"); $result = mssql_query($sql, $koneksi); </pre>