with line 91. It's also possible you forgot to add print/echo
before the statement on line 91.
4) you thought this was [EMAIL PROTECTED]
The T_STRING error is saying the php parser encountered a string where
it shouldn't have.
For gods sake, post code if you want help tracking errors p
however the libraries bit works, so you'd just need to find
the php mysql[i] windows library, driver, etc. whatever they call it.
http://www.php.net/downloads.php
Installing phpmyadmin is nothing, you just drop it in place essentially
- works fine with php5 and mysql4.1 here.
Chee
f you can get a .csv export of your database, you should be able to
bring that into access no problem. phpMyAdmin is able to generate such
a beast (access would probably prefer the 'excel csv export' - what with
microsoft and all) - and I'm sure many other programs can easily
gene
t - my apologies. I expect, however, that
you're not supposed to specify the key again with the update part,
though I suppose it's possible to.
Cheers,
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily rep
', descript='$data[3]', price='$data[4]',
unit_sale='$data[5]', unit_issue='$data[6]', weight='$data[7]',
brand='$data[8]', nla_tag='0' ON DUPLICATE KEY UPDATE;"
It's implicit that you use the same data regardless
rejected.
It's good to know that you can post O - T to a list, but if you dare
to indicate it as such (with the bracketed Oh-Tee indicator at the start
of the subject) as a service to those uninterested, your mail won't go
through. That's good policy - stomp on the good citizens and make
magine any reselling host wanting a shell/etc. account doing.
Cheers,
- 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.
--
PHP Database Mailing List (htt
well as any code which could be contributing
to it. It's best to cut and paste wherever possible - and if anything
must be 'hidden' to obviously hide it and make note of the replacement.
Just like Johan K# would do.
* K# name has been changed to protect the guilty - in m
literally "Table 'tablename' doesn't
exist" - then you're looking in the wrong code, and somewhere you have
code that says "tablename" instead of "$tablename". You may want to
grep for "tablename" to try to track that down.
Cheers,
- Martin Norl
e
a small general warning if the script on the whole doesn't match the
required database version - but still allow using the 'old' parts of the
site. That, however, may be more micromanagement than you want, so
maybe best just to make it an entire 'block' scenario.
The a
code.
*** Also -
$sched[] = array( 'teama' => $item[teama],
[] is for adding items to an array, just so you're aware. You're using
the foreach and that chunk of code in a very peculiar way, but I'm going
to hold off on wrapping my head around it until you
> -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,
, etc. - then you'll definitely want to be going
with the first way, hands down.
Summary (IMO):
Add some metadata rows [last updated, translation notes, etc.]
(as applicable) and stick with method 1.
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion
you should
NOT be directly accessing such things. Still, it will help you check if
you're sane.
I really REALLY don't recommend directly digging into a black box like
this unless you know it will never change, or have some good
documentation area where people will know to look before upgr
XXX);
Place all of those at the bottom of the script, and I suggest enclosing
them within tags, for legibility. (print_r is a slightly more
legible option, but var_dump gives us more information).
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained w
. Perhaps even run a
var_dump($->SelectLimit($query_rsVendorJobs)) to see just what
result you're getting back, although from your code it should exactly
match a dump of $rsVendorJobs.
Good luck, happy hunting
- Martin Norland, Database / Web Developer, International Outreach x3257
The o
s just the result of a mysql_query()? If so, you probably
just want to be using:
$to = $rsVendorJobs['Conmail'];
Also note - the case sensitivity may or may not be a problem (you may
need to use 'conmail')
Otherwise, let's see some code to flesh this out!
Cheers,
- Marti
bs->Fields('Conmail');
2) change
$body = '$cl';
To
$body = $cl;
3) from mail() docs
[this is just for reference, since you're only sending one header it's
probably not a problem]
"Note: You must use \r\n to separate headers, although some Unix mail
tran
ght be pushing it a bit. I
can't quickly find any mention of mysql and php3 on php's site - as it
relates to builtin support - but my skills in finding information there
may not be as honed as yours.
Sorry this got a little toasty, but it sure felt like a blind attack,
since the most curso
ed with mysql 4.1.3+ only,
and they have some neat new things like bind variables. I can't speak
as to whether one would gain performance from using mysqli_query over
mysql_query (though I would hope one wouldn't lose it!).
Cheers,
- Martin Norland, Database / Web Developer, Interna
to suffer from this
problem. I'm a little cloudy on the specifics, it's a big muddled mess
:)
Cheers,
- 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 Rese
ies to both the list for a non-db related post, and to anyone
whos client munges this up something fierce. Outlook will likely strip
the extra line feeds - click the little yellow box at the top for
legibility.
Cheers,
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s
dynamic class and variable coding, and ritualistically try to thunk
curlies around most everything.
> ps. I strongly recommend validating data before you insert into the db
I couldn't agree more.
Cheers,
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion
-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']}"
Varia
tively pointless
methods which I would be happy to detail to you for the low low cost of
3 easy payments of $29.95 USD.
Keep in mind, all of these are just deterrents - nothing that truly
prevents anything. For once my email disclaimer *really* applies.
Cheers,
- Martin Norland, Database / Web Deve
ase :)
- 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.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
red onto the urls.
Of course, I'm probably oversimplifying a problem you've fought hours
on, so all I can say is I hope the link and its thread shines some
light.
Cheers,
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this
adsheet Excel Writer:
http://pear.php.net/package/Spreadsheet_Excel_Writer
I'd wager it allows all the formatting you'll get from html tables.
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represen
y, not reload,
in case of post/etc.] is something that should at least reduce the
chances of massive overwrite errors. Not that I particularly approve of
that method :) It is, however, a relatively functional solution - if
you're stuck with neither of the above as being options.
- Martin Norlan
> 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
Correct - LIMIT 30,2 would show 2 records starting with the thirtieth.
:)
Enjoy the long weekend [and likely, given the day, your Thanksgiving!]
Woo, I'm outta here soon too.
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this ema
ame'$limit";
Then just pass the pagenum around. You'll probably want to pull another
query that just gets the count(), and use that and some basic math to
make the page range(s) to create hyperlinks.
Cheers.
- Martin Norland, Database / Web Developer, International Outreach x3257
The
lly fetches a single row (the next one, if
available) returned from the mysql query into an associative array.
You're being handed the data from mysql, one row at a time as requested,
and sticking it into an array. $result is actually the resource id that
you give mysql so it knows what query to give y
it.
E.G.
$resultset = array();
while (mysql_fetch_array($result) as $row) {
$resultset[] = $row;
}
Then just
foreach ($resultset as $row) { // or ($resultset as $rownum => $row)
// ... do stuff
}
Happy hunting.
- Martin Norland, Database / Web Developer, International Outreac
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 repr
certain my statements in the previous email were, in fact,
facts - not opinions :). At the very least, they were truthful
statements at the time of their writing - and not merely speculative
opinions.
Also - the round is referring to mathematical approximation, not
geometric shape :)
But, I
you: http://www.php.net/round
for example:
echo round(1.95583, 2); // 1.96
- 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.
--
PHP
y and refer to the items as
$rows["COLUMNNAME"] (or use single quotes).
- 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.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
PHP is definitely here to stay and
pretty mainstream.
- 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.
--
PHP Database Mailing List (http://www.php.
cks access log
Nope - anchor's aren't passed in the request. So, yeah - it's only used
by the browser. (That makes sense - the point of anchors is to go to a
spot within a page)
Neat, ya learn something new every day.
Cheers,
- Martin Norland, Database / Web Developer, Interna
=
You want to do a join on the two tables, and make it conditional upon a
known failing value (e.g. if when they DO match up, blackgate_users
shouldn't be NULL - make that your condition). That will return just
the rows in the first table that don't have a match.
cheers,
- Martin Norland
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
nload-docs.php
Keep on plugging, you'll pick it up!
- 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: peppe
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--
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 x325
print "{$check['LNAME']},{$check['FNAME']}({$check['CID']})";
However - in the future, try to include all relevant code. The surrounding table code
isn't important, but the code you're using for your query and to co
ing at the available packages and installing the ones you want,
instead of attempting to install php*. (or anything * for that matter)
Just my $0.03 (tax is killer these days!)
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this em
ou'll find a tool that does exactly what you want that's any
more advanced or configurable - there's just no need. That said - who
knows, people make all kinds of software to fill what others perceive as
unneeded.
Cheers,
- Martin Norland, Database / Web Developer, International Outrea
Wishful thinking on my part, since it specified no version info because
it was likely only in CVS - I thought maybe it was *really new* :).
That is unfortunate then, definitely. Perhaps a
mysqli_stmt_fetch_assoc() is forthcoming :(
- Martin Norland, Database / Web Developer, International
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
m
multiple scripts, but wants to make sure they don't hose his db file.
You do bring up a good point though - script 2 has the while loop
outside the connection, so it should only print its message once if
locking was working properly.
- Martin Norland, Database / Web Developer, International
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
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'
tput it to the cwd, then you just need to get it going to
C:\backup\file.txt - which may, or may not, be as simple as replacing
file.txt with that (long time since windows commandline)
Cheers,
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained withi
"wd" for both - but
that may not get you anything either. Strange behavior!
- 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.
-O
g files either on or created by a Macintosh computer, you
might want to enable the auto_detect_line_endings run-time configuration
option.
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude
. If you're using a packaged php, I would assume
these to already be enabled - strange.
The last comment on http://us2.php.net/function.imagecreatefromjpeg
suggests as much.
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email d
ome up with today should definitely scale to 3 or
more applications, otherwise you'll just have to rewrite 2 (or more!)
solutions later on down the line.
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily repre
to true - but
not both.
(but for a search, I doubt you want it XOR'd - no?)
-
You might want to be using LIKE instead of = if there should be
substrings.
http://dev.mysql.com/doc/mysql/en/SELECT.html (assuming mysql, though it
should be fairly vanilla SQL anyway)
- Martin Norland, Database
with another
address (e.g. www.something.com and app.something.com or equivalent) you
will, in effect, get your two sessions.
Beyond this, I'd need to know more of what you're intending to be of any
help.
- Martin Norland, Database / Web Developer, International Outreach x3257
The opini
$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 Researc
stead of
"palabras='$var'" ?) - the only other immediate problem I can see is if
you have a field named result or row in the frases table that is messing
with your script when you do your extract() call.
Curiously - why are you explicitly setting $_GET, do you not have the
abilit
a better way to be
populating this data.
http://actionscript-toolbox.com/samplemx_php.php
Seems to be an introductory that may be of some use, found just by googling for 'flash
php mysql'.
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained w
tion will need to
map its users to databaes users.
Come to think, however - I don't know that you can assign privledges
per-table in mysql. So, if your 'user levels' aren't strictly
hierarchical - you probably need to break things up (e.g. if payroll
shouldn't be able to acc
the benefits of having the data together (generally convenience, though
there are reasons along the lines of joins and such) with the costs of
any lost security or lax in responsibility.
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within th
you're doing - there is certainly
a better/preferred way to get this info into flash.
- 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.
-O
database.
You can obviously think of a million solutions - tracking sessions/pages
etc. - get creative to however will best fit or benefit your app!
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
th
just names, instead of names of new clients (e.g. you accidentally paste it
elsewhere for use and keep pulling only from the new clients table).
Are you perhaps storing clients in that table temporarily, so it rarely has many
clients in it? That could explain the behaviour as well.
- Martin Norlan
more reasonable :)
** no, it's not infinitely looping. It's dumping patient data, e.g. it
dumps a patient, a bunch of related records, and continues.
- 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.
Hi,
Like "phpBB" for newsgroups, "phpMyAdmin" for database administration. Is
there one for Organizer? Please advise!
Thanks,
Martin Lam
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Tue, 13 Jul 2004, Peter Westergaard wrote:
> I'm developing a site where I anticipate the need to make several updates to
> several forms, and I'll want to "commit" them all at once (i.e. if there's a
> failure with any of the transactions, I'd like to be able to back out to
> before I started)
On Fri, 9 Jul 2004, Peter Westergaard wrote:
>
> One idea that occurs to me, and it's a tradeoff from Torsten's idea (which
> is to read the whole database, and parse out the unique rows), is to first
> execute your "SELECT DISTINCT distinct_col FROM table", and then walk
> through that, and for ea
Hi
I'm looking for a php developer that is familiar with developing code for
client login/registration on the web and credit card transactions. (Not a
shopping cart model).
We're planning to use MySQL or Firebird on a linux server. The requirements
will probably extend to accounting system/billing
El Vie 21 May 2004 14:48, D. Sandmann escribió:
> Any help would be appreciated on this. I have already asked this question
> on the regular PHP and Informix news groups and have not had any luck.
> Maybe one of you can resolve my problem.
>
> I have had this problem in the past on another machine
x27;t access the properties
of the table in order to rename it, whatever I try to do I get an error
(which is obviously due to the type of name the table has).
Is there any way I can fix this without getting too complicated?
Cheers.
Martin
---
Outgoing mail is certified Virus Free.
Checked
El Vie 07 May 2004 22:49, Marcjon Louwersheimer escribió:
> Hi. I developed a forum using php5 and mysql. Right now I'm hosting it on
> my computer, for version for myself and another for a school I volunteer
> at. I would like to move the forums to the school's server. Apperently
> they don't have
El Wednesday 28 April 2004 03:21, Tumurbaatar S. escribió:
> I use pg_fetch_array() to get a record content. But it seems that
> to access elements of the returned associative array, I should
> use lowercase field names. Is there any way to use case-insensitive
> field names?
No. PHP is case-sens
r, or both?
I've thought of putting an option on the search for the user to select
'All Words' or 'Any Word' so that the select query could deal with the
search based on the full phrase they entered or any of the words.
My problem is how to build the query.
Any help would b
El Mié 14 Abr 2004 07:39, Tumurbaatar S. escribió:
> In PHP5 manual, it says that
> when using large objects functions
> of PostgreSQL, a program should
> manually begin/end transaction.
> But what about other query/exec functions?
> Do I need to control transactions or every function
> call implic
Does anyone know up to which level arrays in variables are possible? Is
there a limit?
$foo[1][2][3][4][5][6] ... ?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Got a dumb-ass question for you all. I have got insert queries working with
mssql_query($query); except if any of the variables have two or more words.
For example:
$myVar = "Two or more words";
$query = "INSERT INTO myTable VALUES ('".$myVar."');';
mssql_query($query,$db);
The query will only in
Mensaje citado por Muhammed Mamedov <[EMAIL PROTECTED]>:
> Thank you for your help Martin,
>
> I am aware of the seperation stuff you are talking. There is a much more
> professional term for that 'Design Patterns' use in JAVA (I tell you as a
> JAVA professional
Mensaje citado por stefan bogdan <[EMAIL PROTECTED]>:
>
>
> i have winnt 4.0 servicepack 6 + apache 2.0.47 + php 430 + informix client
> for nt
> ilogin demo works fine
> sql editor works fine
> but when i try to connect to informix via php i'get an error like
>
> Warning: ifx_connect(
Mensaje citado por Muhammed Mamedov <[EMAIL PROTECTED]>:
> Thank you for your comments Ignatius.
> (just to note) : I do not agree that all projects SHOULD require CLEAR
> sepeartion of code and appearance.
Let me disagree with you! :-)
I a multi-tiered design yuo have a client layer, a server la
Mensaje citado por Christine Clerc <[EMAIL PROTECTED]>:
> Well, I had tried this :
> SELECT DISTINCT id_script FROM readme WHERE id_language = $languageorignin;
> But then I have to do this with the selection :
> SELECT DISTINCT id_script FROM readme WHERE id_language != $languagetarget;
> but it
Mensaje citado por Daniel Sand <[EMAIL PROTECTED]>:
> Hi Folks,
>
> I have an generic question.
>
> first of all. The stuff runs fine.
>
> But ( the question ? )
>
> If i make any DB connections from any Virtual Server that i configured
> in apache, PHP always takes the Main Ethernet Interfac
Mensaje citado por Jason Wong <[EMAIL PROTECTED]>:
>
> Whilst there isn't a builtin database abstraction layer in PHP itself there
> are a number of projects which fills the gap. There's the semi-official
> PEAR-DB, also ADODB and Metabase.
Why is it you say it's semi-official?
I have always f
Mensaje citado por Malte Starostik <[EMAIL PROTECTED]>:
> Hi,
>
> I've read several posts touching this subject, but I didn't find one that
> asks a simple question I've been wondering about since I first used PHP and
> that is also one of the two really really bad things about PHP (the other
> b
El Mié 31 Dic 2003 16:25, escribió:
> He surelly has problems with his DB server.
> Does the script die? I am outputting mysql_error() nothing is showing up.
>
> Hows the mysql logs? I don't know where these are.
>
> is there some kind of high load on the DB server? I am the only one on it
right
El Mié 31 Dic 2003 15:28, Dennis Cole escribió:
> I think that it has more to do with the type of fields he is putting it
> into:
>
> --
> I am trying to build a web site for our inventory. I have a mysql DB
> that I Connect to. The following code is what I use. The array products
> wont go p-past
You throw code to the list with no information about what errors or warnings
you got. Why do you say it doesn't work? What happens when you run the
script?
El Mié 31 Dic 2003 12:46, John Greco escribió:
> I am trying to build a web site for our inventory. I have a mysql DB that i
> connect to.
>
El Jue 18 Dic 2003 18:27, John Greco escribió:
> I have a select statement that goes to my mySQL db and selects some data
> from there. I thought it was working great BUT it is skipping the first row.
> Any ideas? I know it has to be somehting simple I am missing.
Depends on how you are fetching y
El Mar 16 Dic 2003 10:44, Nikos Gatsis escribió:
> Hello list
>
> I have 4 variables, $check1, $check2, $check3, $check4
>
> How can i use a for loop to echo each one.
>
> (lets say echo $check($i)...)
foreach(list($check1, $check2,...) AS $c){
echo $c;
}
--
15:20:02 up 16 days, 21:36,
El Dom 14 Dic 2003 19:00, Daniel Crespo escribió:
> I have red hat linux with Apache web server and PHP. I want to connect,
> using PHP, to an Informix Database remotely. What is all I have to do on my
> side? Thanks a lot
Install informix client libraries where php will go and compile using
--wi
El Vie 12 Dic 2003 11:19, Gerard Samuel escribió:
> Im going to CC this to the PostgreSQL list also.
>
> On Friday 12 December 2003 06:44 am, Martin Marques wrote:
> > El Vie 12 Dic 2003 00:09, Gerard Samuel escribió:
> > > What good is this function?
> > > A qui
El Vie 12 Dic 2003 00:09, Gerard Samuel escribió:
> What good is this function?
> A quick example of the wall Im running into ->
> $sql = 'INSERT INTO .';
> $result = pg_query($conn_id, $sql);
> if ($result === false)
> {
> var_dump( pg_result_error( $result ) );
I would use here this:
El Jue 11 Dic 2003 05:30, Mike U. Petrov escribió:
> I tried to use GROUP BY and it worked almost right but i need to return
> user_id and mysql generated an error that notes.user_id isn't used in GROUP
> BY...
Add it to the GROUP BY.
--
16:33:02 up 15 days, 22:49, 4 users, load average: 0.03
El Jue 11 Dic 2003 05:17, Mike U. Petrov escribió:
> No, DISTINCT isn't match my purpose cause of it rerurns unique rows but I
> need ONE user_id per one object_id.
GROUP BY is your answer.
--
15:51:02 up 15 days, 22:07, 3 users, load average: 0.90, 0.75, 0.61
El Jue 11 Dic 2003 05:00, Muhammed Mamedov escribió:
> You can also DISTINCT command instead.
> UNIQUE command isnot supported by mySQL (at least at MySQL 3.23.41- I am
> using)
UNIQUE is for table creation or index creation. It is relevent for insertion,
not selects.
DISTINCT and DISTINCT ON() a
Sorry, just say the message.
> Your code looks well. But is the variable $db the name of your database or
> your link-identifier. When it is the name of your database i'm not really
> surpised your code wouldn't work. mysql_query requires as second argument a
> link identifier.
Read what Rolf say
201 - 300 of 473 matches
Mail list logo