[PHP-DB] Re: new data detect

2001-07-25 Thread Hugh Bothwell
"Sommai Fongnamthip" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi, > I decide to make real time application (like stock market or online > news). How could I know when new data arrive to table and retrieve them to > display or update in web page? You ca

Re: [PHP-DB] Re: another php/mysql problem

2001-07-25 Thread Hugh Bothwell
Couple of comments: 1. What's with the $artist = "artist"; echo $mytable[$artist]; bit? This really doesn't seem to gain you much. 2. Descriptive variable names are a Good Thing(tm). 3. Prettyprinting " 4. Why are the tables in different databases to begin with? 5. Don't pull any more th

[PHP-DB] Re: Making a new row in HTML tables

2001-07-25 Thread Hugh Bothwell
Umm... 31 entries, 1 x 31... You might be better to choose a standard width and pad the last row with empty cells. "Ian Grant" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi, > > Can anyone help me with this - I have a database of people, that I want to >

[PHP-DB] Re: draw graph

2001-07-25 Thread Hugh Bothwell
"Sommai Fongnamthip" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Dear, > How could I draw graph with gd by using PHP code with custom log scale? How 'bout: function drawLogGraph($arr) { $xoffs = 20; $yoffs = 180; $drawwidth = 160; $drawhei

[PHP-DB] Re: multiple queries in one php statement....

2001-07-19 Thread Hugh Bothwell
"Koutsogiannopoulos Karolos" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello everyone... > > Could someone give me a tip ang tell me if i can insert more than one > queries in a mysql_query() statement?? > > etc $quer=mysql_query(" BEGIN WORK , QUERY 1 ,

[PHP-DB] Re: enum !!

2001-07-16 Thread Hugh Bothwell
"McShen" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > how do i store multiple data in one field? > i have a table like this > > +---+---+--+-+-+---+ > | Field | Type | Null | Key | Default | Extra | > +---

[PHP-DB] Re: PHP calling Javascript

2001-07-13 Thread Hugh Bothwell
"Kevin Johnson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > I was wondering how to call a javascript function within PHP? > Any ideas of solutions. You can't, at least not in the way you seem to mean. PHP runs on the server, JavaScript on the client. P

[PHP-DB] Re: Are PHP user-defined functions recursive?

2001-07-11 Thread Hugh Bothwell
"Ken Sommers" <[EMAIL PROTECTED]> wrote in message 000a01c10a32$a8ec8540$7344500c@zeospantera">news:000a01c10a32$a8ec8540$7344500c@zeospantera... > What is function overloading? Overloading is the ability to define several functions by the same name but with different parameter lists and let th

[PHP-DB] Re: image mapping

2001-07-11 Thread Hugh Bothwell
"Ken Sommers" <[EMAIL PROTECTED]> wrote in message 001301c10994$717b4b80$0343500c@zeospantera">news:001301c10994$717b4b80$0343500c@zeospantera... > Hello, pure HTML server question: > > images like (backgroundimage.jpg) stored on server at: /htdocs/img > > util.showpic.html is stored at : /htdo

[PHP-DB] Re: Images from database

2001-07-10 Thread Hugh Bothwell
> "Randall Barber" <[EMAIL PROTECTED]> wrote >I have seen in several places the following line: > > > > Will this tag work in both IE and Netscape? Yes > What does myScript.php do? Does it find an image and pass the binary data back? Sure, that's one use; another is to dynamically generate an

[PHP-DB] Re: problem with form

2001-07-10 Thread Hugh Bothwell
Try setting form.action and using form.submit() to send it ('edit.php' is not valid javascript). Here: Note that this includes a fall-back: if JavaScript is not suppo

Re: [PHP-DB] Re: Homesite Server Mapping

2001-07-08 Thread Hugh Bothwell
- Original Message - From: "Ken Sommers" <[EMAIL PROTECTED]> To: "PHP DB Mailing List" <[EMAIL PROTECTED]>; "Hugh Bothwell" <[EMAIL PROTECTED]> Sent: Sunday, July 08, 2001 5:30 PM Subject: Re: [PHP-DB] Re: Homesite Server Mapping > T

[PHP-DB] Re: Homesite Server Mapping

2001-07-08 Thread Hugh Bothwell
"Ken Sommers" <[EMAIL PROTECTED]> wrote in message 001001c107e2$b84ad5c0$aa42500c@zeospantera">news:001001c107e2$b84ad5c0$aa42500c@zeospantera... > Has anyone successfully mapped their browser to a Remote Server? > > Please show your: > map from: C:\Program Files\Apache Group\Apache\htdocs\ > Ma

[PHP-DB] Re: A very simple MySQL + PHP error

2001-07-08 Thread Hugh Bothwell
"Brad Lipovsky" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I get the following error: > > $Query = "SELECT * from $TableName WHERE title LIKE "%$title%")"; If you tried 'echo $Query' right here, you wouldn't see anything. Try 'echo "305" % "300";' You

[PHP-DB] Re: how to find biggest value of a field across 2 tables?

2001-07-05 Thread Hugh Bothwell
"Noah Spitzer-Williams" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > i have two tables each with a same field and i would like to find which > table has the bigger value in this field.. > > is there a way to do this with one select statement? > > i've tried things like: > sele

Re: [PHP-DB] Passing XML

2001-06-30 Thread Hugh Bothwell
From: "olinux o" <[EMAIL PROTECTED]> To: "Hugh Bothwell" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, June 29, 2001 10:25 PM Subject: Re: [PHP-DB] Passing XML > Is this what you have in mind? > > $url = 'http://website.com/doc

Re: [PHP-DB] TO_DAYS() equivalent?

2001-06-30 Thread Hugh Bothwell
How about this? define("SECONDS_PER_DAY", 86400); $now = (int) (time() / SECONDS_PER_DAY); Note that this may not match the time you get from your database server, depending on what time zones you're in. ""David W. Banks"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROT

Re: [PHP-DB] most efficient weighting system? URGENT

2001-06-30 Thread Hugh Bothwell
How many rows are you likely to have, and how dynamic are the weights? I think I'd add a "cumulative sum" column to your table, ie idweightcum_weight 11010 25 15 3318 42038 52

Re: [PHP-DB] php/mysql horizontal listing query

2001-06-29 Thread Hugh Bothwell
>""Matt Nigh"" <[EMAIL PROTECTED]> wrote in message >014501c0fe67$945a3400$[EMAIL PROTECTED]">news:014501c0fe67$945a3400$[EMAIL PROTECTED]... >hello knowledgeable people of the php-db list, ;-) flattery will get you everywhere ;-) >I need a section of a record label site with a releases section

Re: [PHP-DB] How do I keep the values of objects when refreshing page?

2001-06-29 Thread Hugh Bothwell
"Hector M Banda" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi all, > > My page is getting the values and the submits itself displaying the > information but the original selection is gone showing the objects with > no info. ... so you have a form which su

Re: [PHP-DB] FW: strange numbers in link

2001-06-29 Thread Hugh Bothwell
<[EMAIL PROTECTED]> wrote in message BB6D932A42D6D211B4AC0090274EBB1D2EEE87@GLOBAL1">news:BB6D932A42D6D211B4AC0090274EBB1D2EEE87@GLOBAL1... > Our website uses mysql/php. Good! ;-) > I found the link written below as a "hard > coded" link and I can't figure out why the programmer would have use

Re: [PHP-DB] Passing XML

2001-06-29 Thread Hugh Bothwell
I'm not sure how you mean; it depends on where the data is coming from. I count three ways you can do this: 1. pass the XML filename (or URL) to the script via GET or POST 2. pass the XML source to the script via POST 3. upload the file via POST and call the script More details on what you're tr

Re: [PHP-DB] Which state and country?

2001-06-29 Thread Hugh Bothwell
Um... you could look at REMOTE_HOST to get their IP address and use that to look up the address of their server. If you assume they won't log in long-distance, that should give you their country and state, and maybe a useful approximation of their city. ""Lisa Elita"" <[EMAIL PROTECTED]> wrote i

Re: [PHP-DB] Executing several PHP scripts simultaneously??

2001-06-29 Thread Hugh Bothwell
Consider using set_time_limit() before each sub-script executes; this will time out on any individual script, but let you extend the limit on the master script. ""Lisa Elita"" <[EMAIL PROTECTED]> wrote in message 004901c0ffd5$90c63680$a6fc2bca@telkomnetnstan">news:004901c0ffd5$90c63680$a6fc2bca@t

Re: [PHP-DB] sql problem

2001-06-26 Thread Hugh Bothwell
""Fai"" <[EMAIL PROTECTED]> wrote in message 9h90l2$1op$[EMAIL PROTECTED]">news:9h90l2$1op$[EMAIL PROTECTED]... > SELECT @A:=SUM(salary) FROM table1 WHERE type=1; > UPDATE table2 SET summmary=@A WHERE type=1; > > What does @A: mean? > > Thank you very much! They're writing the sum to an SQL vari

Re: [PHP-DB] Subtracting times?

2001-06-24 Thread Hugh Bothwell
""Matthew Cothier"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I really need help here. What I am trying to do is the following. Which database are you using? What format is it returning the date and time in (string or integer)? It may be simpler to

Re: [PHP-DB] number of occurences

2001-06-24 Thread Hugh Bothwell
> $number = 123782301247832; > Now, I'd like to check how many times the letter 1 occurs in there... Try this: $number = "123782301247832"; $res = count_chars($number, 1); $outstr = ""; foreach($res as $key => $val) { if ($outstr != "") $outstr .= ", ";

Re: [PHP-DB] One quick favor!!!!!!

2001-06-19 Thread Hugh Bothwell
Each '%20' is a URL-encoded space character. In other words, the string you are getting back from your database query looks like 'fruit '. I suspect you coded the field as a fixed-length string. The best long-term fix is to change the field type to a variable-length string, so that 'fr

<    1   2