How are you printing/extracting this information? I find it very
unlikely that it's returning that string - it would eliminate any
localization opportunities as well as time conversion / math operations.
Use print_r() to print the contents returned from SQL Server directly,
if you're using date
> -Original Message-
> From: El Bekko [mailto:[EMAIL PROTECTED]
>
> http://php.belnet.be/manual/en/function.is-numeric.php
>
> Apparently there is :)
>
>
> Dwight Altman wrote:
> > Hello List,
> > Is there an IS_NUMERIC(aCandidateString) function in MySQL that I
can run in
> > a query,
>-Original Message-
>From: Arie Nugraha [mailto:[EMAIL PROTECTED]
>
>You can also use an array :
>
>
> Some
Value 1
> Some
Value 2
> Some
Value 3
>
>
>to get the the third value from the form you can do like this :
>
>echo $_POST["check"][2];
>?>
Good basic examples, two notes though -
1)
http://www.google.com/search?q=oracle+limit+client+connections
http://www.oracle.com/technology/pub/articles/php_experts/scaling_oracle
_and_php.html
Summary - either you're not using persistent connections, or your site
is just very busy. If it's just that the site is busy, best you can do
is j
I don't think this list requires you to be subscribed to post, does it?
[ 0FF T0PIC ]
Judging from the mail address (which can be forged by a 2yr old) - I'd say it
was entirely automated. What I don't get, is why messages like this get sent
at all...
Crossed long time, be out of control lou
I think he's looking for str_replace() / preg_replace() or sprintf() or
similar
http://www.php.net/str_replace
http://www.php.net/preg_replace
http://www.php.net/sprintf
cheers,
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within
Friday, September 30, 2005 10:26 AM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] PHP Forms - upload VS text. .
Humm.. in the form action you use a function called tpl();
What function is that, I find no reference of it on the php.net function
list.
- Original Message -----
From: "&
Beyond that it's just the $_FILES array and $_POST array.
cheers,
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
-Original Message
Are you sure you even want to be storing it that way? What happens when
you delete the following row? Do you have to re-index each column?
There's no (trivially) easy way to do that with an update statement as
it stands.
vehMdlCd[1] LEX
You're likely better off storing it simply as
Security through obscurity is a prominent placebo these days. If you
don't want users deleting the wrong images, make the
class/function/script that deletes them check for permission. Don't
have your security dependant on the client.
cheers,
- Martin Norland, Sys Admin / Database / Web Develope
(top posted because the subject says it all)
"session_register -- Register one or more global variables with the
current session "
It's pretty much deprecated in favor of the $_SESSION superglobal.
It's recommended not to mix the two, and it functioning properly depends
on register_globals being
One of the strings you're inserting has an quotation mark (apostrophe).
You're going to have to do some more careful data scrubbing on the
incoming data.
E.G. one of the strings says "it's used in the retail, banking, and
insurance industries, among" ...
And it's breaking the containing ' - ins
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en"
dir="ltr">
... Not necessarily.
cheers,
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necess
Don't mix mysql_ functions with mysqli_ functions, and you'll have much
greater successes.
$dbcon = mysql_connect( 'localhost', 'root', 'password', 'database_name'
);
should be
$dbcon = mysqli_connect( 'localhost', 'root', 'password',
'database_name' );
Cheers,
- Martin Norland, Sys Adm
Figured I'd expand on what these evaluate to, in case anyone gets lost
otherwise:
>-Original Message-
>From: Micah Stevens [mailto:[EMAIL PROTECTED]
[snip]
>You can use variable variables.. like this:
>
>$num = 2
$num == 2 [obviously :) ]
>$varname = "id".$num;
$varname == "id2"
>$$varn
>-Original Message-
>From: Neil Smith [MVP, Digital media]
[mailto:[EMAIL PROTECTED]
>
>The variable type you need is called an array, it has numerical indexes
:
>In PHP you can just omit the index and it'll be automatically
>auto-incremented from zero, so there's no need to maintain a c
> -Original Message-
> From: Jochem Maas [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 10, 2005 11:59 AM
> Subject: Re: [PHP-DB] Update multiple records
[snip]
> > This line in particular clearly warrants attention. Cookie to
whoever
> > guesses what" the' problem` might 'be.
>
> th
> -Original Message-
> From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 10, 2005 10:40 AM
> Subject: [PHP-DB] Update multiple records
>
> Having a problem here with updating multiple records in a table.
[snip]
Lets see - where to begin...
> SELECT * FROM `Pro
> -Original Message-
> From: Jochem Maas [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 06, 2005 3:26 PM
> Subject: [PHP-DB] I'm trying to out perform Martin Norland
>
> in terms of helpfulness and volume of replies to Q's on this list
> ;-) but it doesn't help that my mails
> -Original Message-
> From: Ford, Mike [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 06, 2005 1:13 PM
> Subject: RE: [PHP-DB] Trying to connext to MySQL with PEAR
[snip]
> Oh dear, as a fully-paid-up pedant, I'm afriad I can't resist this
one:
>
> Doesn't affect the answer, but thi
> -Original Message-
> From: Andrew Kreps [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 06, 2005 12:30 PM
> Subject: Re: [PHP-DB] MySQL Auto PK
>
> On Wed, 05 Jan 2005 18:11:23 -0500, John Holmes
<[EMAIL PROTECTED]> wrote:
> > OOzy Pal wrote:
> > > Is it possible to have mysql at an
> -Original Message-
> From: Todd Cary [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 06, 2005 11:36 AM
> Subject: [PHP-DB] Stopping display of DB errors
>
> When I run a query using Interbase and if an error occurs, the error
displays in the browser window even though I am testing f
> -Original Message-
> From: Bastien Koert [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 06, 2005 8:34 AM
> Subject: Re: [PHP-DB] str_replace question
>
> [snip]
>
> A neat little trick would be to create the initial part of the
statement with a predefined where clause based on som
> -Original Message-
> From: Jochem Maas [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 06, 2005 7:13 AM
> Subject: Re: [PHP-DB] php problem
>
> if so then PHP is not either:
>
> 1. your webserver is not configured to use php to handle files with a
php extension.
> 2. your webserver
> -Original Message-
> From: Doug Thompson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 05, 2005 8:44 AM
>
> I isn't my intention to start a peeing contest, but if *you* get rid
of the chip and actually read the manual excerpt, the equivalent SQL
statements it cites are very defin
> -Original Message-
> From: Jochem Maas [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 03, 2005 12:16 PM
> Subject: Re: [PHP-DB] NULL VALUE
>
> LightBulbMoment (tm): 5 seconds of searching on the MYSQL site tells
me
> STATUS is a keyword. try either renaming your field or using backt
> -Original Message-
> From: Mark Benson [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 21, 2004 11:56 AM
> Subject: [PHP-DB] HTTP Auth for PHPMyAdmin
> What do i need to do to enable proper HTTP authorisation for
PHPMyAdmin?
>
> I enabled it in the config file, but it rejects my at
> -Original Message-
> From: amol patil [mailto:[EMAIL PROTECTED]
>
> Parse error: parse error, unexpected $ in
/home/dollar1/public_html/signup.php3 on line 379
> Parse error: parse error, unexpected $ in
/home/dollar1/public_html/login.php3 on line 152
> Parse error: parse error, unexpe
> -Original Message-
> From: Bastien Koert [mailto:[EMAIL PROTECTED]
>
> huh? you can and should be able to upgrade to 4.0.x without too many
> problems. PHP 4.3.9 has no problems with that, nor will PHPMyAdmin.
Moving
> to mySQL 4.1 will involve more pain as the protocols are vastly
diff
> -Original Message-
> From: Perry, Matthew (Fire Marshal's Office)
[mailto:[EMAIL PROTECTED]
>
> Does anyone know of a FREE program that exports MySQL to access? The
trial versions of the
> ones I have downloaded do not export all the records of the database.
If you can get a .csv expo
> -Original Message-
> From: Mark Benson [mailto:[EMAIL PROTECTED]
> If I try that it returns:
> You have an error in your SQL syntax near 'ON DUPLICATE KEY UPDATE' at
line 1
> so I guess something doesn't work there. I also tried it with and
without the line ending and it didn't work ei
> -Original Message-
> From: Mark Benson [mailto:[EMAIL PROTECTED]
> The following SQL statement returns an error. What is wrong with it?
The error is stated as being near 'ON DUPLICATE KEY
> UPDATE foo_no='$data[1]', alt_no='$data[2]', descript='$data[3]', pr'
>
> "INSERT INTO `foobar2`
I've got some strange mysql behavior, wondered if anyone encountered it.
I have a database with some float(4,3) fields.
I have a version of this running on mysql 4.0[.23], and another running
on mysql 4.1[.7].
When I insert, for example, 12 into it - the 4.0 version stores '12.00'
- but the 4.1 v
> -Original Message-
> From: John Holmes [mailto:[EMAIL PROTECTED]
> You are wrong. :)
>
> Having register_globals OFF helps to prevent poorly written programs
from being vulnerable to
> users setting variables in the URL/header/cookie data. You can still
write horribly insecure
> progr
> -Original Message-
> From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
> No... That is just some strange error generated by the cut and
paste. The "IS NOT NU LL" that is...
> The other issue with 'tablename'... I simply typed 'tablename'
in the e-mail because I didn't
> -Original Message-
> From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
> I have been using a PHP page to update a database table for a
long time now.
> Unfortunately, I have noticed that frequently when I perform an update
I get back an error
> saying "Table 'tablename' doesn
> -Original Message-
> From: Chris Wagner [mailto:[EMAIL PROTECTED]
> what i want to do is "version" a database. i am not sure if i am
using the right word for > > this, but...
[snip]
> * where, in the MySQL database could i store a "version number"?
>i know Tables have a "comment" fi
*** Your entire set of code is commented out. Fix that first and play
with it.
/* begins a comment, that doesn't end until a */
/* $total_count++;
Should be
// $total_count++;
Or
/* $total_count++; */
The same goes for $display_count++; later in your code.
> -Original Message-
> From: Edward Dias [mailto:[EMAIL PROTECTED]
> while($row=mysql_fetch_array($result)({
> echo "$row[project_number]\n";
> }
You have a backwards parenthesis.
Try:
while($row=mysql_fetch_array($result)) {
Cheers,
- Martin Norland, Database / Web Developer, I
I agree with this wholesale, except one thing should be noted...
If this content ever changes, and you need to be noting that, you'll
need some way of tracking what's been retranslated and what hasn't. If
it never changes - consider yourself lucky, but as someone who works
with a translated app,
> var_dump($rsVendorJobs);
>
> object(kt_adorecordset_mysql)(33) { ["dataProvider"]=>
Looks like you're using the ADODB library (
http://www.certicamara.com/consulta/lib/adodb/docs-adodb.htm ) or
similar. ( That may not be the official site, I just bounced around a
bit. )
All your previous code
-Original Message-
From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
> They are NULL. That is the problem. I can't for the life of me ,
figure out a way to
> initialize these variables.
(Bear with me on this, because I've got nothing remaining to go on...)
What do you get from:
All I can recommend from here is heavy use of printr() or var_dump() on
your variables.
> $totalRows_rsVendorJobs = $rsVendorJobs->RecordCount(); // end
Recordset
This clearly means $rsVendorJobs is an object of some sort, probably
some custom recordset object as you've said - so your best bet is
:37 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] stumped-mail and database
--- "Norland, Martin" <[EMAIL PROTECTED]>
wrote:
> 1) change
> $to = "$rsVendorJobs->Fields('Conmail')";
> To
> $to = "{$rsVendorJobs->Fields(&#
-Original Message-
From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
> Here is what I tried:
>
> $to = "$rsVendorJobs->Fields('Conmail')";
> $subject = $rsVendorJobs->Fields('RefEm');
> $body = '$cl';
> $headers = "From: [EMAIL PROTECTED]";
mail($to,$subject,$body,$headers);
> echo "Mail
> AFAIK no version of PHP ever did compile with mysql by default. You
*had* to
> use --with-mysql if you wanted mysql support. The choice was whether
to use
> the bundled library (the default if you didn't specify a directory
with
> --with-mysql) or some other library.
> If this is where you go
> anyway mysql_connect() won't work in php5 - although I do believe it's
> possible to compile in the 'old' mysql lib yourself.
No, PHP5 does indeed have some new (and different) functions for mysql,
but it supports (properly, nothing old about it) the normal mysql
functions as well. The change
Are you using view source a lot? (some of) Mozillas view source
commands send the query again, minus the POST vars. This could be the
behaviour you're seeing.
I say some of because there are multiple ways of viewing the source -
web developer toolbar's (extension) doesn't seem to suffer from thi
http://www.php.net/manual/
http://www.php.net/manual/en/language.types.string.php
Basically:
* quoting with ' is when you just literally want that string
output.
You can't call functions or print variables values within it.
e.g.print 'hello_world() $name';
-Original Message-
From: Bastien Koert [mailto:[EMAIL PROTECTED]
>
concat_ws('-',{$_POST['PO_Year']},{$_POST['PO_Month']},{$_POST['PO_Day']
})
I'm pretty sure this will error because of the unneccessary {}'s around
the POST array items. PHP really doesn't like you using extra curlies
arou
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
> '{$_POST['PO_Year']}-{$_POST['PO_Month']}-{$_POST['PO_Day']}'
"{$_POST['PO_Year']}-{$_POST['PO_Month']}-{$_POST['PO_Day']}"
Variables aren't evaluated in single quotes.
- Martin Norland, Database / Web Developer, Int
>> Hi, what can i do, where users can't select and copy my text from
>> web-page.
If you send text to the user, the user can always retrieve that text as
just that.
Whatever secret l33t code you're trying to protect, is just copied from
some dhtml tutorial anyway. Whatever text on the page you d
-Original Message from: Micah Stevens
[mailto:[EMAIL PROTECTED] -
> you can use .htaccess files to modify php.ini values for a particular
directory.
Yeah, try some of these fun settings!
# Run for 10 days!
php_value max_execution_time = 864000
# suck a gig of ram!
php_value memory_limit
Section 3.3 of that rfc indicates that ; is reserved in URLs - so I'm
guessing there's another solution.
Obviously you can wrap all your URLs up in a nice CDATA structure - but
that seems ridiculous.
A quick googling perusal confirms what I expected:
http://www.biglist.com/lists/xsl-list/archives
-Original Message-
>When you export a table to excel, is there a way to merge cells and
>create borders? I want my excel file to look exactly like my html
>table looks.
>
>Matthew Perry
I've not used it personally, but a route you may want to explore is
PEARs Spreadsheet Excel Writer:
-Original Message-
>Does anyone know a good way of locking out access to a record on a
>MySQL database when someone has the update page open? The problem is
>that we have a local intranet site which is accessed by members of
>different departments. Now at the moment when someone loads t
> Correct - LIMIT 30,2 would show 2 records starting with the thirtieth.
thirty-first.
Sheesh, I should get outta here too - ^airhead^
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Ju
nal Message-
> From: Norland, Martin [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 24, 2004 3:38 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] how to implement "pages" of results
>
>
> Basic example: (handwritten in email client, syntax error
Basic example: (handwritten in email client, syntax errors may exist)
if (!isset($pagenum) || $pagenum < 0) { $pagenum = 0; }
$range = 30;
$start = $range*$pagenum;
$end = $start + $range;
$limit = " limit $start, $end";
$query = "select * from $table where host='$somename'$limit";
Then just pass
-Original Message-
From: Mark Benson [mailto:[EMAIL PROTECTED]
>The real problem you're having is the statement says "while there are
>results in this query, grab them" - once you reach the end of the first
>while loop, there are no more results, so the second one is skipped
>right ove
The real problem you're having is the statement says "while there are
results in this query, grab them" - once you reach the end of the first
while loop, there are no more results, so the second one is skipped
right over - it's condition *never* evaluates true.
If the query isn't changing, and the
Remove the @ in front of the mysql_num_rows function call. The @ symbol
supresses errors, so that's likely where your error would be printed.
Cheers
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
tho
> I am fairly confident that in this particular case the opinion(s)
contained within this email would nicely coincide with those of St. Jude
Children's Research Hospital.
>
> We live in a world full of geometry.
>
> Ignatius Reilly
... Not to be outwitted ...
I'm quite certain my statements in t
> Just a quick question, I'm having to calculate some values from an
existing database,
> but on some of the results I get (For example)
> 0.5907
> How can I limit the result to only 2 digits after the decimal point
with PHP?
> Thanks
> Chris
Let the manual guide you: http://www.php.net/ro
>$sql = "SELECT * FROM users WHERE username='$username' AND
password='$password'";
>$result = odbc_exec($dbConnection, $sql);
>
>while ($rows = odbc_fetch_array($result)) {
> //This doesn't work with odbc_fetch_object either
> print $rows->COLUMNNAME;
>}
It's returning an array, not an obj
>From: Perry, Matthew (Fire Marshal's Office)
[mailto:[EMAIL PROTECTED]
>I need some ammo to convince my boss not to use ASP but use PHP
instead.
>
>Anyone have some info I can give him?
If you want us to give you live ammo instead of blanks, we'll need more
details on your setup. There is a po
I have to admit, I've managed never to actually run into this - mostly
because I almost never use anchors:
http://www.faqts.com/knowledge_base/view.phtml/aid/317/fid/2
Counter-intuitively, it seems you have to toss the anchor at the end of
the get string. This works in my brief testing - and mor
-Original Message-
From: Chip Wiegand [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 11, 2004 3:28 PM
To: PHP DB
Subject: [PHP-DB] query of two tables returns too many rows, many more
than the two tables contain
I have two tables I want to get out the rows that are different between
t
Please note that his solution uses a subselect - and your version of
mysql may not support subselects. Subselects were introduced (I
believe) in Mysql 4.1
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily repre
I think (hope) that Rene was just trying to emphasize that while this is
a php mailing list - it is focused on databases. An array full of 0's
and 1's - while certainly data - hardly constitutes that.
I suggest a 'for' loop using 'count()' of the array, or perhaps
'array_walk()'. Store the keys
Does your tag have enctype="multipart/form-data" ?
e.g.
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
-Original Message-
From: Jacob Hacka
session_regenerate_id is what you're looking for
http://us2.php.net/manual/en/function.session-regenerate-id.php
Note that it keeps the session data, so you still need to
session_destroy if you want to purge the data.
- Martin Norland, Database / Web Developer, International Outreach x3257
The
Assuming, for the moment, that there's more code above that to actually support this...
You want to be quoting the keys in the array, and containing each array 'lookup' in
{}s:
print "$check[LNAME],$check[FNAME]($check[CID])";
Should be
print "{
Without thorough investigation, I can't be sure - but it looks like you
have a packaged development version (e.g. cvs or for compiling libraries
against) of php installed, and it's conflicting with allowing a
non-development version. You would probably be best served by actually
looking at the ava
You were on the right track with mysqldump. Windows doesn't have a
direct cron equivalent - but it does have the ability to schedule tasks.
Write a short batch file or equivalent (you should be able to whip one
together in no time with a little googling) and schedule it to run.
I doubt you'll fin
ysqli prepared statement query result sets
Norland, Martin wrote:
>The functions you want exist in php5, if that's an option:
>http://us2.php.net/manual/en/ref.mysqli.php ->
>http://us2.php.net/manual/en/function.mysqli-fetch-assoc.php
>
>
>
No this is not an option.
The functions you want exist in php5, if that's an option:
http://us2.php.net/manual/en/ref.mysqli.php ->
http://us2.php.net/manual/en/function.mysqli-fetch-assoc.php
Cheers,
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not
The point is it was a simple test case created to test if locking was
working, the results of which show that for whatever reason - it is not.
The point wasn't to make a meaningful script. He's obviously trying to
call a single script simultaneously, or work on a single database from
multiple scr
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html says
that's the right format. Are you sure you're storing the time and not
just the date? I'd wager that it will delete immediately if you are
only storing the date.
- Martin Norland, Database / Web Developer, International Outreach
Ah, good call. I'm too used to my database user matching my current
user from unixland.
(no, not root :P)
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital
If you're doing it interactively, you can just give it the -p flag and
it will prompt you.
Otherwise, I think the problem is you're overdoing it - the flag is
either "-p " or "--password=" followed by your password, so "-p mypass"
or "--password=mypass".
Also, I hope you meant you have been tryin
http://us2.php.net/manual/en/function.dba-open.php indicates (in an
entertaining little table) your second script should be in 'wait' status
until the first exits - so, the necessary logical questions (take no
offense):
1) are both scripts repeatedly printing their results, or does the
second not
What are the line endings of the file? Maybe php is getting confused.
How many KB is the file on disk when it's the ~1500 line version?
There's length of each line (which you want under 1KB, probably not a
problem unless you have BLOBS or equivalent) - and then there's how PHP
determines what a li
Check phpinfo() and see what options it was compiled with - at the very
least you need gd support (--with-gd) and probably need to specify
(--with-jpeg-dir) to point to jpeg libs. Aside from your configure
line, you should be able to see from perusing whether the image
functions are supported. If
I'm sorry - but performing a slight bastardization of Achems Razor is
the best way to solve this dilemma.
You have two web-based php applications that you have written yourself,
and you have a single user (and browser) who wants to access those
applications. The applications reside on the same we
You AND's limit the query - what you have there would only accept:
a equal to b,
AND at least one of b,c, or d must equal to $var1
AND with b not equal to 99,
So a=1 and b=1 and $var1 = 1 would work, but a=1 and b,c,d=1 and $var1 =
2 wouldn't.
If you want the 'or none' factor, just drop the en
There is only the one $_SESSION superglobal in PHP - and session_start
doesn't take any parameters - so the builtin sessions in PHP undoubtedly
aren't anticipating a need for this. If you are just trying to store
more data - you shouldn't have a problem, just use $_SESSION as an array
like normal,
$content = str_replace($crap,$clean,$submitted_text);
:)
(I hadn't even noted you missed any at first)
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
Without knowing the actual value of $var, it's hard to say.
Assuming the table 'frases' has the requisite fields (frases, palabras)
and your sql is indeed returning any results (are you trying to match
exactly, or do you mean to do "palabras like '%$var%'" instead of
"palabras='$var'" ?) - the onl
I don't pretend to know flashes interface, as I said before - but instead of naming
the variables differently - you should be able to pass them in an array.
&Lastname0=craw&Firstname0=david&Lastname1=Zarlanga&Firstname1=John
becomes
&Lastname[]=craw&Firstname[]=david&Lastname[]=Zarlanga&Firstname
You're talking two different users here - in my instance, I was talking
application users, not database users. Yes - realistically - you can
use just the one database and have the user permissions for it, it's
just a case of making sure you track everything right and don't access
the database thro
That all really depends on you. I would certainly say that, in general,
any given database should only have one users table (with a separate
table holding roles, permissions, etc.) In all likelihood - if all of
these systems will be working together within a single company, and be
built in a comm
t, and yes it shows more than 1 entry, but
i cant make flash to show them, im sure something on
flash must be wrong or missing, there is no fault on
the php code, so i might research a little more on the
flash part.
Do you know some good tutorial for this?
Thanks for your response.
Juan.
--- &
When the page refreshes, the data is reposted. You basically need to be
able to track whether this is happening, or prevent it from easily
happening.
One easy solution is to send a header("Location: somewhere-safe.php")
after a successful post. This way when the user hits refresh, it should
just
A quick glance says that's all perfectly right, I would run the query on the mysql
command line to be sure it's really giving more than 1 result - but I can suggest two
things:
1) be sure to mysql_free_result($result) afterwards if you're done with the query but
your script will still be doing
I'm posting to this list mainly because I'm not 100% sure that I have a
bug (who ever is, right?). I'm doing an export of some relational data
into XML, which amounts to many many queries in a database with the
information basically being written straight out. Initially it was done
using our own
96 matches
Mail list logo
