Dear Fred.
Your explanation is very complete. Thank you very much
for your generousity.
My problem has been solved, Thank you.
--- Fred van Engen <[EMAIL PROTECTED]> wrote:
> Hi,
>
> On Sun, Mar 30, 2003 at 05:39:13AM -0800, Prabu
> Subroto wrote:
> > Dear my friends....
> >
> > I am trying to read the content per line of a
> query
> > result with "mysql_fetch_row". But I got this
> error
> > message :
> > "
> > Musingin homepage
> >
> > koneksi sukses. Sukses memilih database. Sukses
> > melakukan query. Besar hasil query 1.
> > Warning: mysql_fetch_row(): supplied argument is
> not a
> > valid MySQL result resource in
> > /srv/www/htdocs/i-am-e-system/cgi-bin/tulis.php
> on
> > line 20
>
> The query failed, so it didn't return a valid
> result, whether emtpy or
> not.
>
>
> > Akhir baris.
> > "
> >
> > Could any body tell me where my mistake?
> >
> > Here is my codes under belom:
> > <?PHP
> > $konek=mysql_connect("localhost", "prabu",
> > "password");
> > if ($konek){
> > echo "koneksi sukses.\n";
> > mysql_select_db("berita");
> > echo "Sukses memilih database.\n";
> > $kalimatsql="
> > SELECT noberita, pengirim, tanggal,
> namafile
> > FROM berita
> > ";
>
> I'm not sure what's wrong with the query, but you
> can call mysql_error
> to find out.
>
>
> > $hasil = mysql_query($kalimatsql, $konek);
>
> Now check if the query was successful:
>
> if (!$hasil) {
> echo mysql_error();
> }
> else {
>
> > echo "Sukses melakukan query.\n";
> > $besarhasil=sizeof($hasil);
>
> What I guess you want to do here is call
> mysql_num_rows to get the
> number of rows in the result. Use sizeof to get the
> number of items in
> a list, not in a MySQL result resource, which is a
> single result object.
>
>
> > echo "Besar hasil query $besarhasil.\n";
> > while ($baris = mysql_fetch_row($hasil)){
> >
> >
> list($noberita,$pengirim,$tanggal,$namafile)=$baris;
> > echo "
> > Nomer berita : $noberita\n
> > Pengirim : $pengirim\n
> > Tanggal : $tanggal\n
> > Nama file : $namafile\n
> > ";
> > }
> > echo "Akhir baris.\n";
> >
> > } else echo "Gagal konek.\n";
> > mysql_close($konek);
> > ?>
> >
> > Thank you very much in advance.
> >
>
> You're welcome.
>
>
> Regards,
>
> Fred.
>
>
> --
> Fred van Engen XB
> Networks B.V.
> email: [EMAIL PROTECTED]
> Televisieweg 2
> tel: +31 36 5462400 1322 AC
> Almere
> fax: +31 36 5462424 The
> Netherlands
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
>
http://lists.mysql.com/[EMAIL PROTECTED]
>
__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
