Mysql Getting records

cafrow

Hey all, I am trying to make a news system where I can insert news into a table and then pull the topics and messages from the table. I already got the insert working, now just need some help pulling the info, i am getting some problems and I do not understand why I am getting them. here is what I have that WORKs right now, but as you can tell, it is sloppy and very N00b.

$selecttitles = mysql_query("SELECT title FROM news ORDER BY id DESC");

$titles1 = mysql_fetch_row($selecttitles);
$titles2 = mysql_fetch_row($selecttitles);


echo $titles1[0];
echo $titles2[0];

That gives me the titles, but I do not really want to run the code like that. I have tried doing this and it did not work.


$selecttitles = mysql_query("SELECT title FROM news ORDER BY id DESC");

$titles1 = mysql_fetch_array($selecttitles);

echo $titles1[0];
echo $titles1[1];

This tells me that 1 is not valid array offset, I do have a lot of records in the table. I want them to appear as the last one post first, so that is why I am doing a ORDER By id DESC because ID is a auto_increment.

Please help me a out a little here, I do not have much hair left from me pulling it out trying to get this to work. It is really weird, I thought it would work. Also this did not work


$selecttitles = mysql_query("SELECT title FROM news ORDER BY id DESC");

$titles1 = mysql_fetch_row($selecttitles);

echo $titles1[0];
echo $titles1[1];

I had an old script laying around where I got this last try from and it use to work, but for some reason it is not working now.

I am using the newest PHP(The newest NONBeta, so not the version5) and the MySQL on a XP box.

Thanks

cafrow

would this be the best way to handle what I am doing?


$selecttitles = mysql_query("SELECT title FROM news ORDER BY id DESC");

$titles1 = mysql_fetch_row($selecttitles);

while($titles1[0]){
      echo $titles1[0];
      $titles1 = mysql_fetch_row($selecttitles);

}

Seems really stupid. Also when I do a Echo $titles1 the output is Array. it just says array, not the value or anything like that.

DeltaRho2K

Try this to start. This will just list straight down, all of the titles according to your select criteria. Not really sure what you are trying to do by the nested loop, so if this doesn't work for you, give further details as to why it won't work for you, so we can try to nail it down a bit further.

$selecttitles = mysql_query("SELECT title FROM news ORDER BY id DESC"); 

while($titles1 = mysql_fetch_array($selecttitles)){ 
      echo $titles1[0]."<BR>"; 
}

cafrow

thanks so much for that. I am currently eating some homemade encheladas but will be making my script in a min, thank you so much for your help. I will post my end result in a few mins when I get it completly done.

Again, thanks so much

cafrow

this is what I ended up with, just need to add some tables and orginize it a bite. Thanks for your help. I was seriously getting mad that i could not get it to work, switching between ASP and PHP often is not helping me at all.

$selecttitles = mysql_query("SELECT * FROM news ORDER BY id DESC");


while($titles1 = mysql_fetch_array($selecttitles)){  

      echo $titles1['title']."<BR>";  

      echo $titles1['message']."<BR>";
      echo $titles1['user']."<BR>";
}

DeltaRho2K

Yeah, it is easier when you use the field names instead of the array index... that's for sure.

Glad it's all working.

And, I know the feeling of the whole ASP->PHP thing. I am in the middle of switching my company's intranet over to php after they insisted it be ASP because of being an IIS webserver. If only I could've gotten them to realize earlier that php would be fine... Oh well, call it job security I guess! 😉
Anyhow, good luck, and feel free to post more Q's as they arise.
~J