Re: New to MySQL/PHP with Rank-Amateur Questions

[dunk fordyce]

1) I have administrator rights on the G3 PowerBook on which I'm doing 
this learning. But that's not the same as MySQL recognizing me with 
administrator acces, is it? How can I make MySQL give me administrator 
access, so I can have permission to issue CREATE [and ALL other] 
commands. As it is now, when I try to create a table from the Terminal 
window--and I've decided I DO want to be able to do this in the Terminal 
also, not just thru a GUI--an error message appears, saying that access 
is denied.

you need to be root
something like:

mysql -u root



2) If I create a table in phpMyAdmin, how do I plant it in, say, 
Dreamweaver--or, really, code it into the HTML Dreamweaver creates--so 
the table can be accessed, as part of a web page, from a browser?

you need to write some php or perl to get the data from mysql - ive no
idea about doing this in dreamweaver - do it by hand! ;)


3) I got to the end of November 2002 Macworld magazine's Serve It Up 
article, to the sidebar A Jump Start. I downloaded MacUser's .sit file...

Mac? whats that..
ive never even heard of a .sit file


--

---
===
--- :::   :::  :::   :::   :::===   :::===
--- :::  ===  :::  ::   ===  ::   ===  ===  ::: === ===
--- ===  ===  ===   =   === === ===
--- ===  ===  ===   ===   ===  ===  === ===
--- ===   ===      ==   === ===
www.dunkfordyce.co.uk==




-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: select a range

[dunk fordyce]

if your using numbers , which i guess you are, you do not need to use LIKE.

$query=SELECT * FROM inner-multipli
 WHERE
 cod_in =$cod_int1
 AND
 cod_int =$cod_int2;


bruno peracchio wrote:

Hi
I'm newbie

I have to find from xvalue to yvalue; I have written:
$query=SELECT * FROM inner-multipli
WHERE cod_in
LIKE ='%$cod_int1%'
AND cod_int
LIKE ='%$cod_int2'=;
This not work; how can I do?

Thanks in advance

bruper




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





--

---
===
--- :::   :::  :::   :::   :::===   :::===
--- :::  ===  :::  ::   ===  ::   ===  ===  ::: === ===
--- ===  ===  ===   =   === === ===
--- ===  ===  ===   ===   ===  ===  === ===
--- ===   ===      ==   === ===
www.dunkfordyce.co.uk==



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Notice: Undefined index:

[dunk fordyce]

dont forget mysql_fetch_object()

then you will have $line-lastname;

Maureen Roihl wrote:

That looks like a PHP problem to me. Have you tried mysql_fetch_assoc()? I
believe mysql_fetch_row() gets you an array with a numeric index (in which
case lastname would be in $line[0]). 


Notice: Undefined index: lastname in E:\IIS Webs\index.php on line 29

?

PRINT HTML;
PRINT HEAD;
PRINT TITLEADDRESSES/title;

PRINT /HEAD;

PRINT BODY BGCOLOR=white TEXT=#00 LINK=#FF VLINK=#66
aLINK=#FF;

   mysql_pconnect(127.0.0.1:3308, user, pass) or
   die(could not connect);
   mysql_select_db(address);

   $query = SELECT lastname, firstname, city FROM data;
   $result = mysql_query ($query);

   while ($line = mysql_fetch_row($result)) {

   echo BR.$line['lastname'];
   echo BR.$line['firstname'];
   echo BR.$line['city'].BR;

}

?





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





--

---
===
--- :::   :::  :::   :::   :::===   :::===
--- :::  ===  :::  ::   ===  ::   ===  ===  ::: === ===
--- ===  ===  ===   =   === === ===
--- ===  ===  ===   ===   ===  ===  === ===
--- ===   ===      ==   === ===
www.dunkfordyce.co.uk==



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php