[PHP] Re: Mysql_num_rows
Hi Frank,
I'm not exactly sure what's up with this, I've definitely used something
similar before without any problems. However, maybe you can work around it
by switching the logic...
if($num)
echo blah, blah, blah;
else
echo There are no events scheduled today!;
Wish I had a better suggestion.. Good luck!
Corey Eiseman
Infinite Orange Incorporated
http://infiniteorange.com/
Frank Miller [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Thanks to everyone that helped me with my last problem I've run into
another problem and was wondering if someone here could offer any help or
suggestions. The project I'm working on is an event calender. It does
several things but the problem I've run into is when I click a date on the
calendar if there are no events for that day I want to print a message on
the web page saying as much. I've read the documentaion that said if I'm
using a select statement to use mysql_num_rows and that it returns an
integer. Here is a snippet of my code
$query = SELECT *,TIME_FORMAT(eventtime, '%l:%i %p')AS eventtime,
DATE_FORMAT(dateofevent,'%M %e, %Y') AS fdateofevent FROM tamutevents
where refid=$refid;
$result = mysql_query($query,$connection) or die(Error in Query);
$num = mysql_num_rows($result);
Next I say if ($num == 0)
{
echo There are no events scheduled today!;
}
else
{
echo blah, blah, blah;
}
The problem is if there are no records that match the select then it
always
goes to the else part. I've tried printing the value of $num and it
works
if there is something scheduled but when there is nothing scheduled $num
shows nothing on the screen.
I'm using Mysql 3.23.38 and php 4.06 on a windows test machine but it
works
the same on php 4.06 and Mysql 3.23.46 on my Linux server.
Has anyone else run into this and if so can you tell me what to do about
it.
Thanks in advance - Frank
Frank Miller
Computer Specialist and Webmaster
Technology and Distance Education
Texas AM University-Texarkana
2600 North Robison Rd
Texarkana, Texas 75501
Phone: 903-223-3156
Fax: 903-223-3139
Office: 165
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Novice Question
yeah, it definitely works with text fields too. You can also do something
like:
input type=text name=poly[?=$i;?]
where $i will then be the key of the resulting array $poly. it doesn't seem
necessary in this case, since the numbers will probably be consecutive, but
if you wanted an associative array for some reason this can be useful.
Corey Eiseman
Infinite Orange Incorporated
http://infiniteorange.com/
Rick Emery [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
name each field with an array name. I know the following works with
checkboxes; try it with text fields:
input type=text name=poly[] value=
input type=text name=poly[] value=
input type=text name=poly[] value=
input type=text name=poly[] value=
then, in your php script called from the form, you'll access the
polynomials
using poly[0], poly[1], poly[2], poly[3], etc.
You know how many fields were created, because you created them; so you
could pass the number of created fields in a HIDDEN value ($NoPols) from
the
form. As you examine each field, you'll determine if it's empty or not.
for( $idx=0; $idx$NoPols; $idx++ )
{
if( strcmp( , $poly[$idx] )
{
... do something with field ...
}
}
-Original Message-
From: brendan conroy [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 3:27 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP] Novice Question
I wish to create multiple input fields on a single form, I think(sorry
..could you advise?)
I'd like a page that has multiple input fields, but I dont know how to
access the individual inputs.
Say the user wanted to enter three inputs(polynommials in this case)
so they get a page with three input boxes,
Enter polynommial here:
Enter polynommial here:
Enter polynommial here:
How would I dynammicaly create the input boxes and name the inputs. Thanks
for your time on this, I sorry I didnt explain this clearer in the first
place,
Thanks,
Bren
From: Rick Emery [EMAIL PROTECTED]
To: 'brendan conroy' [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: RE: [PHP] Novice Question
Date: Mon, 18 Feb 2002 14:54:09 -0600
Do you wish to create multiple forms or multiple input fields on a single
form?
-Original Message-
From: brendan conroy [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 2:48 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Novice Question
Hi thanks for reading this.
This problem is difficult to get across, this is what happens:
A) On a html page I ask users how many inputs they wish to enter, say 3.
The
3 is stored as a variable called $NoPols.
B) Then in the code below, a loop creates $NoPols (3) forms to take the
users inputs.
The problem is that the same name($Yourpol) is used in each of the
created
forms, and i dont know how to get around this problem.
I would like to know if it is possible to create a page which has a
number
of forms, the number of which is decided by the user(on a start page), so
the user can submit as many inputs as they want from one page.
Sorry if I've wasted your time,
I'd be very grateful for any assisstance with this problem,
thanks a million,
Brendan
html
head
titlenpage.php/title
/head
body bgcolor=#FF text=#00
p
?php $NoPols; ?
?php
for($i=1 ;$i= $NoPols ; $i++)
{
?
form action=ppage.php method=post
enter polynomial ? echo $i;? here:input type=text name=Yourpol
br
/br
?
}
?
input type=submit name=submit value=Submit Pols!
/body
/html
_
Send and receive Hotmail on your mobile device: http://mobile.msn.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
_
Join the world's largest e-mail service with MSN Hotmail.
http://www.hotmail.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP/Flash interaction
I just ran across this tutorial yesterday... Using PHP and MySQL with Flash http://www.phpbuilder.com/columns/hill20011214.php3 Haven't had time to do more than skim it so i can't really vouch for its usefulness, but it seems like a good start. also flash-db.com has some forums that you may find useful if you have any specific questions.. http://www.flash-db.com/Board/index.php good luck! corey.eiseman infinite orange incorporated http://infiniteorange.com/ Luke Crouch [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I guess what I'm looking for specifically is a site for Flash/PHP developers. I don't know that any exist...but I'm looking for more of What kind of design approach to use...? then a technical answer... -L Mike Krisher [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... what do you mean by optimization? do you mean loading info(name/value pairs) from PHP to Flash and vice versa. I don't know if there is a way to optimize it at all, GET and POST are the same things with Flash as they are with HTML and the like. Let me know if you're looking for something specific. __ Mike Krisher Director of Technology hyperQUAKE 312 West 4th Street Cincinnati, OH 45202 Tel: 513.563.6555 Cel: 513.254.7821 AOLIM: twopeoplecom ICQ: 83891383 MSN: [EMAIL PROTECTED] -- 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]
