ns";
>
>maybe it needs to be on one line???
>
>
>-Original Message-
>From: Rick Emery [mailto:[EMAIL PROTECTED]]
>Sent: Friday, January 11, 2002 8:39 AM
>To: 'Erik Price'; PHP
>Subject: RE: [PHP] does this work?
>
>
>Show all your cod
ECTED]>; "PHP" <[EMAIL PROTECTED]>
Sent: 10 January 2002 22:15
Subject: Re: [PHP] does this work?
> But as I was writing before, what I'm really trying to do with this
> isn't just echo the COUNT of records in a table.
>
> What do I need to separate
At 4:28 PM -0500 1/10/02, Erik Price wrote:
>
>PS: what I am -really- trying to do is dynamically fill in a
> listbox with that correspond to all of the
>records in a given table. Like so:
>
>
>
> foreach ($record_id_and_record_name_pair_pulled_from_mysql_query) {
>
and it would be like using the statement $a = $a;
very very useless!
bvr.
On Thu, 10 Jan 2002 15:39:27 -0600, Rick Emery wrote:
>
>quotes are not needed
>
>
>>
>>mysql_query("$tempsql", $db);
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
On Thursday, January 10, 2002, at 05:16 PM, Martin Towell wrote:
> is this valid in PHP?? (haven't tried it myself yet...)
>
> $tempsql = "SELECT COUNT(*) AS count
> FROM divisions";
>
> maybe it needs to be on one line???
It turns out that my problem was a typo. I apolo
-1362 X289
[EMAIL PROTECTED]
- Original Message -
From: "Erik Price" <[EMAIL PROTECTED]>
To: "Kevin Stone" <[EMAIL PROTECTED]>
Cc: "PHP (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursday, January 10, 2002 4:43 PM
Subject: Re: [PHP] does this work
But as I was writing before, what I'm really trying to do with this
isn't just echo the COUNT of records in a table.
What do I need to separate the array "$temprow" into pieces so that I
can get at the data:
$tempsql = "SELECT divisions.div_name, divisions.div_id
FROM divisions";
39 AM
To: 'Erik Price'; PHP
Subject: RE: [PHP] does this work?
Show all your code. Did you open a connection to the MYSQL server? If so,
show the code.
-Original Message-
From: Erik Price [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 3:29 PM
To: PHP
Subject: [PHP] d
you have a and $tempsql. did you remove
this for the purose of this posting or is this what's causing the problem??
"Rick Emery" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Show all your code. Did you open a connection to the MYSQL server? If
so,
> sh
Wait, my bad. Typo... all my fault.
I feel like an ass.
Erik
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
On Thursday, January 10, 2002, at 04:39 PM, Rick Emery wrote:
> Show all your code. Did you open a connection to the MYSQL server? If
> so,
> show the code.
>
Okay, but I changed some personal info (that I know is definitely
correct):
Array Test
$tempsql = "SELECT COUNT(*)
quotes are not needed
-Original Message-
From: Kevin Stone [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 3:26 AM
To: Erik Price; PHP (E-mail)
Subject: Re: [PHP] does this work?
Hmm I believe that the mysql_query() function requires quotes around the
query statement even it
Show all your code. Did you open a connection to the MYSQL server? If so,
show the code.
What is the exact error that you get?
-Original Message-
From: Erik Price [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 3:29 PM
To: PHP
Subject: [PHP] does this work?
It seems that
Show all your code. Did you open a connection to the MYSQL server? If so,
show the code.
-Original Message-
From: Erik Price [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 3:29 PM
To: PHP
Subject: [PHP] does this work?
It seems that I have a "parse error" somewhere in the
I tried that... I get the same error (same line and everything).
As a side note, I haven't ever had to quote the first argument in
mysql_query() before...
This is quite a conundrum, eh?
Erik
On Friday, January 11, 2002, at 04:25 AM, Kevin Stone wrote:
> Hmm I believe that the mysql_query()
what eact parse error you are getting ? and what is that line ?
Is it giving an error like undefined variable $temprow["count"];
or some thing like that ?
You may try to change the mysql_fetch_row line to the following
$temprow = mysql_fetch_array($tempresult, MYSQL_ASSOC);
- Original Me
Hmm I believe that the mysql_query() function requires quotes around the
query statement even it it is being passed as a variable..
mysql_query("$tempsql", $db);
-Kevin
> It seems that I have a "parse error" somewhere in the following code
> (since that's the only code in my script, it's a test
17 matches
Mail list logo