is
select MAX()
what you are looking for? I know it works on numeric columns, I'm not sure
if it works on non-numbers, you'd have to look it up in a SQL Tutorial
somewhere.
Good luck!
-Natalie
-Original Message-
From: César Aracena [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12
I totally didn't even see that section of code. I am sorry I wrote back
like you were an idiot! I think we know who the real idiot is today... :-)
Sorry again!
-Natalie
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 1:53 PM
To: Jas; [EM
The quick answer is that that is what it's supposed to return... that's all
the result is. A nicer, longer answer is to give you some of my code so you
can see one way that you actually get the data out (I use sybase_fetch_row,
but you can also use _fetch_array which returns an associated array
You could probably use:
$start = time();
//run query
$end = time();
and then compare start and end. I don't know how time() formats the time,
but that's probably on PHP.net.
-Natalie
-Original Message-
From: Natividad Castro [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 11, 2002 1:2
>From what I've seen on the PHP.net site, it doesn't look like people use the
@ in @mysql_query, and I know that I don't use it for sybase_query. Where
did it come from?
Assuming that's not the problem, I'd try printing out everything. Right
after your while, print $row - it should say "array",
OK, then. Here's an example. I understand that this is confusing (it took
me quite some time to get my first db example working correctly), but there
are normally examples on PHP.net if you look up the functions that Jason
referred you to. If those didn't help I don't know how much help mine wi
I couldn't find a way to exclude someone - even in the rules it didn't look
like it had anything like that. It doesn't even look like you can skip it
if you delete.
You might want to try to the MS website - they have a pretty thorough FAQ
and it's much better than the help that comes up with the
I could be missing something, but it looks like you are using the result of
the mysql_query as the actual result. It actually returns some weird
identifier. To access the real info you'd have to use something like
mysql_fetch_array to get it.
Check out this and see if it helps:
http://www.php.
This should get you started.
http://www.php.net/manual/en/function.split.php
There are other ones too, like explode.
-Natalie
-Original Message-
From: Prodoc [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 1:00 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Character check in string
You're welcome. It's a Monday - no DUH necessary :-)
-Original Message-
From: Jennifer Downey [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 2:33 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Not getting results if 0
Wow, the only thing I can say for myself is DUH as I slap
Are you looking it up in a database? If so you'd want to do something like
where price > 0. Then it wouldn't return those results.
-Natalie
-Original Message-
From: Jennifer Downey [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 2:01 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB]
Here's an example for how to select the sum of a column in SQL. Maybe that
will help.
-Natalie
http://www.devguru.com/Technologies/jetsql/quickref/sum.html
> -Original Message-
> From: Leif K-Brooks [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, March 08, 2002 2:17 PM
> To: [EMAIL PROTECTE
In theory, if your writers are using a word processor such as Word you could
try just saving as HTML and seeing if that works. I doubt they'd appreciate
it if you asked them to write in FrontPage, but that would give you what you
need too.
If these ideas don't work you may want to browse other m
Could you use PDFs?
-Natalie
> -Original Message-
> From: Monty [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, March 07, 2002 2:31 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Best way to store/retrieve content??
>
> I'm writing some content management scripts for an online magazin
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Dynamic Drop Down Box
>
> On 3/5/02 3:34 PM, "Leotta, Natalie (NCI/IMS)" <[EMAIL PROTECTED]>
> wrote:
>
> > This can be done with JavaScript - I don't know if you can do it in PHP.
>
> ...unl
This can be done with JavaScript - I don't know if you can do it in PHP. I
had a site where I wanted to let people compare data for two states so based
on the first state that was chosen I populated the compare with the other
states. If you want me to send you my code I can. It uses another fil
I'd try building it piece by piece if you do have too many combinations -
(I'm not promising efficiency, but I do something similar to this in one of
my programs and it works).
Have vars for each type of data:
$firstName = "";
$lastName = ""; etc.
Then you can set each one based on the selectio
Try doing a select distinct on that field and then loop through the results,
adding each one to your drop-down box as you go.
I don't have the exact code anymore because we stopped doing it that way,
but that's the basic idea of how to go about it.
I hope it helps!
-Natalie
> -Original Mes
Jas,
I've run into the same kind of problem with the site I'm doing for work.
My first solution was to use the query string to pass contents of an array
(array[0]&array[1]...) but I got to the point where I was passing too much
information and it wouldn't work. Now I use hidden data in my for
Does anyone know how to put a bitmap into an Image? I need to have a filled
circle in a graph. This shouldn't be a problem except we have an older
version of GD (and our network guy is overworked so it would take a few
weeks to get a newer version installed) and the graph has gridlines. If I
ma
Could you make it a hidden value in a form?
> -Original Message-
> From: Renaldo De Silva [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, February 08, 2002 3:15 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] multiple query string
>
> That's the same as cookies, isn't it you have to
ly book, so thanks for the warning!
-Natalie
> -Original Message-
> From: DL Neil [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, January 15, 2002 5:34 PM
> To: Leotta, Natalie (NCI/IMS); 'Andy'; [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] How can recommend a book fo
Any O'Reilly book is always a good choice. O'Reilly is the publisher - they
do the "Nutshell" books and a bunch of others. They are also the books with
animals on them, if that helps :-)
-Natalie
> -Original Message-
> From: Andy [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, January 15, 20
I use FGDesigner.com. They have proven to be quite reliable and have a wide
range of plans available based on what you would need. You can check out
the website. My husband and I have been hosting our site through them for a
couple of years and never had any problems. I also know that they hav
IL PROTECTED]]
> Sent: Friday, January 04, 2002 6:53 PM
> To: Leotta, Natalie (NCI/IMS)
> Cc: 'Kelvin'; [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] How to insert to DB from txt??? Please help
>
> egrep_split? But then, there's the learning curve for grep...
There are a few ways to split up text based on a delimiter. I recommend you
look at split and explode on the PHP.net site and see what seems to be best
for your situation. Once you go to one of them they link you to other
functions that do similar things. I believe explode is faster but I can't
In my database (Sybase) that won't work. You have to use
not like 'NULL'
or it gives an error about not using text in a where clause unless you use
like. Weird, but it will work with the not like 'NULL'.
-Natalie
> -Original Message-
> From: Jonathan Hilgeman [SMTP:[EMAIL PROTECTED
Sure! If you need more help let me know - I can send you some code.
-Natalie
> -Original Message-
> From: Leotta, Natalie (NCI/IMS)
> Sent: Friday, December 28, 2001 11:57 AM
> To: 'Mihail Bota'; Bogdan Stancescu
> Cc: Karthikeyan; [EMAIL PROTECTED]
&g
You could make hidden vars in your HTML page (in a form that submits to your
PHP), alter their values in the JS, and then when you submit to the PHP it
will have those. Then you can use $HTTP_POST_VARS to access the variables
from inside the PHP. There might be an easier way, but I know this way
Have you tried printing out $pet_picture to make sure that it really equals
"" when there's no pet?
-Natalie
> -Original Message-
> From: Jay Fitzgerald [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, December 18, 2001 3:09 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
> [EMAIL PROTECTED]
>
I don't understand the second part of your question but for the first part
you can use a select distinct in your SQL statement and then loop through
the result to put things into a drop down box. I just printed the HTML with
the var name in there and it worked well.
Good luck!
-Natalie
> -
I'm not sure if other people have lots of db problems with PHP but we had
enough that we switched our website around so it has a perl page that
creates the HTML page, queries the db, and sends the data into PHP to have
it draw a graph based on the data. It's more complicated, but perl never
fails
I'm working on a project right now where we call PHP from within an HTML
page, send it vars using a POST method, and then use that to draw a graph.
We're drawing bar graphs now but one of my coworkers did a line graph. You
call the PHP as an tag and have PHP return a .png. We used the
SAMS Teac
I'm new to PHP but one thing I think might be happening is that maybe the
changes aren't being made to a "global" (I'm a Java programmer) $sql so they
aren't being kept. Does it actually break or is it not appending the
additional string? I'd try printing out the $sql and see what you're
getting
34 matches
Mail list logo