Building a query to fetch an array SOLVED
Posted by:
John Dow
Date: September 24, 2012 02:30PM
So this is a newbie question from a real newbie.
Im working with xampp (localhost server), php (phpMyAdmin), MySQL, jQuery
I have two PHP files built an index.php and data.php. I have created a webpage using html with a search box that grabs data from the database and uses impute data a retrieve data when a 'get' button is pressed. TThe data reurnted is the data they search (titled 'clli') and a related data(titled 'pointcode').
My issue is if the clli has multiple items that are the same , with different pointcodes, I cant may a mysql_fetch_array work. I have only been successful retreiving a single set of data.
<?php
mysql_connect("localhost", "root", "");
$clli = mysql_real_escape_string($_POST['clli']);
if ($clli==NULL)
echo "Please enter an 11 digit CLLI code!";
else
{
$pointcode = mysql_query("SELECT pointcode FROM database1.tester1 WHERE clli='$clli'" );
$pointcode_num_rows = mysql_num_rows($pointcode);
if ($pointcode_num_rows==0)
echo "CLLI code does not exist!";
else
{
$pointcode = mysql_result($pointcode, 0);
echo "$clli = $pointcode";
}
}
?>
Edited 1 time(s). Last edit at 09/25/2012 06:29PM by John Dow.
Subject
Written By
Posted
Building a query to fetch an array SOLVED
September 24, 2012 02:30PM
September 24, 2012 04:33PM
September 24, 2012 09:03PM
September 24, 2012 10:05PM
September 24, 2012 10:15PM
September 24, 2012 10:34PM
September 25, 2012 05:24AM
September 25, 2012 06:28PM
September 26, 2012 08:59PM
September 25, 2012 10:46PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.