hey guysssssss
i settle the prob
thats all the help from all of u, its bcoz
the table has to be tbl_bby, not tbl_BBY, caps lock
its recog as different table, its my mistak
again, thanks for all the helping hands...
:))
--- Sheila Fenelon <sfenelon@xxxxxxxxxxxxx> wrote:
> What does this tell you?
>
>
> $query = "Select txt_ID FROM tbl_BBY ";
> $result = mysql_query($query);
> if (mysql_errno()) {
> echo "<p>MySQL error: ". mysql_error() .
> "</p>";
> echo "<p>SQL: $query</p>";
> die;
> }
>
>
> Here's another way to check for errors.
>
>
> $query = "Select txt_ID FROM tbl_BBY ";
> $result = mysql_query($query);
> if (!$result) {
> echo "<p>MySQL error: ". mysql_error() .
> "</p>";
> echo "<p>SQL: $query</p>";
> die;
> }
>
>
> --
> Sheila
> http://www.shefen.com/
>
>
>
> Anuradika Jaganadhan wrote:
> > it shows all the tables in the db, but i m aunable
> to
> > connect using
> > mysql_fetch_array():
> > mysql_fetch_assoc():
> > mysql_num_rows():
> > please help
> >
> >>>>4.1. I am using
> >>>>
> >>>>require("Conn_to_Mysql.php");
> >>>>$query = "Select * from tbl_BBY ";
> >>>>$result = mysql_query($query);
> >>>>while($row = mysql_fetch_array($result,
> >>>>MYSQL_ASSOC))
> >>>>{
> >>>>
> >>>>}
> >>>>
> >>>>Its running in my office pc, and my home pc, but
> >>>>when i upload to the
> >>>>webserver, its giving error as such, anyone able
> >>
> >>to
> >>
> >>>>help me to solve
> >>>>this issue.
> >>>>
> >>>>Warning: mysql_fetch_array(): supplied argument
> >>
> >>is
> >>
> >>>>not a valid MySQL
> >>>>result resource
> >>>>
> >>>>Thanks in advance.
> >>>>
> >>>>
> >>>
>
>
________________________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
PHP Data object relational mapping generator - http://www.meta-language.net/
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-objects/
<*> To unsubscribe from this group, send an email to:
php-objects-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
