I have successfully linked 2 dropdown lists, but then I got greedy and wanted to provide the same information to further dropdown boxes.
What I am trying to do is to select a client and then offer daily shifts dependent on the client selected.
I can only still get the first box (Monday) to subsequently open. Can you see what I am doing wrong and possible come up with a solution.
Code: [php]
// Starting of first drop downlist...
bobf
Last Activity: Mar 14 '08, 11:39 AM
Joined: Feb 27 '08
Location:
-
Problem with second dropdown list
-
Resolved
Sorry Guys it was under my nose
[code=php]
if ($result) {
if ($frow = mysql_fetch_row ($result)) {
$email = $frow[0];
$first_name = $frow[1];
$last_name = $frow[2];
etc.....
[/code]
I think it is asking for help that gets my brain in gear!! -
Session data not passing to the next page
I hope it's OK to tag my question on to the end of your response?
I am struggling to carry variables through to the next page using sessions. I have the following:-
[code=php]
$result = mysql_query("SE LECT `email`,`first_ name`,`last_nam e`,'registered_ on' FROM `wsd_members` WHERE `username`= '" . prepareData($_P OST['username']) . "' and password = MD5('" . prepareData($_P OST['password']) . "')");...Last edited by Atli; Mar 11 '08, 10:44 AM. Reason: Split into it's own thread and [code] tags fixed. -
Sorry Guys
I think I had you all going the wrong way.
I realised I had the information I just needed to post it to MySQL
Code: (php)
$query .= "'" . prepareData($_P OST['first_name']) . " " .prepareData($_ POST['last_name']) ."'" . ',';
$query .= "'" . prepareData($_P OST['first_name']) . "'" . ',';
$query .= "'" . prepareData($_P OST['last_name'])...Leave a comment:
-
Thank you gentlemen.
I had 2 replies, the first suggested:-
Code: (php)
$_fullname = $_firstName . " " . $_lastName;
(/php)
The 2nd I copied
Code: (php)
<td class="field" name="fullname" value="<?php echo $first_name. " ".$last_name?>" >
(/php)
I had missed the $ on last_name.
Am I right in thinking that the 1st should...Leave a comment:
-
I saw this....
Bambalam PHP EXE Compiler/Embedder
Created by Anders Hammar © 2006 Bambalam
Options:
-w Hide console window for windowed applications
-c Compress output exe (using UPX)
-d Do not encode PHP files
-e:extension.dll Embed and use PHP extension
-i:icon.ico Add icon to exe
- What is it?
Bambalam PHP EXE Compiler/Embedder is...Leave a comment:
-
Trying to concatenate 2 fields
I am trying to create a fullname out of first and last name fields. Am I better to do this inside of constructing the PHP $query string? My current method isn't working for me.
[HTML] <tr>
<td class="label">F irst name:</td>
<td class="field">
<input type="text" name="first_nam e" size="20" maxlength="50"... -
Done, but with errors on the page.
I need to delete this sorry -
Hi
I have resolved my problem in 10 minutes. Thanks to your tip. (3 days of screaming didn't do it!!)
I could see that I had an extra comma at the end of my values.
Thank you once again.Leave a comment:
-
Thanks for that tip. The only thing I can see that looks wrong is the fact that NULL does not have quotes. Should it have?
Code: (php)
1. INSERT INTO wsd_agent (agent_id,first _name,last_name ,add1,add2,town ,county,postcod e,bac_ref,sage_ ref,week,note,c lock,home_tel,m obile_tel) VALUES (NULL,'2008-02-28','First','La st','address1', 'address2','tow n','county','po st code','Bank','A ccounts','Some notes','Clock', 'Tel1','Tel2',)Leave a comment:
-
Error .... right syntax to use near ')' at line 1
I am using a program 'My Contact Table' which is a code generator program. It allows you to easily create a PHP/MySQL web application without writing any code.
I am trying to create an additional data entry page. I have copied an existing page and created a new table in my database. When I run the script I get the error message "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the...
No activity results to display
Leave a comment: