Jump to content

display news (<=script=>)


ahmed17

Recommended Posts

hello..,

i create news script to display news but i want to display the subject of news into javascript page
and there's problem ,if user select the title of news how i can make select title tie to its subject

here's script
1st:database
[code]CREATE TABLE `news` (
`id` TINYINT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`title` VARCHAR( 50 ) NOT NULL ,
`subject` VARCHAR( 51 ) NOT NULL
) ENGINE = innodb;[/code]

php code:
========
[code]<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
      <title>Title here!</title>
</head>
<body>
<?php

$host="localhost";
$user="root";
$pass="";
$database="news";
$table="news";

$link = mysql_connect('localhost', "$user", "$pass")or print"failed connection";
        mysql_select_db($database,$link)or print "not exists";
       
$_sql="INSERT INTO $table(title,subject)VALUES('my test script...news','this is my topic')";
$result=mysql_query($_sql,$link);
/*if($result)
{
    echo"sucess entery data";

}else{
    echo"failed entery data";
} */


$query=("select * from $table");
$result= mysql_db_query($database,$query,$link);

?>
<table width=100% height=100>
<tr>
<td bgcolor=iceyellow>
<marquee direction="right" onmouseover="this.scrollAmount=0" onmouseout="this.scrollAmount=4">
  <? while ($row = mysql_fetch_assoc($result) )
          {
                          $title  =$row['title'];
                          $subject =$row['subject'];
                          echo "<a href='inselect.php?title=$title'>.::::.$title</a>";
          }
  ?>
</marquee>

</td>
</tr>
</table>
</body>
</html>[/code]
Link to comment
https://forums.phpfreaks.com/topic/23709-display-news/
Share on other sites

Oh, so you want it to open in a new window...

That's not a php issue, it's HTML/Javascript

Try googling for [url=http://www.google.co.uk/search?hl=en&q=javascript+%2B%22open+new+window%22&meta=&btnG=Google+Search]javascript +"open new window"[/url]

Regards
Huggie
Link to comment
https://forums.phpfreaks.com/topic/23709-display-news/#findComment-108851
Share on other sites

well you could just do a javascript popup with the id in it. example:
[code]<a href="javascript: openpopup('1');">Open News</a>[/code]

then in your openpopup() javascript function have it open a php page like http://www.site.com/news/java_popup.php?newsid=1 then just get the news info from the database by using the newsid.

but i am still not sure on what your asking.
Link to comment
https://forums.phpfreaks.com/topic/23709-display-news/#findComment-112580
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.