Problem with DB connection

Posted on 16th Feb 2014 07:03 pm by admin

Hello there! I'm new to this forum and I'm new to PHP coding also. I wrote something that doesn't make exactly what I thought it will. Can you give me a hand please. There we go:
Code: [Select] <?php
error_reporting(E_ALL);

$Host = "***";
$User = "***";
$PassWord = "****";
$DataBaseName = "***";
$TableName = "products";

mysql_connect($Host, $User, $PassWord);
mysql_select_db($DataBaseName);

if (isset($_GET['id'])) {
$id = (int)$_GET['id'];
// $select = "SELECT id FROM" . $TableName;
if ($id > 0) {

$select = "select description from" . $TableName . "WHERE id = " . $id;
$result = mysql_query($select);
echo $result;
echo $id;
}

else {
echo "id not > 0";

}
}
else {
echo "ID not set;
}
?>
<p><a href="proba.php?id=1" name="id=1"> Find out more about it. </a></p>
<a href="proba.php?id=2" name="id=2"> Find out more about it. </a></p>
<a href="proba.php?id=3" name="id=3"> Find out more about it. </a></p>
That's a testing page only. What happens here is that only the ID is displayed.
The funny thing is when i add this code to the original page, my apache gives errors on the localhost and i get Quote Premature end of script headers. Obviously I'm doing something wrong, but I don't know what it is. oh, when i run this code on the original page but remove the password, apache is not shoting..

Your Answer:

Login to answer

Other forums

This is driving me nuts!
This insert query looks to be alright, however I get this error:

QuoteYou have an error in yo

Is there something wrong?
Hi all,

Just a quick question... can someone look at this code and see if something is wrong?

Oracle Connectivity
Hi Every One,

Can we access SAP from oracle database.If it possible then please spec

IP Based Cron Jobs
I run cronjobs on my website. After one of my visitors got curious and tinkered around he realized h

SCO Unix
I know this might not be the place to ask, but, can anyone tell me if SCO Unix comes with PHP built

Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
i want to know the queries issued by various users accessing a database...

cyrillic string conversion question
Hello,

First time here...

I would like to know if there is a way to convert a

button help
i originally had this but realised it is much easier to have a button.

Code: <?php

php title problem
Hi,

I am having a problem managing my page title with PHP.

Currently I have my <

Operator precedence assistance.
I did a quick Google search and couldn't quite find the answer I wanted in terms I could understand,