this is a big question and i'm not trying to get you to do my modelling
for me, but if anyone has experience with this i'd appreciate being
pointed in the right direction:
How could one efficiently manage time slots in a dB? I mean for example
telling the dB that Mike can be somewhere at 6:15 o
it sounds like you may be serializing your SQL, in which case the following link might
help.
http://www.ashleyit.com/rs/jsrs/select/php/select.php
Matthew Nock wrote:
> Hi All,
>
> I have a strange query which I need to build - I have looked at the JOIN and
> aliasing functions of mySQL but not
got my other one sorted out; thanks everyone.
now:
how do i get it so when you hit "enter" on the keyboard it's the same as
hitting the "submit" button with the mouse? When I hit enter, it clears
my form and reloads the current page.
--
PHP Database Mailing List (http://www.php.net/)
To unsubsc
Seth Yount wrote:
> in you print statement you have ?lastname=%s, shouldn't that be '$s'
> denoting a variable being passed? Try that out.
>
> gl -- Seth
>
> Matthew Crouch wrote:
>
> > this bit from my index page is giving me 2 headaches:
> >
I changed method to GET and the value of $lastname seems to be getting
passed but so is $submit, with the value "Search for Last Name" as you might
expect. Probably this ain't the answer
Matthew Crouch wrote:
> this bit from my index page is giving me 2 headaches:
>
this bit from my index page is giving me 2 headaches:
1. it isn't passing anything into the URL
2. the page that gets called ("name.php") sits and tries to load
forever. it looks like it's even filling up my hard drive with data (?!)
Note: it does this (#2) even if I type in the URL with a variab
i think i got this solved; sorry about the non-php question but there
isn't a mysql newsgroup that i know of.
Matthew Crouch wrote:
> Here's an easy one that I can't find laid out for me anywhere:
> I want a self join that pairs up the id numbers of a table in every
>
Here's an easy one that I can't find laid out for me anywhere:
I want a self join that pairs up the id numbers of a table in every
permutation
e.g. i have id #s 1, 2, and 3
i need this result:
1 2
1 3
2 1
2 3
3 2
3 1
clear enough?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscr
my guess is you've got a double-quote problem like that other guy...
Hi All,
>
> Would someone please help me with the following code?
>
> I am trying to make this work like if I have 15 gold pieces and I deposit 5
> it will subtract 5 from the gold pieces I have and deposit the 5 into my
> accou
i'm guessing you use mysql, so...
you can use the mysql_insert_id to retrieve the most recent addition, then
select on it
$newid=mysql_insert_id();
$sql=select [the auto_increment field] from table1 where id='$newid';
Does that help?
Morten Nielsen wrote:
> Hi,
> I got the following insert sta
for anyone else who needs it:
http://www.phpbuilder.com/snippet/download.php?type=snippet&id=356
Matthew Crouch wrote:
> should be simple as pie, of course, but i can't find a straightforward
> syntax example in the documentation. i'm trying to change the PHP date
> fo
Another way is to set a testing variable and then print an if it
changes
(this off the top of my head, probably bugs in it but you get the idea)
while $myrow=mysql_fetch_row($result) {
if $myrow["dishtype"]<>$test {
echo "";
//here you would print the rest of the info about the dish from the
this is in the ballpark:
http://phpbuilder.com/columns/ying2602.php3?page=1
Andy wrote:
> Hi there,
>
> I did recently read an article about security. Now I absolutly see the need
> of recoding my authentification procedure on a community site.
>
> There are questions I hoped some of you gu
should be simple as pie, of course, but i can't find a straightforward
syntax example in the documentation. i'm trying to change the PHP date
format to mysql's.
my code:
$today = date("MMDD");
$sql = "INSERT into table (date) values ('$today')";
and so on...
is filling the date field with ze
basically a yes or no question my brother wants me to ask:
Does PHP support these objects? If not, Can they be faked?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrator
I looked at hypermart.net and they want $30 a month, which seems okay
but their package comes with things I don't need, like 15 email
addresses. I have a modest little dB -- does anyone know of good deals
for plain folk?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail:
here it is:
http://www.php.net/manual/en/function.explode.php
[EMAIL PROTECTED] wrote:
> Hi,
> i have a variable which is multi valued seperated by # (say as) delimiter
>
> like student#name#address#college#etc... #...#
> i want to seperate it into an array with index $i
> can anyone suggest a
I'm no expert, and my code is probably buggy, but I think this is the gist of it:
%s", $myrow["colorid"], $myrow["colorname"]);
}
?>
Chris Payne wrote:
> Hi there everyone,
>
> I have a shopping cart which is starting to work nicely, but I have to select
>size/color from the entries, how do
your line 357 doesn't appear to have its semicolon...
Rob Day wrote:
> Sorry for not giving enough info. This is right in the middle of the script.
> I do have the opening and closing tags. It must ne something else.
>
> -Original Message-
> From: Matthew Crouch [mai
you haven't shut your script with the ?> before starting your HTML, near as I
can figure it
Rob Day wrote:
> I've written a small script that processes a form from a webpage and sends
> the submitted data as an HTML e-mail that has the form all filled out
> already. I've gotten smaller versions
I have multiple functions hitting the dB (mysql) with inserts in a
single page, and they can't seem to get together; i.e. I can get this or
that function to do its job, but not all of them at once. Is there
something I should know about "closing out" a mysql_query or $result
before another can be
You need an associating table; members and movies are in a many-to-many
relationship here.
The associating table represents the act of viewing-a-movie, and describe who
and what are involved
comme ca:
"members"
memberid, name
1 Fred
2 Jack
3 Jill
"movies"
movieid, title
1 Fear and loathing
2 Mo
solved my own problem.
if anyone else needs it, the function is substr($string, firstposition,
number)
http://www.devshed.com/Server_Side/PHP/StringTheory/page4.html
Mateo The Db Guy wrote:
> i'm fairly new to php, and thank you in advance for helping.
> is there a function that will extract the
23 matches
Mail list logo
