MySQL/Php query only returning one record?
The code below is returning only ONE record. I want it to return ALL records that meet the query... It should return ALL records whose "team" field equals the value of $tm...
The $tm value is being passed through the url string and grabbed via a GET statement. I echoed the $tm and it is working properly.
------- code
$sql="SELECT * FROM schedules WHERE team LIKE '".$tm."' ORDER BY date";
$result=mysql_query($sql) or die(mysql_error());
$count=mysql_num_rows($res
while($rows=mysql_fetch_ar
echo '<tr><td>';
echo $rows['opp'];
echo '</td><td>';
echo $rows['loc'];
echo '</td><td>';
echo $rows['date'];
echo '</td></tr>';
}
Please review and help...
The $tm value is being passed through the url string and grabbed via a GET statement. I echoed the $tm and it is working properly.
------- code
$sql="SELECT * FROM schedules WHERE team LIKE '".$tm."' ORDER BY date";
$result=mysql_query($sql) or die(mysql_error());
$count=mysql_num_rows($res
while($rows=mysql_fetch_ar
echo '<tr><td>';
echo $rows['opp'];
echo '</td><td>';
echo $rows['loc'];
echo '</td><td>';
echo $rows['date'];
echo '</td></tr>';
}
Please review and help...
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
$sql="SELECT * FROM schedules WHERE team LIKE '*".$tm."*' ORDER BY date";
$sql="SELECT * FROM schedules WHERE team LIKE '%".$tm."%' ORDER BY date";
I tried both above - still only get one record?
$sql="SELECT * FROM schedules WHERE team LIKE '%".$tm."%' ORDER BY date";
I tried both above - still only get one record?
ASKER
$sql="SELECT * FROM schedules WHERE team LIKE '%".$tm."%' ORDER BY date";
is working!!!!!!!!!
is working!!!!!!!!!
$result = mysql_query("SELECT * FROM schedules WHERE team LIKE '%$tm%' ORDER BY date") or die(mysql_error());
$count = mysql_num_rows($result);
while ($rows = mysql_fetch_array($result))
{
echo '<tr><td>';
echo $rows['opp'];
echo '</td><td>';
echo $rows['loc'];
echo '</td><td>';
echo $rows['date'];
echo '</td></tr>';
}
ASKER
Why does it need the '%" in front of and behind the var?
ASKER
Fast response = happy customer...
% means it will match all the values which having the word n that var
For example
if var value is 'ab'
then values will match like
ab
sssabfff
For example
if var value is 'ab'
then values will match like
ab
sssabfff
% is a wildcard and is used with LIKE and typically meant for database searches. LIKE can be slow on large databases so it's always best to use indexes and exact phrases where possible.
ASKER
What if I want to add a second parameter? I understand the % but I want the sport var to be an exact match...
This works for one parameter:
$sql="SELECT * FROM schedules WHERE team LIKE '%".$tm."%' ORDER BY date";
This is not working for two:
$sql="SELECT * FROM schedules WHERE team LIKE '%".$tm."%' AND sport='%".$sport."%'ORDER BY date";
This works for one parameter:
$sql="SELECT * FROM schedules WHERE team LIKE '%".$tm."%' ORDER BY date";
This is not working for two:
$sql="SELECT * FROM schedules WHERE team LIKE '%".$tm."%' AND sport='%".$sport."%'ORDER BY date";
ASKER
Sorry I will post this as a NEW question so there is credit distributed...
% only works with LIKE operator, not with = operator.
Change "sport = ..." to "sport LIKE ..."
Change "sport = ..." to "sport LIKE ..."
PHP
PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.
125K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
$sql="SELECT * FROM schedules WHERE team LIKE '*".$tm."*' ORDER BY date";
Ss