First Attempt at News Postings (or any database entries, for that matter)

BlackViperSJM

I've built with PHP before, but just basic stuff. This is my very first time using a database, and I'm hitting a brick wall. I'm a total n00b, of course. That's the trend for this board, right? 😉

I'm not sure what's going wrong here. I think I've included every semi-colon, quote, dollar sign, and parenthesis that I need. I've checked the basic logic, and I think it's sound. At least, it shouldn't be giving me the errors I'm seeing. Here is the code. I've pulled the code right out of the "include" files and dropped them in the code, so there's only one section to see. The output (errors) are also posted below, along with a link to the file.

Since I'm just building this site and seeing what's possible, no data entry checking is included yet. I (obviously) will be including this once the script actually runs correctly.

<?php

  echo "<html><body>";

//  for low-level access, username = lcgsteve_member   password = member
  $db = mysql_connect("localhost", "lcgsteve_member", "member");
  $db_selected = mysql_select_db("lcgsteve_news", $db);

//  I want to count the number of rows so I know how many news items to print
  $query = "SELECT * FROM news";
  $result = mysql_query($query, $db);
  $row = mysql_num_rows($result);

//  Each news item displays, with the most recent at the top.
  for ($i = 1; $i<$row; $i++)
  { 
    if (!$newsid || $newsid=="")
      echo "There are no news updates.";
    else
    {
      $conn = db_connect();

//  When $i = 1, $row = 0. This SHOULD put the most recent entry first.
      $query = "select * from news where newsid=($row - ($i - 1))";
      $result = @mysql_query($query);
      if (!$result)
        echo "There are no news updates.";
      else
        $result = @mysql_fetch_array($result);
    }
    if (is_array($result))
    {
      echo $result["headline"]."<br>";
      echo $result["content"]."<br>";
      echo "<i>Posted by ".$result["author"]." on ".$result["date"].".</i>";
    }
    else
      echo "There are no news items to display.";
  }

  echo "</body></html>";
?>

http://www.lastchancegames.com/main/index.php

Warning: mysql_pconnect() [function.mysql-pconnect]: Protocol mismatch. Server Version = 13 Client Version = 10 in c:\users\sitedata\lcgsteve\web\main\index.php on line 6

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in c:\users\sitedata\lcgsteve\web\main\index.php on line 7

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in c:\users\sitedata\lcgsteve\web\main\index.php on line 11

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\users\sitedata\lcgsteve\web\main\index.php on line 12

Now you should know, there is absolutely NOTHING important on this site right now. So if you want to see the back end of how things work (I host on Seanic.net), I'm able to provide a username & password, providing you don't block me out of my own site! I just want this thing fixed with a better understanding about how this stuff works.

THANK YOU!!!

EDIT * I have changed pconnect to connect, but I am still getting the same error.

thorpe

i havent seen that error before 'Protocol mismatch', but it is causing all the others aswell. for whatever reason it seems somethings not compatible.

anyway, you should really be using mysql_connect() and not mysql_pconnect(), who knows... that may even fix the problem.

BlackViperSJM

Okay. I've changed the pconnect to connect, but I'm still getting the exact same errors.

mysql_connect is a standard file, right? It's impossible that I would be missing a file allowing this command to happen?

Or is it possible that, for some reason, my file is in the wrong place? Even though I'm not calling any other file, could some setting point to the wrong location?

Or, maybe I don't really know what I'm talking about. That's entirely possible, too. :eek:

thorpe

ok... i think i might be onto the problem. what versions of both php and mysql are you using? and what os are you running?

BlackViperSJM

http://www.lastchancegames.com/main/phpinfo.php

I'm on a Windows server.

PHP 4.04

I don't know what version of MySQL is supported, to be perfectly honest with you. I am hosting my site from seanic.net, and I can't find that information right away.

Of course, the phpinfo() file is listed above, so it may answer more questions than I can. I don't really understand all of the information on that page, but maybe it will help you.

BlackViperSJM

Here's an interesting thing. The server is running Microsoft-IIS/6.0 instead of Apache. I'm not sure if that matters at all, but I never realized it until checking out my phpinfo.

LoganK

thorpe wrote:
anyway, you should really be using mysql_connect() and not mysql_pconnect()

Why? I always use pconnect

BlackViperSJM

I was kind of curious about that myself, but like I said - I'm a n00b. As I understand it (and I could be wrong), it allows my user to continue to keep an open connection instead of reconnecting; I can create the $db variable to reference when I'm using select commands and the like, and makes future queries faster instead of re-connecting each time. The downside is, of course, the limited number of connections available at a time.

Is there an extremely simple application using a database that I could setup to test? The PHP is fine, but I get errors when I try using the database. If there is a simple application I could start, I might be able to narrow down exactly what is going wrong.

BlackViperSJM

I've also got a few other suggestions going on, if it might help better understand another line of thinking:

http://rvb.roosterteeth.com/forum/viewTopic.php?id=2174325