Search found 23 matches

by pachox
Fri Aug 22, 2003 3:38 pm
Forum: Databases
Topic: select form data
Replies: 10
Views: 1593

solved like this: // Create a new SELECT Query with the ORDER BY clause and without the COUNT(*) $SQL="SELECT IDMedico, cognome, nome, email, telefono, regione, specialita, descrizione, picfile FROM medici WHERE cognome LIKE '%".$_POST['cognome']."%' and specialita LIKE '%".$_POS...
by pachox
Fri Aug 22, 2003 2:37 pm
Forum: Databases
Topic: select form data
Replies: 10
Views: 1593

ericsodt wrote:You also have to watch for when the user only enters in one value cause the statement ends in 'or' so your where clause will end with or and that wil throw back an error at you

opppsss.

lost in space now....

code to explain pls
by pachox
Fri Aug 22, 2003 2:03 pm
Forum: Databases
Topic: select form data
Replies: 10
Views: 1593

no more output at all. here the code <?php $DB_Host="localhost"; $DB_User="root"; $DB_Pass=""; $Per_Page=3; $db_name = "DBMedici"; $table_name = "medici"; $connect = @mysql_connect($DB_Host, $DB_User, $DB_Pass) or die("connect che????"); $s...
by pachox
Fri Aug 22, 2003 1:17 pm
Forum: Databases
Topic: select form data
Replies: 10
Views: 1593

yes i understand what u mean.

can u give me a code hint, plz?

pacho
by pachox
Fri Aug 22, 2003 1:02 pm
Forum: Databases
Topic: select form data
Replies: 10
Views: 1593

there are not null values in db.

the problem is that the query works only with the name field.
if i insert email or address the result is the whole db, if i insert a name the ouput is correct and the script make a search by the name value
by pachox
Fri Aug 22, 2003 12:46 pm
Forum: Databases
Topic: select form data
Replies: 10
Views: 1593

select form data

i have a form like this: <div id="form2"><form method="post" action="consulenti.php"> name: <input type="text" name="cognome"> email: <input type="text" name="specialita"> address: <input type="text" name="regione&q...
by pachox
Wed Aug 20, 2003 2:55 am
Forum: Databases
Topic: display data from db
Replies: 1
Views: 345

display data from db

i do a select to get some datas from mysql. say on the web page i print this: name address email pic ok now the point is in the db there is another field i want to be displayed only on mouseover. so when a user does mouseover (or click) one of those fields(name, address,...) in the bottom of the pag...
by pachox
Tue Aug 19, 2003 7:12 pm
Forum: Databases
Topic: url on the fly
Replies: 1
Views: 434

solved: <td><a name="newspost_nr_1"></a><a href="http://localhost/spazioweb/specialita/richiesto.php?id=9">Dal mare un aiuto per il cuore malato</a></td></tr> select id, titolo, testo, argomenti from $table_name where id like '$_GET[id]%' "; while ($riga = mysql_fetch_array(...
by pachox
Tue Aug 19, 2003 4:47 pm
Forum: Databases
Topic: url on the fly
Replies: 1
Views: 434

url on the fly

i know how to get datas from a form and use them. i mean when u want to interact with users u can code a form where u get data (name, birth...) and u can then use that. differently i cannot figure it out how i can use mouse click to get url. i try to explain myself: i want to make links (href) getti...
by pachox
Tue Aug 19, 2003 4:15 pm
Forum: Databases
Topic: links
Replies: 4
Views: 577

twigletmac wrote:yes

Mac
and would u like to give me a little hint???

pacho
by pachox
Tue Aug 19, 2003 3:47 pm
Forum: Databases
Topic: links
Replies: 4
Views: 577

article 1 article 2 article 3 figure this as my web page. there are hundreds of records, anyone should be linked linked to it's own sub-category. these records are printed from a db. so my question is: is it possible to write php so that when you click automatically is done the select and displayed ...
by pachox
Tue Aug 19, 2003 11:43 am
Forum: Databases
Topic: links
Replies: 4
Views: 577

links

aaaaaaaaa
bbbbbbbbb
cccccccccccc

this is my page. there are hundreds of records, anyone should be linked linked to it's own sub-category.

these records are in a db.

so my question is:

is it possible to write php so that when u click automatically id done the select and displayed the right article?
by pachox
Tue Aug 19, 2003 3:47 am
Forum: PHP - Code
Topic: auto generated pages
Replies: 1
Views: 273

auto generated pages

i have a db lthat i want to publish. it''s full of articles and i want it to work this way: there are ten categories (sex, health,....) once you click one of this category you go to a page where there are some articles (about sex, about health,...). at this point is my problem. i'd like to find a wa...
by pachox
Mon Aug 18, 2003 5:42 pm
Forum: Databases
Topic: url from db
Replies: 1
Views: 423

the prob is: i get all data from my db, this is ok. this is what i get: specialita Allergologia Andrologia Angiologia Allergologia .... now in the code i wrote: echo "<td><a href='$url'>" .$riga['specialita']."</a></td>"; $url .= $riga['url']; like this any field has the same url...
by pachox
Mon Aug 18, 2003 4:12 pm
Forum: Databases
Topic: url from db
Replies: 1
Views: 423

url from db

the code: <?php $db_name = "DBMedici"; $table_name = "specialita"; $connect = @mysql_connect("localhost", "root", "") or die("connect che????"); $select_db = @mysql_select_db($db_name, $connect) or die("cannot select db"); $sql = ...