Hi
I would like to put a list of ids in an array
and loop to select data from a table using
"IN" in the where clause.
I am not having any success getting this to work.
Any suggestions?
Note:I am using Mysql database, apache, linux/Windows
[php]
<?
//array with list of friends to display
$friend = array('1','2',' 3','4');...
assgar
Last Activity: May 26 '08, 01:37 AM
Joined: Aug 4 '06
Location:
-
Select where clause with "IN"
-
Hi
I hope this better explains what I am trying to accomplish.
The events are recurring every month, but not recurring at the same time or on the same day of the week.
Thank -
Inserting alternating event/appointment type using time and date range
Hi
I need help.
I know what I want to accomplish, but I do not know how to do it.
WHAT I NEED HELP ACCOMPLISHING:
How to do I insert data into a table for a date range of two or more months,
where every second or third week should be able to have different events/appointments.
POSSIBLE APPROACH:
I would like to choose a 7 day cycle/template,... -
Hi
The number of inserted events for each day is 148 there should only be a maximum of 24 inserts per
day. There should not be inserts on Sunday or the following week.
pk date time event type
Monday
1 2007-01-01 09:00:00 201 This is OK
2 2007-01-01 09:15:00 201
3 2007-01-01 09:30:00 ...Leave a comment:
-
looping to insert event types into schedule
Hi
I am having problem with my loping.
I don't know if I have chosen the correct approach.
GOAL:
I need to insert into a table event types for a specific date range.
The calendar the event type is displayed on is divided into
15 minutes time intervals
A group consist of days of the week, each day consist of segments of
time blocks for different events:
... -
Solution
Hello
Thanks for the info its was the best way to make this work.
This is the solution, this final code allows you to double book appointments.
[php]
<?
/**---------------------------appointment interval--------------------------**/
SWITCH($time_in terval)
{
case 10:
$add_time = 600; //10 min...Leave a comment:
-
Thanks for the info on the select statement I changed it. This though is not a solution to matching the schedule time eg 07:00 AM to the client name with an appointment for 07:00AM....Leave a comment:
-
I forgot to add the end of the table structure
[php]
<?
echo"</div>\n";
echo "</div>\n";
echo "</td>\n";
echo "</tr>\n";
echo "</table>\n";
echo "</table>\n";
?>
[/php]Leave a comment:
-
Retrieving and comparing data from arrays
Hi
I am php newbie and I don't know if I am approaching this properly.
I need to creat a scheduler that list the appointment time on the left
and client for a specific appointment time on the left.
NOTE: The appointments are stored in a Mysql database
This is what I am trying to acomplish:
Time | client Name
-------------------------------------------
... -
[My problem with the scrolling is solved. It was looking blurred because of a duplicate function displaying the same info.
[php]
Eg.
<?
Function display()
{
Return $multiple_array _values;
}
List() = display();//NOTE: this was creating the duplicate
?>
[/php]
Changed to
[php]
<?
Function display()
{
Return $multiple_array _values;...Leave a comment:
-
Scrolling display is blurred
Hi
Multiple rows of dynamically created data is retrived from the database and displayed properly.
When I get 50 rows displayed scrolling is necessary.
The problem is when I scroll to see the items at the bottom of the list the rows get blurred (jumbled).
To be specific at the top and bottom rows of the list are displayed properly but in the middle the rows get blurred.
Can you you see... -
Store multiple selection from pagination info into single array
Hi
I was using a schroll bar to display multiple rows of dynamically created from database records.
The scrolling was not displaying the data properly so I have decided to use pagination.
The problem I am having is,
if I select one item on page #1 and another on page #5
only the last item selected on page #5 is stored in the array.
How can I store selections from multiple pages into... -
Problem Solved.
Using a for loop to incement the array index syncronizes the array indexes.
I think using a two-dimentional array would be better but I don't how to do that yet.
This is the code that resolved the problem.
[html]
<html>
<head></head>
<body>
<!-----------------------form processor---------------------------->...Leave a comment:
-
Looping through arrays
Hello
I have changed the process code abit so it receives
the data from the form and ensures the data in array format.
This has eliminated my previous error.
The problem I am experiencing is the looping is not
displaying the all contents of the arrays.
Do you have any idea what the problem is and how to fix the problem?
[html]
<html>... -
This problem has been solved
Thanks...Leave a comment:
-
Variable passed to each() is not an array or object
I am having problems getting the user selected form info to inserted into the mysql database.
I am also rec eving an error:
Warning: Variable passed to each() is not an array or object in
D:\web_server\w ebroot\common_l ist_process.php on line
1) I can display the contents of the $op array (see below)
2) Am I using the correct loop to unpact the array for inserting into the
... -
Processing array values
Hi
I need help solving a porblem.
I have a form that displays a checkbox, service code, description
and dropdown with fees on each row.
The fee_money and unit array only returns a selected value from the
first item (checkbox).
When I used the line below in the processor, it displayed the
correct selection.
[php]
echo '<pre>',print_ r... -
Hi
I have been using this bit of code to resolve the problem for over
a week and have not received the error message.
This can be considered resolved.
[php]
/*** arrays passed from the form with selected service variables ***/
$code_id = $_POST['fee_choice']; //array of code_id primary key
$fee_unit = $_POST['fee_unit'];//array with the number of units...Leave a comment:
-
Hi Ron
Thanks for replaying.
I think this is what you are looking for. The names were messed up in my
example. I appologize for the length.
This is the function that display the information on the form.
[php]
<?php
function display($servic es, $special, $fee_master_tab le)
{
if ($services == "A")
{
$data...Leave a comment:
-
I am very sorry but I accidentally deleted your reply. But I have seen it and, maybe I am missing some important part, but I cannot see anywhere on your to-be-submitted form the 2 fields that you extract from the POST array, i.e.[php]$fee_unit = $_POST['fee_unit'];//array with the number of units
$fee_money = $_POST['fee_money'];//array selected fee
[/php]
Ronald :cool:Leave a comment:
No activity results to display
Leave a comment: