I have a query that I expect to return 3 or 4 entries -- but I seem to be
getting only the most recent entry, repeated 4 times. What am I doing wrong
here?
$query="SELECT artistID,email,city,state,country from artists WHERE
email='$email'";
$result=mysql_query($query) or die(mysql_error("Could not execute
query."));
if (mysql_num_rows($result) > 0){
$alreadylisted = "1";
echo "<CENTER>$email is already in our database. Are you listed
below?</CENTER><BR>";
while($row = mysql_fetch_array($result)) {
$artistID = $row['artistID'];
$email = $row['email'];
$city = $row['city'];
$state = $row['state'];
$country = $row['country'];
echo "<CENTER><HR><FONT size=\"2\" face=\"Arial, Helvetica,
sans-serif\">
<A HREF=\"javascript:;\"
onClick=\"openProfile('artist.php?artistID=".$arti stID.
"','Artist','resizable=yes,width=600,height=300')\ ">".$firstname."
".$lastname."</A><BR>"
.$city.", ".$state." ".$country."</FONT><BR></CENTER>";
}
echo "<HR><CENTER>If you are already listed above,
congratulations!<BR>
If needed, you may edit your listing using the link at
left.</CENTER>";
mysql_free_result($result);
}
Thanx,
Wm 4 2779
try echoing your query to screen so you can read exactly what is being sent
to the database beforehand.
--
Warren Butt
-- Custom web design, cheap like cheese
"Wm" <LA*******@hotmail.com> wrote in message
news:1h*********************@news.easynews.com... I have a query that I expect to return 3 or 4 entries -- but I seem to be getting only the most recent entry, repeated 4 times. What am I doing
wrong here?
$query="SELECT artistID,email,city,state,country from artists WHERE email='$email'"; $result=mysql_query($query) or die(mysql_error("Could not execute query.")); if (mysql_num_rows($result) > 0){ $alreadylisted = "1"; echo "<CENTER>$email is already in our database. Are you listed below?</CENTER><BR>"; while($row = mysql_fetch_array($result)) { $artistID = $row['artistID']; $email = $row['email']; $city = $row['city']; $state = $row['state']; $country = $row['country']; echo "<CENTER><HR><FONT size=\"2\" face=\"Arial, Helvetica, sans-serif\"> <A HREF=\"javascript:;\" onClick=\"openProfile('artist.php?artistID=".$arti stID.
"','Artist','resizable=yes,width=600,height=300')\ ">".$firstname." ".$lastname."</A><BR>" .$city.", ".$state." ".$country."</FONT><BR></CENTER>"; } echo "<HR><CENTER>If you are already listed above, congratulations!<BR> If needed, you may edit your listing using the link at left.</CENTER>"; mysql_free_result($result); }
Thanx, Wm
"DjDrakk" <Dj*****@drakkradio.servemp3.com> wrote in message
news:vj************@corp.supernews.com... try echoing your query to screen so you can read exactly what is being
sent to the database beforehand.
Warren Butt -- Custom web design, cheap like cheese
echo "Query result = ".$result;
yields this output:
ArrayQuery result = Resource id #21
I'm not sure where the word "Array" is coming from, nor what the "Resource
id #21" is.....????
Wm "Wm" <LA*******@hotmail.com> wrote in message news:1h*********************@news.easynews.com... I have a query that I expect to return 3 or 4 entries -- but I seem to
be getting only the most recent entry, repeated 4 times. What am I doing wrong here?
$query="SELECT artistID,email,city,state,country from artists WHERE email='$email'"; $result=mysql_query($query) or die(mysql_error("Could not execute query.")); if (mysql_num_rows($result) > 0){ $alreadylisted = "1"; echo "<CENTER>$email is already in our database. Are you listed below?</CENTER><BR>"; while($row = mysql_fetch_array($result)) { $artistID = $row['artistID']; $email = $row['email']; $city = $row['city']; $state = $row['state']; $country = $row['country']; echo "<CENTER><HR><FONT size=\"2\" face=\"Arial, Helvetica, sans-serif\"> <A HREF=\"javascript:;\" onClick=\"openProfile('artist.php?artistID=".$arti stID.
"','Artist','resizable=yes,width=600,height=300')\ ">".$firstname." ".$lastname."</A><BR>" .$city.", ".$state." ".$country."</FONT><BR></CENTER>"; } echo "<HR><CENTER>If you are already listed above, congratulations!<BR> If needed, you may edit your listing using the link at left.</CENTER>"; mysql_free_result($result); }
Thanx, Wm
"Trent Stith" <tr****@airmail.net> wrote in message
news:bg********@library2.airnews.net... You need to echo the query itself, not the result of the query.
echo "<pre>"; echo $query;
that will return what your query is actually doing it may shed some light.
I pasted the lines above in after the query and got this result output to
the browser:
"Array ad*****@hotmail.com is already in our database. Are you listed below?"
I'm still not sure why I'm getting the word "Array" output, nor why I don't
see the query that I'm trying to verify. And I'm still getting the same info
output 4 times rather than 4 separate listings, but I'm sure that's a
different problem... <groan>
Thanx,
Wm
************************************************** ********
ORIGINAL MESSAGE(S):
************************************************** ******** "Wm" <LA*******@hotmail.com> wrote in message news:oL***********************@news.easynews.com.. . "DjDrakk" <Dj*****@drakkradio.servemp3.com> wrote in message news:vj************@corp.supernews.com... try echoing your query to screen so you can read exactly what is being sent to the database beforehand.
Warren Butt -- Custom web design, cheap like cheese
echo "Query result = ".$result;
yields this output:
ArrayQuery result = Resource id #21
I'm not sure where the word "Array" is coming from, nor what the
"Resource id #21" is.....????
Wm "Wm" <LA*******@hotmail.com> wrote in message news:1h*********************@news.easynews.com... > I have a query that I expect to return 3 or 4 entries -- but I seem
to be > getting only the most recent entry, repeated 4 times. What am I
doing wrong > here? > > $query="SELECT artistID,email,city,state,country from artists
WHERE > email='$email'"; > $result=mysql_query($query) or die(mysql_error("Could not execute > query.")); > if (mysql_num_rows($result) > 0){ > $alreadylisted = "1"; > echo "<CENTER>$email is already in our database. Are you
listed > below?</CENTER><BR>"; > while($row = mysql_fetch_array($result)) { > $artistID = $row['artistID']; > $email = $row['email']; > $city = $row['city']; > $state = $row['state']; > $country = $row['country']; > echo "<CENTER><HR><FONT size=\"2\" face=\"Arial,
Helvetica, > sans-serif\"> > <A HREF=\"javascript:;\" > onClick=\"openProfile('artist.php?artistID=".$arti stID. > > "','Artist','resizable=yes,width=600,height=300')\ ">".$firstname." > ".$lastname."</A><BR>" > .$city.", ".$state." ".$country."</FONT><BR></CENTER>"; > } > echo "<HR><CENTER>If you are already listed above, > congratulations!<BR> > If needed, you may edit your listing using the link at > left.</CENTER>"; > mysql_free_result($result); > } > > > Thanx, > Wm > > >
Ok insert the echo "$query" line in the following places where indicated
with 'echo', that's how you should isolate the problem to one line of code:
"Wm" <LA*******@hotmail.com> wrote in message
news:1h*********************@news.easynews.com... I have a query that I expect to return 3 or 4 entries -- but I seem to be getting only the most recent entry, repeated 4 times. What am I doing
wrong here?
echo
$query="SELECT artistID,email,city,state,country from artists WHERE email='$email'";
echo
$result=mysql_query($query) or die(mysql_error("Could not execute query."));
echo
if (mysql_num_rows($result) > 0){ $alreadylisted = "1"; echo "<CENTER>$email is already in our database. Are you listed below?</CENTER><BR>"; while($row = mysql_fetch_array($result)) { $artistID = $row['artistID']; $email = $row['email']; $city = $row['city']; $state = $row['state']; $country = $row['country']; echo "<CENTER><HR><FONT size=\"2\" face=\"Arial, Helvetica, sans-serif\"> <A HREF=\"javascript:;\" onClick=\"openProfile('artist.php?artistID=".$arti stID.
"','Artist','resizable=yes,width=600,height=300')\ ">".$firstname." ".$lastname."</A><BR>" .$city.", ".$state." ".$country."</FONT><BR></CENTER>"; } echo "<HR><CENTER>If you are already listed above, congratulations!<BR> If needed, you may edit your listing using the link at left.</CENTER>"; mysql_free_result($result); }
Thanx, Wm This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Polar |
last post by:
I am having troubles finding the parse error in this script. I've been
checking for weeks. I am too new to the subject I guess.
I am trying to show a readord and them have a form at the bottom...
|
by: johnnyboy10017 |
last post by:
I am having a hell of a time with what I think is a very simple query:
It won't actually insert a new record into the specified table, but
returns no error, in fact it returns "1" (or true) that...
|
by: jaysonsch |
last post by:
Hello!
I am having some problems with a database query that I am trying to do.
I am trying to develop a way to search a database for an entry and
then edit the existing values. Upon submit, the...
|
by: Nick Truscott |
last post by:
<?
// scoreinput.php - input a match score when match selected from list
?>
<html>
<head>
<basefont face="Verdana">
</head>
<body>
|
by: Mattyboy |
last post by:
Guys
I have built a database with saved queries that runs fine in Access
but when I call it from the web using ASP, an exception occurs. I
have tried multiple ways of testing the databases with...
|
by: Martin Lacoste |
last post by:
Ok, before I headbutt the computer... don't know why when I add
criteria in a query, I get an 'invalid procedure call'. I also don't
know why after searching the help in access, the various access...
|
by: Alan Lane |
last post by:
Hello world:
I'm including both code and examples of query output. I appologize if
that makes this message longer than it should be.
Anyway, I need to change the query below into a pivot table...
|
by: deko |
last post by:
When using OutputTo with a query, the 'File name' window in the 'Output To'
dialog gets populated with the name of the query by default. This makes the
exported file self-describing if the query...
|
by: Arpan |
last post by:
I have always been working with SQL Server 2005 for ASP.NET apps but
due to some reasons, had to revert back to MS-Access 2000.
When I try to insert/update a MS-Access DB table (MDB), ASP.NET...
|
by: Kelii |
last post by:
I've been trying to get this piece to work for a few hours, but have
given up. I hope someone out there can help, I think the issue is
relatively straightforward, but being a novice, I'm stumped....
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |