Ok. This time my problem's to do with inputting data into the database.

I was wondering how I would go about doing that. I'm using a form that's ready for the database, but as of yet there's no database link.

What would the PHP/MySQL scripting be? It's making me go a little crazy!!!

Database connection 101 in PHP:

PHP Code:


<? 
//  Config file to connect database

//  connection to database
function make_seed() 
{
    list($usec, $sec) = explode(' ', microtime());
    return (float) $sec + ((float) $usec * 100000);
}
srand(make_seed());

$dbcnx = @mysql_connect("localhost", "User_name", "Pass_word");
  if (!$dbcnx)
  {
    echo( "<p>Unable to connect to database server, please retry.  If error contunies to occur please email the 
    webmaster</p>");
    
    exit();
  }
?>

Thats to connect to the database server.
Now to connect to a specfic database.

PHP Code:

<?
      if (! @mysql_select_db("Database_name") )
      {
        echo("<p>Error connecting to database please try again.  If error continues to occur please contact the webmaster.</p>");
        exit();
      }
?>

Now to run a select query on that table

PHP Code:

<?

$result = mysql_query("SELECT rowname1, rowname2 FROM table_name WHERE rowname='value'");

if (!$result)
{
        echo("<p>Error connecting to database please try again.  If error continues to occur please contact the webmaster.</p>");
        exit();
}

?>

Feel free to ask questions.

OK. here's what I was able to scratch up.

<?
$username="usr_name";
$password="pword";
$database="d_base";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM table";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

$i=0;
while ($i < $num) {

$date=mysql_result($result,$i,"date");
$shortinfo=mysql_result($result,$i,"shortinfo");
$maininfo=mysql_result($result,$i,"maininfo");
$link=mysql_result($result,$i,"link");


echo "<TD><TABLE border=1 bordercolor=FFFFFF cellpadding=0 cellspacing=0 width=100%><TR><TD class=greytitles width=33%>
<b>$date</TD></TR><TR><TD colspan=2 class=whitetitles>$shortinfo<br>$maininfo<br>$link </TR></TD></TABLE></TD>";

++$i;
}

?>

I just need this one to show the last three records. (ahh! @ News page!) The importing to the database is my real trouble at the moment. Any ideas Lippy?

OK. database sorted. One more TINY TINY thing. ;-) when it comes to inputting data from a HTML form, how would I go about inserting the information onto the database when it has more than one column? (ie News, date, extra_information)

I know I can use :

mysql_query("INSERT INTO news (title) values ('$title');"
); for example, but that would only input one variable from the form.

you are making me look into old code.

PHP Code:

<?

$newrecord = mysql_query("INSERT into tbl_name SET field1='$value1', field2='$value2', field3='value3'");

if (!$newrecord)
{
     echo("Unable to locate query at this time");
     exit();
}

?>

Hope this helps.

Sorry Lippy for making you look It's me being old skool again

S'ok now! I've cracked it I think Thanks for your time and effort

A pleasure, was purely joking about having to look in old code, love looking back at my past work and being able to say "Why the heck did I do it that way when its so much better doing it this way!"