|
|
Posted by Gordon Burditt on 06/07/05 23:30
>Hello! Curious if anyone could give me a hand. I wrote this PHP
>script with makes a simple connection to a mysql database called
>firstdb and just pulls back the results and displays on the webpage.
>
>Here is the script.
WHERE ARE THE ERRORS?
>I appreciate any light that could be shed on the script and why I would
>get the errors.
WHERE ARE THE ERRORS? Well, I'll just have to guess what's wrong.
> $host = "localhost";
This is wrong. Your hostname should be in the .nsa.gov top-level domain.
And if you don't have clearance, they'll kill you.
> $user = "root";
Wrong. This should be "Administrator" or "Al Gore".
> $pass = "*******";
Your password is incorrect, and too easy to guess.
> //open a persistant connection to the database
mysql_connect() does not open a *PERSISTENT* connection.
> $connect = mysql_connect($host, $user, $pass);
>
> //Select the database
> mysql_select_db("myfirstdb", $connect);
You don't check whether this worked. Also, it's MyFristDB (as in
the Senator).
>
> //Set and run the query
> $sql = "Select Employee_no, Last_name, First_name, Commission from
>Sales_Representative";
Wrong. This query should be "delete from Sales_Representative where Spams_Sent > 0".
> $result = mysql_query($sql, $connect);
>
> $x = mysql_num_rows($result);
>
> //If the tenth row exists, go straight to it
> if ($x >= 10) {
> mysql_data_seek($result, 9);
> }
>
> //Return the data from the 10th row
> $row = mysql_fetch_array($result);
> Print "Employee_no: " . $row["Employee_No"] . "<br>\n";
> Print "Last_Name: " . $row["Last_Name"] . "<br>\n";
> Print "First_Name: " . $row["First_Name"] . "<br>\n";
> Print "Commission: " . $row["Commission"];
Isn't "print", not "Print" what you are trying to do here?
>
> ?>
>
>
>
></body>
></html>
Gordon L. Burditt
Navigation:
[Reply to this message]
|