djavet
-
Posts
8 -
Joined
-
Last visited
Never
djavet's Achievements
Newbie (1/5)
0
Reputation
-
Hello I'm seeking how to make a script like this one: http://www.webcheatsheet.com/tags/ It's a Popular Tags scripts. I've a DB with a keywords tablem but don't know how manage the keywords size. Any idea? Thx for your help and idea. Regards, Dominique
-
Hello I wish to know if when I use the recordsert wizard in Dreamweaver (for a search into DB), my application is protected against SQL Injection? Or must I protect by myself the code? A lot of ths for your answer. Regards, Dominique
-
Display initials navigation menu with links or not
djavet replied to djavet's topic in Editor Help (PhpStorm, VS Code, etc)
I found! I must change my query to: SELECT DISTINCT UPPER(LEFT(organisation,1)) AS organisation FROM contacts and then change all $links to $alphabet. It's working now. Thx a lot. REgards, DOm -
Display initials navigation menu with links or not
djavet replied to djavet's topic in Editor Help (PhpStorm, VS Code, etc)
Hello I try you code in this way: <?php require_once('../../Connections/connect.php'); ?> <?php mysql_select_db($database_connect, $connect); $query_rsInitials = "SELECT DISTINCT UPPER(LEFT(organisation,1)) FROM contacts ORDER BY organisation ASC"; $rsInitials = mysql_query($query_rsInitials, $connect) or die(mysql_error()); $row_rsInitials = mysql_fetch_assoc($rsInitials); $totalRows_rsInitials = mysql_num_rows($rsInitials); ?> <html> <head> <title>Untitled Document</title> </head> <body> <?php $alphabet=('A B C D E F G H I J K L M N O P Q R S T U V W X Y Z'); while ($r=mysql_fetch_array($rsInitials)) { $initial=$r['organisation']; $links=str_replace("$initial","<a href=\"$initial.php\">$initial</a>",$alphabet); } echo("$links"); ?> </body> </html> <?php mysql_free_result($rsInitials); ?> And I receive for every letter the error: Any idea where I'm wrong? Regards, Dom -
Display initials navigation menu with links or not
djavet replied to djavet's topic in Editor Help (PhpStorm, VS Code, etc)
I see! I'n only a field "Organisation" wich I must extract the first letter (don know how, but I will find!). Thx, Dom -
Display initials navigation menu with links or not
djavet replied to djavet's topic in Editor Help (PhpStorm, VS Code, etc)
Just a little question: on "select distinct(initial) FROM table" is initial a DB field name or a funciton? I use Mysql and not Coldfusion. Regards, Dom -
Display initials navigation menu with links or not
djavet replied to djavet's topic in Editor Help (PhpStorm, VS Code, etc)
Hello Thx I will try this. I wil give feedback. Regards, DOm -
Hello I wich to make a address book with a initials navigation with link on. No problem until now, it's working perfectly (php + mysql wit Dreamweaver MX2004). Now I wisch to show in my initals naviagtion menu only links where I've entries regarding my address book name field. Per exemple: A B C D E F G H I J K etc... and i've only entrie on C and J, i wish on C and J a link. Other not. How it is possible to do that? A lot of thx for your help and time. Regards, Dom