Java and PHP problem

Anon

Hi,

What i'm trying to do:
* Using
<SCRIPT LANGUAGE='JavaScript' SRC='http://www.the-url-to-site.com/update.php3'>
</SCRIPT>
to call update.php3.
The update.php3 file will get latest three updates from a database.

Why?
Because I think this way anyone can add: <SCRIPT LANGUAGE='JavaScript' SRC='http://www.the-url-to-site.com/update.php3'>
</SCRIPT> and get my lates three updates displayed on their .html page.(not needing to make them .shtml or something like that)

THE CODE I WANT TO USE:
Connecting to server + choose database
$dbcnx = @mysql_connect("servername", "login", "pass");
mysql_select_db("basename");

$result = mysql_query("Select id, update from basename ORDER BY id desc LIMIT 3");
while ($row =mysql_fetch_array($result)) {
$id= $row["id"];
$update= $row["update"];

print "<font size=2 color=#000000><a href='http://www.the-url-to-site.com/update.php3?id=$id'>$update</a></font><br>";
}

Questions:
Am I wrong about this? Am I doing it the wrong way?

How will the syntax on the update.php3 page be for this to work with the Java?

best regards,
Alex Butcher

Anon

I'm not that familiar with client-side scripting, but as far as i know you would replace your current print statement with:

print "document.write(\"<a href='http://www.the-url-to-site.com/update.php3?id=$id'>$update</a><br>\")";

Try that and see if it works.

Anon

I tried the code u suggested.
This is what i got:

<?php
// Koble til database server
$dbcnx = @mysql_connect("xxxxx");

// Velg database
mysql_select_db("xxxx");

$result = mysql_query("Select id, from footballbc ORDER BY id desc LIMIT 3");
while ($row =mysql_fetch_array($result)) {
$id= $row["id"];
$update= $row["update"];

print "document.write(\"<a href='http://www.the-url-to-site.com/update.php3?id=$id'>$update</a><br>\")";
}
?>

This gives me this when running the update.php3 page:
document.write("New test
")document.write("Testing the script
")document.write("Hope this works
")

When I'm trying to get this with:
<SCRIPT SRC="'http://www.the-url-to-site.com/update.php3"></SCRIPT>

I get an error:
Done, but with errors on page.

What am I doing wrong?
Isn't it possible to get the update.php3 page with the <SCRIPT>?

webfandango

I would remove the comma after id since you are only selecting one field...

Select id, from footballbc

Anon

Yes, but that doesn't solve my problem.
Thanks anyway=)