Scrolling Text

DropLister · 06-27-2005, 10:21 AM

I want to scroll dropping domain names on my site, and i want to be able to just add the domain names to a sql database or text file then with php or javascript call the text file and scroll each name one after the other on a loop. Im using marquee right now and adding them manually but thats real annoying. !pleH

Wildchild22 · 06-27-2005, 10:32 AM

im not too sure about php MySQL, but in asp i think you would probably use something like the following, maybe php would be similar?...

Code:

<MARQUEE>
<%
sql = "SELECT * FROM Domains";
domains = conn.Execute(sql);

while (!domains.EOF)
{
Response.Write(unescape(domains(0)))
domains.MoveNext();
}
%>
</MARQUEE>

i may be wrong though, im no expert

**database connection not shown..... because i can't be bothered typing it**

DropLister · 06-27-2005, 10:42 AM

thats a start ill alter it to php, b/c I cant us asp on a unix server

Wildchild22 · 06-27-2005, 10:50 AM

yeah, sorry i couldn't be much more help.... my PHP knowledge is limited

Porte · 06-27-2005, 12:29 PM

I'll assume that you already know how to enter info in a database, and how to construct a mysql database.

you can call it very easy:

<?

$sql = mysql_query("SELECT * FROM dropping_names ORDER BY (optional to you)");

while($row = mysql_fetch_array($sql) {

// output here..

}

?>

that's it. but, that involves how you want to order the domains, and how many you want to show on one page, you might need a basic navigation system. If you need let me know, I'll show you a tutorial for this which i use already on my coding.

Good luck.

06-27-2005, 10:21 AM	#1 (permalink)
DropLister Senior Member Join Date: Apr 2005 Location: .ma.us Posts: 1,783 21.95 NP$ (Donate)	Scrolling Text I want to scroll dropping domain names on my site, and i want to be able to just add the domain names to a sql database or text file then with php or javascript call the text file and scroll each name one after the other on a loop. Im using marquee right now and adding them manually but thats real annoying. !pleH __________________

06-27-2005, 10:32 AM	#2 (permalink)
Wildchild22 NamePros Regular Join Date: Jun 2005 Location: S. Yorkshire, United Kingdom Posts: 310 93.00 NP$ (Donate)	im not too sure about php MySQL, but in asp i think you would probably use something like the following, maybe php would be similar?... Code: <MARQUEE> <% sql = "SELECT * FROM Domains"; domains = conn.Execute(sql); while (!domains.EOF) { Response.Write(unescape(domains(0))) domains.MoveNext(); } %> </MARQUEE> i may be wrong though, im no expert database connection not shown..... because i can't be bothered typing it

06-27-2005, 10:42 AM	#3 (permalink)
DropLister Senior Member Join Date: Apr 2005 Location: .ma.us Posts: 1,783 21.95 NP$ (Donate)	thats a start ill alter it to php, b/c I cant us asp on a unix server __________________

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Good Article: An SEO Checklist	Ferman	Search Engines	2	05-28-2005 10:51 AM
Why can't I get clicks	majinbuu1023	Google Adsense	43	04-15-2005 09:24 PM
Basic HTML Tutorial	webgear	Webmaster Tutorials	8	04-02-2005 02:20 PM
cannot find script	sickle	Web Design Discussion	5	04-03-2004 06:36 PM

06-27-2005, 10:50 AM	#4 (permalink)
Wildchild22 NamePros Regular Join Date: Jun 2005 Location: S. Yorkshire, United Kingdom Posts: 310 93.00 NP$ (Donate)	yeah, sorry i couldn't be much more help.... my PHP knowledge is limited

06-27-2005, 12:29 PM	#5 (permalink)
Porte Senior Member Join Date: May 2005 Location: Somewhere on earth! Posts: 3,528 21.30 NP$ (Donate)	I'll assume that you already know how to enter info in a database, and how to construct a mysql database. you can call it very easy: <? $sql = mysql_query("SELECT * FROM dropping_names ORDER BY (optional to you)"); while($row = mysql_fetch_array($sql) { // output here.. } ?> that's it. but, that involves how you want to order the domains, and how many you want to show on one page, you might need a basic navigation system. If you need let me know, I'll show you a tutorial for this which i use already on my coding. Good luck.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)