djavet
-
Posts
8 -
Joined
-
Last visited
Never
Posts posted by djavet
-
-
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
-
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
-
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:
Notice: Undefined index: organisation in g:\elce\www.website.ch\cms\address\letters.php on line 18Any idea where I'm wrong?
Regards, Dom
-
-
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
-
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
Popular Tags script?
in PHP Coding Help
Posted
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