Skip navigation links

MySQL Forums :: PHP :: Building a query to fetch an array SOLVED


Advanced Search

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.

Options: ReplyQuote


Subject Written By Posted
Building a query to fetch an array SOLVED John Dow 09/24/2012 02:30PM
Re: Building a query to fetch an array Barry Galbraith 09/24/2012 04:33PM
Re: Building a query to fetch an array John Dow 09/24/2012 09:03PM
Re: Building a query to fetch an array Barry Galbraith 09/24/2012 10:05PM
Re: Building a query to fetch an array John Dow 09/24/2012 10:15PM
Re: Building a query to fetch an array Barry Galbraith 09/24/2012 10:34PM
Re: Building a query to fetch an array laptop alias 09/25/2012 05:24AM
Re: Building a query to fetch an array John Dow 09/25/2012 06:28PM
Re: Building a query to fetch an array Rick James 09/26/2012 08:59PM
Re: Building a query to fetch an array Barry Galbraith 09/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.