Skip to main content

array

May 10, 2011 by handi2009

handi2009's picture

salam semuanya... minta tolong nih, coding pake CI 2 di controller, diketik :

$row = mysql_fetch_array($result,MYSQL_NUM);

terus, keluar error:

"A PHP Error was encountered
Severity: Warning
Message: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
Filename: controllers/pekerja2.php

Line Number: 26"

kl ada yg bisa tolong ksh tau ya.. :) trims...

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

setuju

May 12, 2011 by bubis, 1 week 5 days ago
Comment: 8150

bubis's picture

Beney kata agan predhtz tu gan, mending pake active record az, lebih simple.......

$this->db->get('nama_table');

kynya bakalan ga' ada yg bisa

May 11, 2011 by kreamik, 2 weeks 11 hours ago
Comment: 8142

kreamik's picture

kynya bakalan ga' ada yg bisa jawab nih knpa ..
coba terangkan dl .. $result itu isinya apa ..

baru pasti ada yg tau jawabannya :D

$result itu minimal harus :

$query = "SELECT * FROM table";
$result = mysql_query($query);

kalo dah pake CI, buat

May 11, 2011 by predhtz, 2 weeks 13 hours ago
Comment: 8140

predhtz's picture

kalo dah pake CI, buat apalagi pake $row = mysql_fetch_array($result,MYSQL_NUM); ?
mending pake active records aja

Tergantung kebutuhan juga

May 13, 2011 by krist, 1 week 5 days ago
Comment: 8153

krist's picture

Tergantung kebutuhan juga lah.. Ga bisa selalu pakai AR CI.
Buat apa CI sediain query selain AR? Pasti ada maksudnya kan.. Nah, kebutuhan itulah yang bisa jawab

sorry... kurang

May 24, 2011 by predhtz, 1 day 6 hours ago
Comment: 8218

predhtz's picture

sorry... kurang lengkap...
emang bener... query yang dipake tergantung kebutuhan....
maksud saya, untuk generate resultset-nya kan bisa pake method yang ada di CI....
misal ...
$query = $this->db->query("bla..bla..bla..");
dari pada pake mysql_fetch_array(), mumpung dah pake CI, skalian aka pake misal... foreach($query->result() as $row) atau $query->result_array() as $row....

Premium Drupal Themes by Adaptivethemes