Where is 'domain.' coming from? Is that something MySQL added to the error message or does your query look like this? $query = "Select txt_ID FROM domain.tbl_BBY "; -- Sheila http://www.shefen.com/ Anuradika Jaganadhan wrote: > MySQL error: Table 'domain.tbl_BBY' doesn't exist > but when i try to do SHOW TABLE, it does shows all the > tables including tbl_BBY, please help > > > > --- 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. >>>>>> >>>>>> >>>>> >> > 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/
