fer both Dynamite and Exan in one query to their
> respective tables? (One table is named exan and the other dynamite.)
>
> Thank you very much for your help.
>
> I have been searching google but can't find anything about this question.
>
> Karl
--
Niel Archer
nie
it does nothing except set
the error code and message.
See http://uk3.php.net/manual/en/pdo.error-handling.php
--
Niel Archer
niel.archer (at) blueyonder.co.uk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
e a separate configuration file for this setting the client to
use the plugin (enable-cleartext-plugin) then:
mysqli_options(MYSQLI_READ_DEFAULT_FILE,'myother.cnf');
to use those settings on the connection.
--
Niel Archer
niel.archer (at) blueyonder.co.uk
--
PHP Database Mailing List (h
?
>
> Regards,
>
> Pierre-Gildas MILLON
> pg.mil...@gmail.com
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
Niel Archer
niel.archer (at) blueyonder.co.uk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
$row['pd_description'] = nl2br($row['pd_description']);
>
> if ($row['pd_image']) {
> $row['pd_image'] = PRODUCT_IMAGE_DIR . $row['pd_image'];
> } else {
> $row['pd_image'] = WEB_ROOT . 'images/no-image-logo.png';
> }
>
> $row['cart_url'] = WEB_ROOT."cart.php?action=add&p=".$pdId."";
>
> return $row;
> }
>
> TIA
>
> Karl DeSaulniers
> Design Drumm
> http://designdrumm.com
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
Niel Archer
niel.archer (at) blueyonder.co.uk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
$rs_duplicates = mysql_query("select id from users where
> user_email='$_POST[email]'");
You should test $rs_duplicates !== false to be sure you have a valid
resource.
Have you tried retrieving the supposed row(s) and var_dump-ing them to
see what it thinks they are? M
--
Niel Archer
niel.archer (at) blueyonder.co.uk
> Hello phpers and sqlheads,
> If you have a moment, I have a question.
>
> INTRO:
> I am trying to set up categories for a web site.
> Each item can belong to more than one category.
>
> IE: Mens, T-Shirts, Long
. $row->name . '';
> }
>
> $db->close();
> ?>
>
> I get the error: *Fatal error*: Class 'MySQLi' not found in *C:\Program
> Files\Apache Software Foundation\Apache2.2\htdocs\a.php* on line *2
>
> *Please guide me as to how can I get rid o
gt; echo "";
> while($row = mysql_fetch_assoc($result)) {
>if($firstRow == 1) {
> echo "";
>
> foreach($row as $key => $value) {
> echo "" . $key . "";
> }
> echo "";
> $fir
re, and a older version, which would provide sqlite_open. Is
> that correct?
sqlite_open is not a PDO statement. It belongs to the PECL SQLite
extension. This extension is quite old and is superseded by the SQLite3
extension and/or PDO.
> Thanks!
>
>
> --
> PHP Database Mai
P to display the definitions in random order? OR Is there a
> way do this in mySQL that would mix and match results from different rows?
> This is the query gives me the 5 results
>
> SELECT `reference` , `word` , `explanation`
> FROM `Bible_dictionary`
> WHERE `live` =1
> ORDER BY RAND( )
> LIMIT 5
>
> Ron
>
> The Verse of the Day
> Encouragement from Gods Word
> http://www.TheVerseOfTheDay.info
--
Niel Archer
niel.archer (at) blueyonder.co.uk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Don
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
Could you show the actual code, not just the query. The way you are
setting up the query could be affecting it. i.e. using single quotes when
assigning to a variable
e, but not necessarily all, of the parameters and be
> able to output the results.
>
> Advice and help please.
>
> Thanks in advance.
>
> Ethan
First you need to protect your input from injection and other attacks.
http://en.wikipedia.org/wiki/SQL_injection
for the problem y
VALUES (col1Value1, col2value1,
colNvalue1), (col1Value2, col2value2, colNvalue2), ...
--
Niel Archer
niel.archer (at) blueyonder.co.uk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
> To unsubscribe, visit: http://www.php.net/unsub.php
--
Niel Archer
niel.archer (at) blueyonder.co.uk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ly needs a double backslash for O'Brien. One to escape the
apostrophe and one to escape the backslash escaping the apostrophe. ;-)
This would be because you're not using mysql_real_escape_string() on the
third parameter. Try this (not tested):
$sql_insert_registration = sprintf("INSERT INTO
Registrations (
Class_ID,
prid,
Registrant,
Company,
Phone,
Email
)
VALUES (%s, %s, '%s', '%s', '%s', '%s')",
$_POST[Class_ID],
$_POST[prid],
mysql_real_escape_string(parseNull($_POST['Company'])),
mysql_real_escape_string($_POST[Phone]),
mysql_real_escape_string($_POST[Email]),
mysql_real_escape_string($_POST['Registrant']));
--
Niel Archer
niel.archer (at) blueyonder.co.uk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
BY RAND()
> LIMIT 1
Try changing: "AND NOT `Bible_trivia_category_reference` = ( SELECT ..."
to "AND `Bible_trivia_category_reference` != ( SELECT ..."
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
-
> On Tue, May 18, 2010 at 2:51 PM, Niel Archer wrote:
> >> > Is there a different syntax to the mysql delete statement when the
> >> > "WHERE"
> >> > clause points only to half of the primary key?
> >> >
> >> >
gt;
> > Eli
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> Niel Archer
> niel.archer (at) blueyonder.co.uk
>
>
>
> --
> PHP Database Mailing List (http:/
rom the query too. See if that helps
> Error is a 1064 syntax error.
>
> Any help is appreciated.
>
> Eli
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
Niel Archer
niel.archer (at) blueyonder.co.
situation?
>
> All the best,
> Lawrance.
>
> "Any intelligent fool can make things bigger and more complex...
> It takes a touch of genius - and a lot of courage to move in the
> opposite direction." - Albert Einstein
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
Niel Archer
niel.archer (at) blueyonder.co.uk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ooks like
> $pdo = new PDO('pgsql:host=localhost;port=5432;dbname=mydb', 'dbuser',
> 'dbpass');
> (I think - I've yet to be able to debug it down to a single line)
--
Niel Archer
niel.archer (at) blueyonder.co.uk
--
PHP Database Mailing L
f but
> it is ignoring the .htaccess file.
>
> I've even tried putting the php.ini with specific settings in the
> /home/virtual/site#/root directory to no avail.
>
> Any ideas how to make this work or even a better set up?
>
> Thanks in advance.
>
>
&
UNION two SELECTs
http://dev.mysql.com/doc/refman/5.0/en/union.html
(SELECT col1, col2, col4 FROM table1 WHERE ... ORDER BY ...)
UNION
(SELECT col1, col2, col4 FROM table2 WHERE ... ORDER BY ...)
> --Aaron
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
Niel Archer
niel.archer (at) blueyonder.co.uk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
e but that does not seem to have helped.
> I have tried enabling: only mysql, mysql AND mysqli, and only mysqli. None of
> this seems to have done anything to change my situation.
>
> Again, I apologize for the lengthy message, I hope I have accurately
> described my issue in the right amount of detail.
>
> Thank You!
> Adam Sonzogni
>
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
Niel Archer
niel.archer (at) blueyonder.co.uk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ember/RQuadling
> >>
> >
> >
> >
>
> You've got odbc, but probably not a driver for MS Access.
>
> You need both.
>
> I can't seem to find a unix driver for MSAccess.
>
> Converting to a different DB would help (mysql, sqlite).
I had a
e second option will prevent older clients connecting, including
the mysql extension (but not mysqli) if it is not using the mysqlnd
driver.
More information can be found in the MySQL manual on upgrading from v4.0
to v4.1
http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-previous-series
several scripts like this scheduled to do basic maintenance work
or carry out automated tasks.
> Thanks,
> Vinay
--
Niel Archer
niel.archer (at) blueyonder.co.uk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
is persistent, so while the resource
IS saved, the connection to which it refers no longer exists.
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
Niel Archer
niel.archer (at) blueyonder.co.uk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi
you would do better to raise these issues on the internals lists, either
intern...@lists.php.net or internals-...@lists.php.net
--
Niel Archer
niel.archer (at) blueyonder.co.uk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ain a FROM clause, so MySQL tells you
there is no column called 'solarLandingDateTime' because you have no
table. This same problem applies to each part of your unions.
>
> John Butler (Govinda)
> govinda.webdnat...@gmail.com
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
Niel Archer
niel.archer (at) blueyonder.co.uk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
; So something really basic is missing in my understanding/code.
> > Can you see what it is?
> >
> > -Govinda
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
ndingDir, solarLandingDateTime
> FROM ".$whichTable.
> " ORDER BY solarLandingDateTime DESC
> LIMIT $Maxrecs2Show") or die("query failed: " . mysql_error());>
Oops, forgot to mention that with the alias you can change the ORDER BY
clause to use t
mysql_query("SELECT DISTINCT
DATE(solarLandingDateTime) AS solarLandingDate,
solarLandingIP, solarLandingDir, solarLandingDateTime
FROM ".$whichTable.
" ORDER BY solarLandingDateTime DESC
LIMIT $Maxrecs2Show") or die("query failed: " . mysql_error());>
If you are al
if my reading of the documentation is
correct. But as far as I can tell no escaping is performed on PDO::query
or PDO::exec other than what you do yourself, so you have the same risks
that need to be addressed.
>
--
Niel Archer
niel.archer (at) blueyonder.co.uk
--
PHP Database Mailing L
ute minimum you should be doing with any data you do not supply
yourself
> $query = mysql_query("INSERT INTO customers (`cust_first`,`cust_last`)
> VALUES ('$firstName','$lastName')");
>
>
>
> Ben Miller
BTW ereg functions are deprecated in PHP 5.3, so now
e to start looking.
You are mixing up several different methodologies in the example you
show.
More generally for MySQLi start here:
http://uk.php.net/manual/en/book.mysqli.php
It has links to the appropriate function references for the MySQL
Improved interface.
>
> --
> PHP Datab
ano Boragina _
>// Diseño & Comunicación //////
--
Niel Archer
niel.archer (at) blueyonder.co.uk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
> daniel.br...@parasane.net || danbr...@php.net
> http://www.parasane.net/ || http://www.pilotpig.net/
> Check out our great hosting and dedicated server deals at
> http://twitter.com/pilotpig
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
Niel Archer
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
he last 'id' column
generated, which you can then use to insert data into the secondary
tables.
>
> Im not to do a link between tables in PHPMyAdmin?
>
>
>
> Thank you very... VERY... much!
>
If you are using MySQL 4.1 or later you should use the mysqli extension
and
single time I loop through. Is there any way that I
> can run these statements error-free without having to close the select
> statement ($sth1) every single time I want to execute my update statement
> ($sth2)?
You do not initialise your statement object. I would guess this is a
large part of the problem, although I'm not that familiar with prepared
statements in MySQLi.
See the documentation for mysqli::stmt_init[1] and the example for
mysqli_stmt::prepare[2] in the php documentation.
[1] http://docs.php.net/manual/en/mysqli.stmt-init.php
[2] http://docs.php.net/manual/en/mysqli-stmt.prepare.php
> Thanks,
> Kevin
--
Niel Archer
niel.archer (at) blueyonder.co.uk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Kamil Walas
Check the file containing the first link again. '%5c%22' is the
characters '\"'. Seems you have escaped the double quotes in a single
quoted string
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
Niel Archer
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
these accordingly. You
may need to add an extra backslash to escape the backslash for
phpMyAdmin, I do not remember how that works with phpMyAdmin.
--
Niel Archer
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
COUNT returns the number of rows. I think they're after SUM
SELECT SUM(price) WHERE available = 1;
would total the values in the returned row's price column
--
Niel Archer
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ou should be checking the mysql_query call for success and output the
error if it fails. Something like:
mysql_query($sql) or die('Insert failed: ' . mysql_error());
You'll now why it's failing then. Make sure you have error reporting
enabled.
> Is this a compatability error? or is there a better way to write this?
>
--
Niel Archer
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi
You do not say how you identify the last call (there is no date/time
field for example), so a complete answer is not really possible
Do not use "NOT LIKE 'Completed'", it's an inefficient way of doing "!=
'Completed'"
--
Niel Archer
--
PHP D
d to do a join between the two tables using the common column to
make the connection. This should get you started
SELECT * FROM Table1 RIGHT JOIN Table2 USING (idequipomed) WHERE
Table1.idequipomed
IS NULL
--
Niel Archer
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi
> Does anyone know how to look for a "Curly quote" or "typographer's quotation
> mark".
Do you mean the equivalent of the left and right double quote entities
in HTML (or 66's and 99's as we called them at school)?
--
Niel Archer
--
PHP Datab
which involves using the
CR+LF+white-space combination to indicate multiple line entries. Is it
possible your e-mail header fields are doing this and your access to the
headers does not take this possibility into account? Without your POP
handling code it's impossible to say whether this is y
t; know why.
Dynamically changing the fields, I'm afraid I can't help. You would be
better trying a list dedicated to ajax.
--
Niel Archer
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
uld also process the City.name and City.vorwahl
results for NULL results where `zipcode` does not exist in the "City"
table.
--
Niel Archer
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Your variable value is not being inserted because you have used single
quotes for the echo, not double quotes as the nabble example does.
Special characters and variables are only interpreted in double quotes,
they are treated literally in single quotes.
--
Niel Archer
--
PHP Database Mailing
pt.
Without seeing the code, No!
--
Niel Archer
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
If I understood you correctly (and I'm not sure I did), this should do
it
$query="SELECT * FROM table WHERE listing_type LIKE '%$listing_type%'
AND listing_approved IN( '1' ,'2') ORDER BY name ASC";
--
Niel Archer
--
PHP Database Mailing List (htt
f there are
> only 4 rows in the table.
True, but if it was only ever going to have 4 entries in it I doubt he'd
be using a Db at all. I'm assuming this is just a sample.
--
Niel Archer
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
le. Assuming that 'Tune_Name'
contains unique entries for each row, I'd suggest you do the following
as a minimum:
ALTER TABLE Mobile_Tunes ADD PRIMARY KEY (Tune_Name);
--
Niel Archer
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
kage
to allow a Unix-Like environment.
You need a list like the developers one, where they're more
knowledgeable with building PHP/MySQL
--
Niel Archer
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi
On my way to bed so too tired too look closely, but at a guess I'd say
it's a logic error. I would guess this:
>$sid = mysql_fetch_array($query) || die ('Could not fetch from database:
> ' . mysql_error()); // <--- line 49
isn't evaluating in the order you expect.. You're using a lo
Hi
> mysql> select id,cat from table where cat=(select cat from table where id=51);
> +-+--+
> | id | cat |
> +-+--+
> | 40 | FLK |
> | 41 | FLK |
> | 42 | FLK |
> | 44 | FLK |
> | 45 | FLK |
> | 46 | FLK |
> | 47 | FLK |
> |
Hi
> O.K. the id column is primary key and it is auto_incerment .I think my
> explanation was not clear enough :
>
> this is my query : SELECT * FROM table WHERE ID=$ID
> this will find the record with the specified ID and I will be able to see
> it, now I want to be able to scroll up and
Hi
Seeing as no-one else has replied to this, I'll make a comment. First
off let me state I don't use PDO so I am not familiar with it.
It would appear to me that your "problem" line is NOT the problem. It is
only where the error is reported from. That line is a call to an object
method, so the
Hi
There is no DESTROYIMAGE() function. May be you mean imagedestroy(). If
so this does NOT erase files, it destroys in memory images created using
the Image functions.
To erase files use the unlink function. For detail look here
http://uk3.php.net/unlink
Niel
--
PHP Database Mailing List (
Hi
> Du you know a good tutorial for XML and RSS, possible relating with PHP.
Not a tutorial, no. I got my information from the specification
documents.
You should consider changing your method. Instead of creating the
RSS/XMl file manually, try using one of the PHP extensions that will
genera
Hi
> firefox tells me that it dislike the closing xml-tag.
> In my quanta-editor it seems that can be difficulties with the tagend of
> the opening xml-line of the second position of the questionmark.
Because you missed the space in front of it.
You really need to find out more about XML and RS
Hi
> ok by beginning the php-code with Unfortunately my RSSowl tell me that there must be other errors in the
> xml-formating. And I don't got a detailed information what RSSowl
> dislike in the xml-file.
Try opening it in a browser. Opera, for example, tells you what error it
encounters. That'
Hi
the first line is badly formed
Should be:
Niel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
http://dev.mysql.com/doc/refman/5.1/en/grant.html
Niel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi
Sounds like you do not have the required privileges with your user
account.. I suggest you spend some time reading the MySQL documentation
on privileges.
Are you using the root account? Have you created other user accounts and
given them the required privileges?
Niel
--
PHP Database Mail
Hi
> mysql -h localhost -u root -p 123456
should be:
mysql -h localhost -u root -p123456
notice no space after -p or it asks for the password.
Niel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi
> Imagine that you want to put some 2 historical photos On display in
> your website , you use PHP and MySQL.
> Preparing a photo album with 200 photos is no problem but for 2 photos!
> would you do it in the same way?
Yes, but I don't necessarily see the need for a db.
If y
Hi,
>
> In the function to connect to and select the database, I make the mysql-link
> resource a global value.
It sounds like you've misunderstood 'global' variable. The global
statement needs to go inside the function where you want to use the
variable, not where you assign it. This tells th
Hi,
see the docs for the date() function. 'I' returns 0 or 1 indicating
Daylight Saving Time. However, it does this based on the settings for
your installation. i.e. if your webserver is running on a host
configured to U.S. time zone, it'll give U.S. DST results.
Note that, any method will
Hi
> For example (see below), lets say I would like to use "public $one"
> property in a new class / method (such as class b)? What is the
> best way to accomplish this? Any help and or suggestions are welcome.
>
> class a {
> public $one;
>
> public function someMethod() {
>
Hi
> I have tried everything except of the one that forms the date in one field
> and use the DISTINCT for ip and date.
It works for me. I use it for essentially the same job, listing most
recent visit to a location (not IP, but physical venue).
Have you tried adapting it to your needs, such as
Hi
First, unless there is a compelling reason not to, I'd suggest you use
a single date field, instead of separate year, month, day columns. It
will be much more efficient on space and indexes.
Then, based on your own query, use:
SELECT DISTINCT ip, date FROM tracker WHERE page = 'index' ORDE
Hi
I've only had MySQL 4.1 running on 64 bit windows and PHP 5.x, without
any real problems when used locally. However, there seemed to be a
problem using the MySQL server via TCP/IP, hence the upgrade to native
64 bit version (v5.0), which was not desired at the time but seemed to
be the only fi
Hi
> I need urgent help. Have anyone successfully installed PHP 4 & MySQL 4.0 on
> 64-bit Windows?
Frankly, why would you want to? Neither are written for 64 bit. The
only versions I could find for 64 bit were the 5.x versions in both.
Which is what I run on my personal computer.
Niel
--
Hi
sorry, I misunderstood your problem, it was not too clear to me as the
code you list shouldn't produce the output you supplied.
try this:
$array = explode(',', $csv);
print "= " . $array[0] . "\n";
print "= " . $array[1] . "\n";
for ($i = 2; $i < count($array); ++$i) {
$txt.= "=" . $array[
hi
> the problem i have is.. how about the csv is a var
> DATA===
> $csv="
> A507257,3/2/2007,\"Hematologi Lengkap,Cholesterol Total,LDL
> Cholesterol,Trigliserida,HDL Cholesterol,Asam Urat,Gula Darah Puasa,Gula
> Darah 2 Jam PP,Kreatinin,Ureum,Bilirubin Total,A
Hi.
I don't know cPanel, but I expect it can run SQL directly, most panels
can. Use the ALTER TABLE ADD {INDEX|KEY} syntax to add indexes/primary
keys. You can use multiple columns, which together form a unique value
to create your primary key.
Niel
--
PHP Database Mailing List (http://www.
Hi all
Finally identified the problem. Was pretty obvious in retrospect.
The mysqli class (Improved MySQL extension OO style) defaults to
latin1 as a character set, regardless of what PHP is using. Simple
solution is to use the set_charset method (mysqli_set_charset for non OO) on
the object
Hi John,
I'd suggest searching within the Extra field instead of testing for the
value explicitly, as this field can theoretically hold several extra
pieces of information.
Niel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi
> Thanks for this. That page didn't actually help, but one of the follow
> ups did. Apparently, despite being setup as UTF-8 throughout the Db,
> tables, and columns. The returned data still can default to Latin1.
> I've forced my test server to return UTF-8 (I hope) and am trying it
> ou
Hi Chris.
Thanks for this. That page didn't actually help, but one of the follow
ups did. Apparently, despite being setup as UTF-8 throughout the Db,
tables, and columns. The returned data still can default to Latin1.
I've forced my test server to return UTF-8 (I hope) and am trying it
out t
Hi
Try using:
SHOW COLUMNS FROM db.table LIKE 'field_name%'
and from the returned row, check the 'Extra' column for 'auto_increment'
Niel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi
> I read ur reply on newsreader abou mysqli and if i can use it in PHP4
>
> My question is where can i find a link to download the mysqli extension
> separately without changing to PHP5
The MySQLi extension is available before PHP v5, but I couldn't tell
exactly which version it was introdu
Hi
> Alright, I did that. I now get :
> INSERT INTO domains ( picture, thumbnail ) values( '', '')
>
> and no data entered.
Then for some reason your variables are empty. Make sure they have data
on entry to the function. If they don't keep backtracking until you
find where it's lost.
Niel
Hi
you need to change this:
> $insert = 'INSERT INTO domains ( picture, thumbnail ) values( "$picture",
> "$thumbnail")';
to be:
$insert = "INSERT INTO domains ( picture, thumbnail ) values( '$picture',
'$thumbnail')";
variables are only interpreted inside double quoted strings. Within
single
Hi all
How is the character set of returned data effected? I have a DB using
UTF-8 encoding., PHP is set to use UTF-8 internally. However the MySQL
connection returns Latin1 data. How can I get it to return UTF-8 data
instead.
TIA
Niel
--
PHP Database Mailing List (http://www.php.net/)
To un
Hi
SELECT * FROM table INTO OUTFILE 'file_name'
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
Niel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi
> Hi, I would ask which way is more efficient and save time? Save each row to
> array or mysql_data_seek(0) ?
That totally depends on which resources are more valuable to you.
The array will likely use more memory but be faster to process.
While mysql_data_seek(0) would probably use n
Hi
> leaving me with the question: what does
> max_execution_time relate to? is it more like a maximum time without
> activity.
max_execution_time is the time php gets to execute code. From the
documentation: "The maximum execution time is not affected by system
calls, stream operations etc. P
Hi
is the syntax error reported for the php or the SQL? Better yet,
supply the actual error message, so we can see for ourselves
Niel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi
You have two functions between the if and else, the syntax you've used
only allows one. Use braces.
if(mysql_query($sql)) {
mail ($email, "Thank you for registering!", $body, "From:
[EMAIL PROTECTED]");
header("Location: thankYou.php");
} else {
die("Error! Could not insert values".m
Hi
> I'm running thru a result set using fetch_assoc. Now I want to run through
> it again.
>
> How?
Save each row into an array first time around, then reset the array
pointer to the beginning, would be one way.
Or assuming you're using the original MySQL functions, use
mysql_data_seek(0
Hi
Are you running this as CLI or from your web-server? If the latter, use
phpinfo() and check the max_execution_time isn't causing you problems.
Niel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
there's no 'logic' error at all that I can see. It's more a design
error as it doesn't do the job the way that you describe it at all.
What actually happens is that the starting HTML (heading and table
start) is output before the database is even contacted, so there's no
way for you to ta
Hi
use a LIMIT clause in your SQL. Something like:
$query="SELECT * FROM WHERE hello = '$hello' LIMIT " . ($page - 1) *
$rows . ", $rows";
then you only need specify the logic to set the page, row and
limitations
Niel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, v
Hi
button/hyperlink, no difference. It's the page that is target that does
the work
Niel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi
Your example data does have an "invalid field count" The first row has has
7 fields, the other 6.
So if you took them from your actual data that's your problem
Niel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
1 - 100 of 132 matches
Mail list logo