Hi Hendra
An alternative would be to:-
1 LOAD DATA the table, but format each date field as a string.
2 add a date column
3 use UPDATE to convert/re-format the data from the string to date field
4 remove the string column
This solution does not require you to tackle another tool and face the ext
Hello Sander,
> I want to add a variable numer of months to the current date CURDATE().
> I thought it should be something like this:
> select (MONTH(CURRENT_DATE)+MONTH(2))
> but i get NULL as a result.
>
> The purpose of this it to check which records with a experation date is
> earlier or lat
Hello Adv. Systems Design,
> I need to be able to update a field in MySQL, the catch is that I have to add on to
>text that is already there
and I have to be able to do it within MySQL (phpMyAdmin). My first idea was to do:
>
> SET prod_desc = prod_desc + "more info to tack on to end"
>
> but th
Wow Garry,
I know that I like to kick-start my brain by getting 'into' a list problem/challenge
in the (London) mornings,
but today I'm completely beaten. Thanks for the broad explanation, which is probably
quite meaningful, but I'm
not into breeding (could that statement be misunderstood?) and
Janet,
MySQL (and indeed all multi-user databases) has a feature called "Locking". What this
means is that whilst many
users/clients may access a database, apparently simultaneously, when one (or more) is
updating the data in some
way, everyone else is kept locked-out for the duration. Hopefull
Garry,
I regret to say that I can't see an immediate answer.
> CREATE TABLE breeding (
> rec SMALLINT(4) UNSIGNED AUTO_INCREMENT,
> sire SMALLINT(4) UNSIGNED,
> dam SMALLINT(4) UNSIGNED,
> paired DATE,
> split DATE,
> num_offspring TINYINT(1) ZEROFILL,
> PRIMARY KEY (rec)
> );
>
> >
Etienne,
> Well i hope someone will be able to give me a solution...
> Here s my problem:
> I'm working with a hudge mysql table (about 15 columns and 100 rows...)
>
> in fact i ve got to count the number of couples `ncompte`/`naffaire` in the
> table and finaly calculate the number of coupl
Garry,
> > > CREATE TABLE breeding (
> > > rec SMALLINT(4) UNSIGNED AUTO_INCREMENT,
> > > sire SMALLINT(4) UNSIGNED,
> > > dam SMALLINT(4) UNSIGNED,
> > > paired DATE,
> > > split DATE,
> > > num_offspring TINYINT(1) ZEROFILL,
> > > PRIMARY KEY (rec)
> > > );
> > >
> > > First, we d
hat this query will only return a single column of datas (count(*) )
>
> Helllpppp :)
>
> Etienne
>
>
> - Original Message -
> From: "DL Neil" <[EMAIL PROTECTED]>
> To: "Etienne Durand" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
&
Frank,
As yet no response from Garry, but I wanted to ask:
You already have DateTable set up (presumably), so extending its application into a
relationship with the
breeding table is no big deal. Given that one suggestion was that Garry could consider
storing monthly
statistics in another table
using any kind of loop
> before the array_count_values, before this instruction, the array is far too
> big.
> I would win a lot of execution time help please i m sure there must be a
> solution but i m lost...
=is the db on an Internet-accessible server that I could reach?
=Whats
Ollie,
Probably easier to repeat the 'read' (from the first population of the user form) -
and then do the
comparison(s) in PHP - either way it will a SQL query that must be evaluated by PHP
before the UPDATE is issued.
ie put the interaction in a function and call it from the two locations in
.low) no difference in the database
between SELECTs. The only time
the user would be aware that what (s)he thinks of a transaction is not the same as the
RDBMS' view!
=dn
> Or not?
>
> Ollie
>
> -Original Message-
> From: DL Neil [mailto:[EMAIL PROTECTED]]
> S
This is good brain-storming guys!
> Better to use an integer rather than a date field as 2 simultaneous
> transactions can still occur on the same second; most date time fields
> are accurate only to the nearest second.
Good point, John.
However MySQL (AFAIK) does not have any time functions ret
Frank,
> > As yet no response from Garry, but I wanted to ask:
> > You already have DateTable set up (presumably), so extending its application
> > into a relationship with the
> > breeding table is no big deal. Given that one suggestion was that Garry could
> > consider storing monthly
> > stati
Hi Balazs,
> The situation: I have 2 tables in an adverising site. In one table, i have
> the cities used by advertisers, and in the other there are the ads.This ad
> table has a field which refers to the id of the city in that table.
>
> The problem: what mysql method should i use if i want to
Hi Jennifer,
> I am having problems with this code. I want to update a members number of
> days they have been a member can anyone help?
>
> $query["days"]=("UPDATE users set days_member VALUES = ('days_member' +
> '1'));
> $result=mysql_query($query["days"]);
=1 RTFM 6.4.5 UPDATE Syntax
=2 W
Jennifer,
You have a clear idea of what you want done by the script - as guided by "the book".
However, do you have a clear idea of what the script is actually seeing - and
therefore why it is doing what
it's doing?
When debugging, add a heap of ECHO statements to test pertinent values, eg befo
Ok jas
> Ok what is wrong with this sql statement?
> $sql = "UPDATE $table_name SET
> c_name=\"$c_name\",s_addy=\"$s_addy\",city=\"$city\",state=\"state\"zip=\"zi
> p\",phone="\$phone\"";
insufficient checking:
comma missing between state and zip
" incorrectly escaped before phone
...
> I have
Hi Raymond,
> I have this tricky case, at lest for me : )
>
> I'm trying to get some data out of two tables and listing the data in a
> product/price site. But. :
>
> I have one table with productinfo and one with prices.
> And it is several columns with the same id in the pricetable, because
Raymond,
See complaint elsewhere as a result of cross-posting. Add my criticism because I'm on
both lists and keep them
in separate InBox folders and now feeling schizoid...
SELECT * [whatever]
FROM pristabell P, varetabell V1, varetabell V2
WHERE P.varenr = V1.varenr AND P.varenr = V2.varenr
Luke,
> In one of my mySql tables I have a colum that contains many fields of
> numbers.
> for example
>
>
> | id | Name | Age | Sex |
>
> |1 | Jim | 17 | m|
> |2 | Dave | 31 | f |
> |3 | Fred | 25 | m|
>
> Ok and
Jonathan,
I'm trying to write a script that checks for multiple entries on a table in a
database. So far I've been
plagued by MySQL errors. I'm fairly confident my scripting is ok (Then again, I've
been wrong before.) I think
moreover there might be some difficulty with my theory. Then agai
> > RTFM (MySQL) for COUNT() and SUM() (and many other useful functions).
>
> My MySQL client is giving me a syntax error when I enter that command. :-)
=that?
Please post the SQL/PHP causing the problem - the list's crystal ball filter is not
working.
=dn
--
PHP Database Mailing List (
Jonathan,
[have put the cc back to the list]
> Is it possible to make BOTH the date and venue into a single unique index?
=Why not? Like a good woman, treat her right, and SQL will do almost anything for you:
6.5.3 CREATE TABLE Syntax
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create
Todd,
> No one knows???
=or isn't telling?
> hmm... I looked around on php.net couldn't find anything regarding this..
> would I need to do these searches in MS Word docs with ASP?
=go ahead if you are aspidexterous...
=the Word document format is proprietary information - ie not 'open'. So
Court, Todd, et al
> Actually, PHP does COM very wellsearch the PHP-WIN list about "COM" and
> "Word" and you should find some good hints and examples to get going. I
> haven't accessed the keywords portion of a word document yet, but someone
> wrote a spellcheck function that used the spell
Todd,
> Now, if I do COM with PHP, then does this need to be on a Windows
> server? Currently it sits on a Linux box.
I assume if you are setting up a dynamic connection to Word, Word will have to be
running - which almost implies
a Windows box.
Whether the COM component/add-on to PHP (also?)
John,
> I know I could very easily do this after doing the
> initial database call simply by calculating the two
> variables, but, I was wondering if there was a way to
> do this during the sql statement so my results would
> already have my answer...
>
> Here's the setup. I have two tables. Ta
Hi Kim,
> I want to get the first 64 characters from a database row result and display
> only those 64 characters using PHP. The snipped code is here - I've deleted
> all the error trapping and comments:
>
> $result = @mysql_query("select ID, Writer, left(text,64) from Reports where
> writer like
John,
> I'm gonna go out on a limb and guess that I'm missing
> something obvious (and easy) because this sure seems
> like it should be able to be done.
>
> Here's the issue: I need to pull the client name and
> ID out of one table and then, count the records in a
> different table (called ratin
the 'problem'? Perhaps like many others you have a perception that
> >Microsoft couldn't care less about what you
> >are trying to do? Why then make "the Open Source community" your whipping
> >boys (and girls)?
>
> Hope you guys have cooled off & s
Ok Roger,
> Ok, a kinda newbie question. I set up a Postgres DB with a table that had a
> Point and a Polygon in it (to hold XY and shape settings for munging a jpeg
> image in php).
>
> I could not easily figure out how to extract the data into a reasonably easy
> to use format in PHP. The bes
John,
> > I'm gonna go out on a limb and guess that I'm missing
> > something obvious (and easy) because this sure seems
> > like it should be able to be done.
> >
> > Here's the issue: I need to pull the client name and
> > ID out of one table and then, count the records in a
> > different table
Hi Alvin,
> I'm new to both PHP and mySQL but have no choice but to "crash-course" on
> both before end of mid of march to complete my University project. I would
> really appreciate alittle help from any kind soul out there.
>
> I have already created a mySQL database and create all the tables *
word "PERFECTION".
>
> I can't thank you enough. This is now a blistering
> fast query that produces the exact report I was trying
> to get.
>
> Thanks again!!
>
> John Hawkins
>
>
> --- DL Neil <[EMAIL PROTECTED]> wrote:
> > John,
&
Hi Jon, and Howard,
(comments interposed, below)
> Try using something like
> $getlist = mysql_query("SELECT id FROM yourdb",$dbconnectetc);
> $numrows = mysql_num_rows($getlist);
> echo "$numrows\n";
>
> This will give you the number of records in your db.
> If you use autoincrement for the id f
Ok Jonathan,
[I've put the answer back on the list - there are others who can help, and may well
get back to you faster than
I]
> Ok I get the auto_increment stuff... Just one more question. Let's say I
> want to show 25 rows per page. I want the script to generate links to
> the next page, and
Randy,
Suggest pulling the data out of the resultset using a numberically-indexed array. Then
o/p each ...
inside a loop - you know how many times to loop, because that is set by the number of
rows (plus Total column).
BTW if you use aliases on those SUM() columns - it will make life a lot eas
Jonathan,
The original query doesn't work because the WHERE clause is evaluated earlier than the
GROUP/COUNT().
Try putting num1 and num2 in a HAVING clause.
Regards,
=dn
> ok... authorizations and charges... two tables..
>
> Card Number 1 gets authorized 20 times for use (20 rows in the
>
Howdy John,
> Sorry for the lack of information in the subject line,
> but I didn't know how else to explain it briefly...
=don't be sorry, re-word it!
> I have 2 tables and they look like this:
>
> There are 2 other tables involved, but they don't come
> into play for this portion of the probl
Ok jas
> Ok now that I can see the error message how can I fix it... the syntax looks
> correct and the error I am recieving is as follows
>
> You have an error in your SQL syntax near '= 'id'' at line 1
>
> And this is my statement,
> $sql = mysql_query("DELETE FROM $table_name WHERE $id =
CrossWalkCentral,
> any one know how to use send mail with windows instead of linux. Will
> this work are their other options?
Beware of crosswires!
Yes one can send mail (the activity of email) from PHP running on Windows.
I wouldn't bother with loading sendmail (the name of the package) onto
Hi Rudi,
> I've been struggling for a while now so I thought I'd ask.
> What's the easiest way to for to print group sql output.
> For example I need to output customers grouped by zip.
> Like:
> zip
> customer a
> customer b
> zip
> customer d
> customer e
> zip
> customer c
> custoemr f
> custo
Hi Rudi,
> I've done this before in coldfusion.
> It's the one thing I'm note sure on how to do the same(ish)
> in PHP - my language of choice.
> If we have the record set the CF code would look like
>
>
>
> #zip#
>
>
> #customer#
>
>
>
>
>
> So I'm think also to use 2 loops for the sam
Robin
> That may work for a single field in a record that is NULL, but I'm trying to
> join two tables, and report the lines that do not have an entry in the
> second thus:
>
> Question Table
>
> Q_idQuestion
> 1Question 1
> 2Question 2
> 3Question 3
> 4Q
Hi Rudi,
> What do you think ?
There are some problems.
> I'll test it tomorrow at work.
> I'll let you know how she goes.
How did you get on?
Regards,
=dn
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi Chris,
Did you get a useable answer to this?
> Using PHP and MySQL, how can I do an ORDER BY where city = $city?
What
> happens is this, I have a search engine which works nicely, but I want
to
> bring up the closest matches to the search first at the top, how can I
do
> this?
>
> Say you ent
Ken,
Check out DAYOFMONTH() and MONTH() and a wealth of other useful date
functions. RTFM: 6.3.4 Date and Time Functions
The answer to your question about AUTO_INCREMENT 'reset' can be found at
6.5.3 CREATE TABLE Syntax under "table_options".
Regards,
=dn
> I have a test table with the ususal
Ken,
If it works, it works!
If you want to store the birthdate in a single column in the db, then
make the datatype a date in CCYY-MM-DD format, then prepare the query by
asking PHP for the server's date as month (MM) and day (DD) and apply
those to the query using the functions I pointed you at
Ken,
> > Check out DAYOFMONTH() and MONTH() and a wealth of other useful date
> > functions. RTFM: 6.3.4 Date and Time Functions
> There's a few interesting items here OK, Thanks for the pointer.
Go for it...
> > The answer to your question about AUTO_INCREMENT 'reset' can be
found at
> > 6.5.3
> > Ok?
> Great, that explains better than "most" of the tutorials I've read.
> It is unfortunate that most if not all reference documentation expect
the
> reader to have a college degree just on their subject in order to
understand
> "wot in 'ell" they're saying.
> I've done pretty well in figur
Jennifer,
> Wondering do I have to have the WHERE clause in a select query?
> $b=mysql_query( SELECT * FROM my_table) <-can I use something like
this
> or do I have to put WHERE in the statement?
Hate to answer a question with a question, but what happened when you
tried typing this query i
Joe,
> Hi there, I have a field in my db called expires and it holds a value
for
> the last time somebody visited my site such as 1015354119 .
>
> How would I add 15 minutes onto this? Would I use the mktime() and do
it
> that way, or there a better way to do this?
Use a SQL function (quicker,
Andy,
> So what is the proper function in PHP to convert the MySQL timestamp
into a
> proper format like Sonday, Apr. 20th 2002?
SELECT from SQL using UNIX_TIMESTAMP()
Format for presentation in PHP using: string date ( string format [, int
timestamp])
Regards,
=dn
> > > I am playing around
Yoga,
wa aleikum as-salaam (tr: greetings returned to you)
> salam,
> i'm make a database in mysql, example :
> namescore Ascore A Total
> john 7890
> mike 9070
> etc...
> ask me is:
> how to make multiple or total in coulum "Total"
Hi Andy
I apologise. The way I wrote the suggestion looks very much like a SQL
query doesn't it? It wasn't!
It would have been better expressed if I had said:
retrieve the MySQL timestamp field as a UNIX (epoch) timestamp, by using
the UNIX_TIMESTAMP function within the SELECT statement
> I trye
Hi Andy,
> I am wondering if it would be possible to get the amount of different
values
> in one sql command.
> E.g.:
> field age: 0,3,5,5,2,3
>
> Sql querry should return how often 3 occurs. Which would be 2. And as
well
> the other values... 1 for agestructure 2 becuase it occures only once.
>
Hi Chris
> I have delete working perfectly by doing the following:
>
> include("connectionstart.php");
>
> mysql_query ("DELETE FROM emaillist WHERE EMail = '$email'
> ");
>
> However, how do I return a true or false flag whether the row was
deleted or
> not? I basically need to know how to do a
Howdy John,
Two things: firstly the stated objective and the sample query differ
(WHERE division.leagueID???). Secondly I'm sorry that I'm short of time
this morning, otherwise I'd try to develop/illustrate this for you...
May I suggest that you employ the KISS principle: Start off by coding a
s
Hi Andy,
> I have a timestamp in my table to store a date. Now I have to update
other
> columns and everytime I do this, the timestamp is updated as well. Is
there
> a other way then getting the value infront and storing it again?
If you have first read the row's data, UPDATE the timestamp fiel
Rehab,
> i have an input field in a form that accept date called $date and in
databse i made it of type $date so its defualt is -00-00
>
> the problem is when i say:
> if($date!="-00-00")
> {do something}
>
> he doesn't understand $date!="-00-00"
Please copy-paste the actual error m
Manual reference:
http://www.php.net/manual/en/function.mysql-connect.php
resource mysql_connect ( [string server [, string username [, string
password [, bool new_link)
Seeing it is not a web page you're connecting to, try removing the
"http://";.
"localhost" has particular meaning within
Hi Dave,
> I am trying to count how many product names in my db have the same
> category id and then show it ie:
>
> Catid 1 Product 1
> Catid 1 Product 2
> Catid 2 Product 3
> Catid 3 Product 4
> Catid 3 Product 5
>
> Result would be
>
> Catid1 has 2 products
> Catid2 has 1 products
> Catid3 has
;error:
> ".mysql_error());
> $cntcat = mysql_fetch_array($cntresult,1,catcnt) ;{
> for($n =0; $n < count($cntcat); $n++){
> $showitemcount = each($cntcat);
>
> Dave Carrera
> Php Developer
> http://davecarrera.freelancers.net
> http://www.davecarrera.com
>
>
> -
is correct, then where is the linkage between the two
SELECTs, and why not do the whole job in one joined SELECT?
Please advise,
=dn
- Original Message -
From: "Dave Carrera" <[EMAIL PROTECTED]>
To: "'DL Neil'" <[EMAIL PROTECTED]>
Sent: 16 March 2002
BTW for all who are following this, Patrick has cleverly illustrated
that most of the northern hemisphere locations where summer time is
observed will 'spring forward' this weekend. Most of the southern
hemisphere locations that were in summer time did their 'fall back' last
weekend!
NB the two us
Russell,
> I am contemplating a Historical Database
> I barely can spel redundant let alone normalize so I am handicapped.
> The aim is to enter a name only once. I am studying linking tables.
> In the [Contact]
> idContact
>
First_Name,Last_Name,Middle,Suffix,Full_Name,idCity,idState,City_State,
Hi Dave,
> I am trying to create a registration area that uses a nickname and
email
> pair.
> I need both to be unique.
> So how do I that either do not already exist then if unique insert
into
> db.
> if nickname exist then error = "sorry..."
> if email exist then error = "sorry..."
> else must
Josh,
Look up JaneBuilder (or something like See Jane Code) in Google.
This pkg will generate basic HTML forms from a MySQL (etc) db tbl
schema.
A bit basic, but possibly enough to get you where you're going...
=dn
- Original Message -
From: "Jonathan Hilgeman" <[EMAIL PROTECTED]>
To: "'E
Jeff,
> I have a form where someone enters the body of an email message
> into a part of a form to be sent out to a list. Then a
script
> retrieves the body and sends it via email. However I can't get line
breaks
> to show up (I'm using MS Outlook) even if I enter the \n into the
textarea
> form
Sure he could (and it might look a lot nicer if he did...), but:
1 he said he doesn't want to,
2 ASCII text can also be formatted (with line breaks, at least),
3 using HTML encourages email bloat, and
4 some email clients don't render HTML
Regards,
=dn
> Hey, couldn't you just send the text as
both \r and \n to terminate a
line
> > on an e-mail, regardless of the platform. This should include the
header
> > aswell.
> >
> > At 12:00 14/04/2002 +0100, DL Neil wrote:
> > >Jeff,
> > >
> > > > I have a form where someone enters the body of an e
Hi Alex,
> Got my select statement to work as follows:
> $query = ' SELECT * FROM notices WHERE TO_DAYS(eventdate) >=
TO_DAYS(now())
> order by eventdate';
=well done!
However the TO-DAYS calls do seem a bit OTT.
Please post the schema for tbl:notices - specifically the datatype for
eventdate.
eventheading];
> > > $id = $row[id];
> > >
> > > Database table "notices" as follows
> > > id int NULL autoincrement
> > > entername text NOT NULL
> > > enterdate text NOT NULL
> > > eventdate
Alex,
> I'm still having problems with the mail function.
>
> I have installed PHP in a Windows 2000 test server. Is there something
I
> should do to allow this function to work. I am a complete newbie and
> installed with the default settings. I get a "Failed to connect Error
when I
> call the m
Alex,
That's the info in question!
> Here is the section from my PHP.INI
>
> [mail function]
> ; For Win32 only.
> SMTP = localhost
>
> ; For Win32 only.
> sendmail_from = [EMAIL PROTECTED]
>
> ; For Unix only. You may supply arguments as well (default:
> 'sendmail -t -i').
> ;sendmail_path =
>
Steve,
> For some reason the below statement is not working. Can anyone tell me
why?
>
> Select EDIT_LOCK from ordmaster where EDIT_LOCK + INTERVAL 10 MINUTE <
now()
> AND ORDER_NO = '5' AND EDIT_LOCK > 0;
>
> -EDIT_LOCK is a MySQL (ver 3.23.49-max) time field, allows nulls, default
is
> NULL.
>
Jefferson,
> I'm writing a web application in PHP to do referee scheduling for soccer
> games. For each game (a single row in a table) I have a cell for
> referee. The cell stores an integer that I can do a join on with another
> table of people. I need a way to prevent people from being able to
David,
I have a MySQL table called images, each with a rating from 1-10. The column
is a decimal(10,2). For simplicity's sake, let's say i have the following:
CREATE TABLE images (
image_id int not null auto_increment,
image_path varchar(255) not null,
rating decimal(10,2) not null,
prim
Chip,
It's not so much off topic as a perennial topic - see archives and many
tutorial articles.
When you've worked out the answer to this question, please try out your
algorithm on my (or any other 'foreign') address. Then consider the imminent
introduction of further TLDs, eg .info (four charac
Jason,
Concur with your advice, but was also amused by its juxtaposition with your
sig file philosophy...
=dn
[snipped]
> > I have a regex for validating email addresses -
> You're strongly advised not to write your own regex for validating email
> /*
> The most important things, each person
Regarding the good sense or otherwise for checking email addresses:
> This is from a php/mysql book...
If it was from page 115, then please turn over to page 116!
Regards,
=dn
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Regarding the problem you are actually asking about:
> > > if (empty($useremail) || !eregi("^([A-Za-z0-9\.\_-])+@([A-Za-z0-9\_-])
> +\.
> > > ([A-Za-z]{2,3})+$", $useremail))
> > Notice the {2,3} which is supposed to limit the last part to 2 or 3
> > letters, but I have been testing this and
> >
write so it will look like this:
>
> $filename = "datafile.txt";
> $varsused = "var1,var2,var3";
> $delimiter = " | ";
>
> then the opposite of that to import/implode the records as well as to
> apply the filter?
>
> I know I'm new but
andy,
I find the PCRE regex option easier to work with. Herewith a solution which
takes care of case (without changing the original text), and without regard
to spaces or other characters (including the first and last characters of
the string - which you didn't mention/identify as potential probl
Hi simon
> My table has an INT column named 'member_id' which is set to
AUTO_INCREMENT.
> It works very well but I have inserted and deleted some test rows during
the
> development stage and now my incremented numbers have jumped ahead.
> The deleted rows (their member_id values) have not been fo
Hey Graeme,
> $MemberID = @mysql_query("SELECT ID FROM SiteMember WHERE Username =
> '$valid_user'");
> $array = mysql_fetch_assoc($MemberID);
> print_r($array);
> this will produce:
> Array ( [ID] => 3 )
>
> All I want is the value 3 so that I can go ahead and insert that into the
> Lookup table
Gerard,
> Im looking for another opinion on an sql statement.
> SELECT sc.col1 FROM search s, search_content sc WHERE s.word = 'mysql' >
AND s.wid = sc.wid OR s.word = 'apache' AND s.wid = sc.wid;
> I had to use "s.wid = sc.wid" twice in the sql for the query to work
> properly. Is this the legal
Rodrigo,
Is there a way to convert a date " 20/11/2002 " to a Float number in PHP,
since the date starts in 30/12/1899, just like the delphi treats the
dates
=Check out UNIX timestamps (but watch the valid date range),
=dn
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
Sorry Leif, but CrystalBall v2.6 is currently unable to help.
The word WHERE features.
Show us the money - or second choice: the (erroneous) code...
=dn
> I'm trying to run a cron job to delete forum topics more than 2 hours
> old. I know how to do that, but the problem is also deleting the post
27;s last DELETE format option
works sufficiently well, the best option might be two DELETE's: the first
per your suggestion above and the second to remove all entries in posts that
no longer join to a topics row.
=Regards,
=dn
> DL Neil wrote:
>
> >Sorry Leif, but Cryst
> I didn't realize that, is this discussed in Paul DuBois' book? Or, can you
=not "book", but "books"!
="MySQL" (New Riders) discusses network access/security in Chap 12, but
Jason's solution is also discussed in Chap 11. Unfortunately this book is
getting a bit old when it comes to these more ad
Alex,
> I have two tables in my database with a department name.
> One table (department), the name only appears once and it includes all
> departments in the school. In the other table, (courses) department can
> appear several times, but not all departments will be in the table.
>
> I used the f
tolower($search_term), "$search_term",
> strtolower($matched_string));
>
>
>
> // -Original Message-
> // From: Boget, Chris [mailto:[EMAIL PROTECTED]]
> // Sent: Thursday, 18 October 2001 2:57 AM
> // To: 'Chris Payne'; DL Neil; [EMAIL PROTECTED]
> I'm trying to setup a generic function to use to initialize all mysql
> database access for a site.. Something like
> function($tablename); How can I do this and preserve the connection outside
> of that function?
> ?
Hi Dustin,
Do you want something like: "Making arguments be passed by refer
";
break;
}
}
?>
je souhaite faire apparait une l'image ki est donné dans ma base pour
$colonne2["IMG"]>. Il m'affiche bien le bon texte qd je met echo
$colonne2["IMG"]; , mais j'aimerai qu'il mettent cette valeur en img
src.
J'espere etre assez clair :)
David,
J
Imbalance of double-quotes on line 43!
Thus // comments have all been included in quoted string and hence strange text output.
=dn
- Original Message -
From: "GEORGINA ELAINE BAILEY" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 19 October 2001 18:26
Subject: [PHP-DB] PHP and Oracle
> Just a cosmetic question really. Why are the three links I have put in at
> the bottom of the script appearing at the top on the WEb page, just beneath
> the comp sci banner. How do I get them to appear beneath the table?
Georgina,
It may look "cosmetic" but a browser's job is to display mar
> Is it possible to put variable operators in queries?
=I can see no reason why not - you're not actually putting the 'variable' in the
'query', just using a PHP-variable to
build a PHP-string which will be sent to MySQL as a SQL query...
> I tried this (the real variable comes from a form)
> $
1 - 100 of 189 matches
Mail list logo
