Small PHP Problem --- I think :)

mind_problems · 28-04-2005 09:09PM #1

Hi ive been at this friggin PHP for hours trying all sorts of ways to get it working but i cant seem to figure it out. All i want to do is pull the contents of my database table onto a web page. Il post the code below and if anyone can give me a hand il be forever in your debt.

[php]
<html>

<body>

<?php

$host="localhost";
$user="*****";
$password="*****";
$database="*****";

mysql_connect($localhost,$user,$password,$database);

@mysql_select_db($database) or die( "Unable to select database");

// display list of employees

$result = mysql_query("SELECT * FROM employees");

while ($myrow = mysql_fetch_array($result)) {

printf("<a href=\"%s?id=%s\">%s %s</a><br>\n", $PHP_SELF, $myrow["id"], $myrow["first"], $myrow["last"], $myrow["address"], $myrow["position"]);

?>

</body>

</html>

[/php]

Thanks again

Jammer · 28-04-2005 09:16PM

no expert but...

$host="localhost";
$user="*****";
$password="*****";
$database="*****";

mysql_connect($localhost,$user,$password,$database);

That looks wrong?

mind_problems · 28-04-2005 09:30PM

Hi thanks for that jammer, ive made the changes but still no luck. Any ideas?

hostyle · 28-04-2005 09:54PM

mind_problems wrote:

Hi ive been at this friggin PHP for hours trying all sorts of ways to get it working but i cant seem to figure it out. All i want to do is pull the contents of my database table onto a web page.

Rather than us picking through your code to find out what where stuff goes wrong, how about you tell us what doesnt seem to work?

seamus · 29-04-2005 08:33AM

/nods

I can see a couple of syntax errors, but you'll have to post up the errors you're getting and we can tell you what's exactly wrong.

forbairt · 29-04-2005 08:42AM

think you've failed to close off your while loop with its curly brace ... } ??

then again maybe its early and I should have another coffee...

as the lads said ... error output would be handy ...

Caixa · 29-04-2005 09:29AM

Try this:
[php]
<html>

<body>

<?php

$host="localhost";
$user="*****";
$password="*****";
$database="*****";

$connection = mysql_connect($localhost,$user,$password);

@$db = mysql_select_db($database,$connection) or die( "Unable to select database");

// display list of employees

$result = mysql_query("SELECT * FROM employees");

while ($myrow = mysql_fetch_array($result)) {

echo "<a href=\"%s?id=%s\">%s %s</a><br>\n".$PHP_SELF, $myrow["id"]
.$myrow["first"].$myrow["last"].$myrow["address"].$myrow["position"];

}

?>

</body>

</html> [/php]

Small PHP Problem --- I think :)

Comments