[RESOLVED] Wildcard * Dont Work On Server

taurus5_6

I am * wildcard in my localhost phpMyAdmin 2.5.3.

Problem comes if I use it online in my server using phpMyAdmin - 2.9.0.2.

It only accepts if I indicate all field names one by one. heres the code:
<? $sql = "SELECT * FROM tbl_news WHERE news_id = $news_id";

It only works if I use:
<? $sql = "SELECT content, picsmall, piclarge, news_id, title, dt_created FROM tbl_news WHERE news_id = $news_id";

What shall I replace * so I dont have to write all of my field names in the query?

stolzyboy

should work, how are you trying to access the variables once you get the results?

taurus5_6

Here is how i use the variable:

<? $sql = "SELECT * FROM tbl_news WHERE news_id = $news_id";
$result = put_result($sql);
$row = mysql_fetch_object($result) ?>
<td width="80%" valign="top" class="bottomsep">
<span class="eleventxtboldhead"><? echo($row->title) ?></span> <br>
posted: <? echo(date("M-d-Y", strtotime($row->dt_created))); ?> | <a href="mailto:me@mywebsite.com?subject=<? echo($row->title) ?>">Comment on post</a>

Even the <? echo($row->title) ?> do not display the title if in case i have not used *

stolzyboy

i see nothing wrong with your code... aside from i don't know what put_sql() does, but if it works with the fieldnames, i dunno, this is an example directly from php.net on mysql_fetch_object

<?php
mysql_connect("hostname", "user", "password");
mysql_select_db("mydb");
$result = mysql_query("select * from mytable");
while ($row = mysql_fetch_object($result)) {
   echo $row->user_id;
   echo $row->fullname;
}
mysql_free_result($result);
?>