Pull Data From A Table Using A While Loop
I noticed that when I pull data from a table using a while loop I am always missing the first entry in the set. To solve it for now I have placed a Dummy entry into the database, which works fine for simple lists but when the query begins to ask for any number of combinations of fields it seems like that is not a suitable fix.
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Using A Loop To Pull Data From Mysql Recordset
This has set me back a couple of days now and I could really use some help or at least a shove in the right direction. What I'm trying to do is list reviews in a database on a page, by artist (byartist.php). The first step is pulling each artist and listing them alphabetically. If the artist has more than one album reviewed, they should still only show up once, so I need to check each row of the recordset, and check the artistname against a variable or something, and if it exists, to just skip it and move on to the next row. Then I need to list the albums reviewed under each respective artists name and use them as links with url parameters to the respective review pages. I've got the recordset down per some advice from another newsgroup, and I'm fairly certain its correct for what I need to do. <?php require_once('conntest.php'); ?> <?php mysql_select_db($database_test, $test); $query_byartist = "select artists.artistid, artists.artistname, areviews.albumid, areviews.atitle from artists join areviews on artists.artistid = areviews.artistid"; $byartist = mysql_query($query_byartist, $test) or die(mysql_error()); $row_byartist = mysql_fetch_assoc($byartist); $totalRows_byartist = mysql_num_rows($byartist); ?> The php example I was given for pulling the results was kind of half-effort and not enough for me to really see what was going on, understand it and build upon it. I'm (obviously) just starting out with php/mysql and I'm pretty good at building upon something in front of me and figuring it out, just need a little help because I've tried it over and over and to no avail, I wind up with syntax errors. Sorry for the wordy post, I didnt want to skimp. Thanks for any help or advice or any points in the right direction. I've got about 3 days of progress to catch up on
View Replies !
View Related
Resource Id #3 - Pull Out Data From My Table
I am trying to pull out data from my table. I know there are some records there, but when I tried the following code: $query = "SELECT * FROM logpage WHERE user = '$user_name'"; $result = mysql_query($query); echo "result is ", $result, "<br>"; I got "result is Resource id #3".
View Replies !
View Related
Script To Pull Data From SQL Table
I'm running a php-enabled dedicated server. All my sites on said server incorporate simple php scripts (includes, month/date, etc.) and that's the extent of my php knowledge. Some of my sites have SQL databases which I administer via phpmyadmin, but I've been unable to track down a simple php script to: * open the database * refer to a specific table * extract data from the table * display the data on a website Can anyone point me to an online doc or provide a simple script to follow which I can customize for my purposes?
View Replies !
View Related
Multiple Table Pull
$result = mysql_query("SELECT $tb1.fname FROM $tb1, $tb4 WHERE $tb1.email = '$T1' AND $tb1.pass = '$T2' AND $tb1.unum=$tb4.unum",$db) or die(mysql_error()); $_SESSION['myfname'] = mysql_result($result,0,"$fname"); The error I get is: Warning: mysql_result() [function.mysql-result]: not found in MySQL result index 6 in /home/xratedda/public_html/loginout.php on line 39 I know, it looks like I am only grabbing one thing and don't need different tables, but I am trying to figure out how to do this with just one item, before adding the rest.
View Replies !
View Related
Creating Table Rows For Ever Other Loop In A WHILE Loop
I'm trying to create a table using a MySQL fetch array while loop that would look like this: CONTENT1 CONTENT2 CONTENT3 CONTENT4 CONTENT5 CONTENT6 I need a <TR></TR> for every other piece of content. But I don't know how to do this with a loop that uses a MySQL fetch array while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { PHP CODE THAT IS LOOPED;}; I'm trying to remember from my old college Java class that we did something with loops for whenever the counter variable was even the loop would do something special... I don't know if this is possible with a while+mysql_fetch_array loop though.
View Replies !
View Related
Pull Data Out Off Mysql
I am making a database using mysql where i have 2 tables, one for car manufacturers and one for car models.I've already done that. I have made a php page where i have 2 drop down menus. The first menu shows car makers(manufacturers) and the 2nd nothing. Now when a user opens the 1st menu and selects a maker , the 2nd automatically fills up with models from that car maker only and it gets its information from the database.That is every time i decide to add a new model to my database the 2nd menu (if selected) must go and search the database for all the models for that maker and show them. Code:
View Replies !
View Related
How Do You Pull All Data From A Field?
How do you pull all data froma field no matter what its result.. like this.. results.php?city=$city&type=ALL&zone=$zone so where type=all i want to get all restaurants in whatever $city in whatever $zone, meaning chinese, mexican, all rest listed in persay newyork zone 1 what is the wildcard to pull that..
View Replies !
View Related
CURL To Pull Data From A Site
I've been using php and cURL to pull data from a site, and things worked just fine. however, when i used the same script to access a different site, not data is being returned. however, i can go to the url of the site being used and there is clearly html there which should theoretically be scraped. any idea why it is not being gathered and how can i fix this?
View Replies !
View Related
Pull Data From A Second Sql Query Using A Where Clause
I am trying to pull data from a second sql query using a where clause = two fields from the first query. I am trying to gather from the second query, any data where we have a match from either of the two in the where clause. sql=my select 1,2 from t1 while $row { $one=$row[1]; $two=$row[2]; sql=select 1,2 from t2 WHERE 1 = '$one' or 2 = '$two' group by 1,2 while $row2 { //trying to output all rows that either 1 or 2 from t2 match 1 or 2 from t1. so all grouped results from 1 display all unique results in 2all grouped results from 2 dispaly all unique results in 1 where either 1 from t1 = 1 from t2 or 2 from t1= 2 from t2.
View Replies !
View Related
Pull Data From MySQL Database
I'm running a PHP script called phpOnDirectory on thsi website i'm creating so that people can have their companies listed in our directory. Currently, the script displayes the directory in a left-hand column, and the results in the center column. When you access a category, the script displays the number of listings withing that category in parenthesis next to the title. What my client wants is to take that out(easy enough) and have the totals listed next to the categories on the left. Code:
View Replies !
View Related
Using The Mysql_fetch_array Function To Pull Data In As An Array.
Im currently pulling in a load of data from my sql table. I found that using the mysql_fetch_array function was the way to pull it all in as an array. The only problem? I cant manage to get it to store a value into another name eg $ip = $row['ip'] and count how many instance's are contained within it. I need to do similar things to the 'url' and the 'time' but as I cant access the data there isnt much I can do!
View Replies !
View Related
How To Pull 1 Line Of Data From A File? NO MYSQL
I have this file that has 2 lines in it. Heres how the files looks. file: fbddata.lbn line1:uncle1234562 line2: As you can see, on line 2 there is actually no data but the file still seems to have a 2 lines. But when I pull the info from the file using the "include" or "require" command it just pulls the 1st line of data. BUT..when I try to use the "include" or "require" php commend within a HTML link code like this.... <a herf="www.mysite.com/Lavishphpfreak/<?php include("fbddata.lbn" ?>/ilovephp.php>LINK[/url] it gives me a link that this... http://www.mysite.com/Lavishphpfreak/uncle1234562 /ilovephp.php now did you notice the code that was added to the link. I have figured out that its doing this because of the blank line 2 thats in the fbddata.lbn im trying to pull the data from. Of course the easy way to fix this would be to just go into the file and delete the blank like 2 but i can't do this because i dont have permission to edit the file. Its created using "root". So does anyone know of a php code that will just pull the 1st line of data from within a file. I can't use mysql cause this is NOT in a database..and plus I haven't advanced to databases yet.
View Replies !
View Related
Mysql_Fetch_array(); Pull An Array Of Data From Mysql
im trying to pull an array of data from mysql. this is the code im using. PHP Code: //the sql syntax below pulls the last 7 records from the database $sql     =    "SELECT * FROM db_news ORDER BY 'id' DESC LIMIT 7"; $query    =    mysql_query($sql) or die('MYSQL QUERY ERROR' . mysql_error()); while($row = mysql_fetch_array($query)) { echo $row['id']; } the code above outputs 'id's' 7 to 1 as 7654321. what i want to do is explode the 7654321 into an array so i can call them any where on the page. and not just while the while loop is running, complicated ? what im trying to do is grab the latest 7 news reports from mysql and then display them in certain places on a webpage.
View Replies !
View Related
Mysql_fetch_array Way To Pull Out All The Data, Store It In An Array
I have a webpage which runs repetitive queries agaist a database in order to extract one item at a time and then put the items in an HTML table. The reason for this is formatting, plus the page hits 4 databases. Instead of running multiple queries pulling one item at a time...is there a way to pull out all the data, store it in an array, and then pull individual items from the array with php as I want to insert them in the table? So, example is Code:
View Replies !
View Related
Pull Data From Database And Show It In Forms
I have created an online survey form for my boss about one of his course. He needs his students to do the evaluation for a topic when he finishes each topic. For example, when he finished topic 1, he told students to evaluate topic 1. Two weeks later, when he finished topic 2, he asked the students to evaluate topic 2, so on. I created the survey form with radio buttons and I would like each student can keep his own record for the previous topic. For example, when it is time to do the evaluation for topic 2, when he opens the survey form, he can see his reply for topic 1. Code:
View Replies !
View Related
Main Page Database Seems To Not Pull Any Data At All.
I have a page that has a connection to a database. I also call a function that makes a connection to a new database, outputs some data and closes. The problem: When I call the function, the main page database seems to not pull any data at all. Im using all new database connection variables and closing them. Still the main connection stops working.
View Replies !
View Related
Pull Data From Mysql Db And Break This Into An Array
I am trying to pull data from mysql db and break this into an array that I can then pull certain bits of data from, hope this makes sence to someone. PHP Code: $dbh=mysql_connect("localhost", "$username", "$code") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("$database"); $query = mysql_query("SELECT * FROM `allflights` WHERE id='$callsign' ORDER BY date DESC LIMIT 5") or die (mysql_error()); I would like to place like data for say these five items so I can have them stored in arrays and then select the different data as needed from each one.
View Replies !
View Related
Pagination Query - Pull The Data From The Database
I'm trying to paginate some query results but when I click on "next" to go to the next set of results, the query fails. Here's what I'm using to pull the data from the database. PHP Code: $sql="SELECT id, student_id, first_name, last_name, address, city, state, zip, DOB, gender, grade, aka FROM student WHERE last_name LIKE '".$_GET['last']."%' and current_student='yes' ORDER BY last_name LIMIT $offset, $rowsPerPage";     $conn = db_security_connect();     $result = mysql_query($sql,$conn);     $query   = "SELECT COUNT(*) AS numrows FROM student WHERE last_name LIKE '".$_GET['last']."%' and current_student='yes'";
View Replies !
View Related
Pull Data From The Database And Generate A Normal Text File
I have a database that is correctly storing characters like the trademark symbol, copyright,ect. I then pull data from the database and generate a normal text file from it. I do not do anything other then echoing out the direct database info into a variable and then building the file from the variable. When I open the text file, ALL my trademarks, copyright, apostrophies, anything other then alphanumeric becomes question marks. "?" I have no idea how to fix this. Can anyone lead me in the right direction on what needs to be done to fix this. The database charset is 8859-1 I beleive, and my html pages are also 8859-1 and also render the data wrong, same "?"
View Replies !
View Related
Insert Into Table Using For Loop
i managed to get bits a pieces and managed to get this script to nearly work. I put together this script which a)gets a no. of fields to create 2) creates those fields 3) on submission it checks for blank fields & may display error msg 4) also it checks in the db for duplicates & may display error msg 5) if all good it submits to db. Here comes my dilemma. 1, 2, 3 and 4 work fine however the final part 5 doesnt work at all. 5 works if 3 and 4 are taken away for some reason. I am sure there i am missing something. Can someone please take on the challenge and direct me to where i could be going wrong. PHP Code:
View Replies !
View Related
Table Layout With For Loop
What I am trying to do is layout an html table with the contents of an array using a "for loop". My array has 50 filenames of images in a folder, and I am trying display the images in a table layout that is 5 columns by 10 rows. Laying the table out in one column was easy. I just can not seem to come up with a solution for a way to get my array layed out into the 5 columns. I have been round and round with it, and do not seem to be able to get my head around it for some reason. I have currently been trying to use two "for loops" to get it done, but It seems to me that it should be able to be done with just one ? If someone has a few minutes free, I would be very greatful for their assistance.
View Replies !
View Related
Loop In A Specific Table Row
I'm building a site for motorcycles and I used mysql + php for it. I've split the bikes to categories like: Ducati, KTM, Husqvarna, etc. the categories table is like this: Code: cat_id int(10) primary (Categotry ID) cat_name varchar(200) (Category Name) cat_type varchar(100) (Category Bike Type: Superbikes, Sport, Enduro, Supermoto, etc.) Here's an example record: cat_id 1 cat_name Ducati cat_type Superbikes, Sport .......
View Replies !
View Related
Using PHP To Sort Data In MySQL Table 1 By Values In Table 2
I have a MySQL database with 2 tables in it. products and prices.. Products has a field in it called 'prodno'. Prices has a field in it called 'prodid'. There is one of each item in products and each product has it's own unique 'prodno' There are multiple instances of each product's pricing in prices.. One for each price.. So if a product had multiple prices depending on quantity it would have an entry for each price.. Example: id = 1 prodid = 7001 qty = 300 price = 12.5 id = 2 prodid = 7001 qty = 400 price = 15.5 I was wondering if I could query the database getting info from the products table but sort it according to the prices in the prices table. Kinda like doing a "SELECT * FROM products" ordering it by the lowest price value from each item.. This is all very confusing to me, and I'm the one writing it. Let's try one last time.. Query the database selecting * from products (I plan on using all the info in products) and ordering them by the lowest price for each item in the prices table. I've tried sorting the results of just a basic SELECT * FROM products using Javascript and PHP but with pagination in the results it makes it a bit hard.
View Replies !
View Related
Showing Data From A Table Based On Infos From Another Table!
i have 2 tables in my database : THREAD, and POST THREAD's rows are: THREADID, TITLE + FORUMID + REPLYCOUNT + VIEWS POST's rows are: THREADID, PAGETEXT and PARENTID i'm a big php newbie... I want to display the LAST TWO messages (highest THREADID) of my forum number 99 (FORUMID=99). I can probably do that, but the problem is that the text of the message is located in another table.. and it's getting too hard for my low-skilled brain lol so basically I would like to check in "THREAD" for the highest THREADID where FORUMID=99, display the TITLE, REPLYCOUNT and VIEWS, and then check in POST for the same two THREADID's where PARENTID=0 (meaning it is the first message in the thread) and finally display the PAGETEXT ! Could anyone give me a PHP code that would display that?
View Replies !
View Related
Loop Displaying Rows In The Table
For some reason, the loop in the code below isn't working. It is only editing the first row in the table, not all the rows. PHP Code: <? require ( "connection-file.php" ); $teams_rs = $conn->Execute ( "SELECT * FROM wv_tm_test ORDER BY tm_id ASC" ) or die ( $conn->ErrorMsg() ); $team_rating = $teams_rs->Fields("tm_rating"); $team_id = $teams_rs->Fields("tm_id"); while ( ! $teams_rs->EOF ) { Â Â Â Â Â Â Â Â $team_rated = $team_id; Â Â Â Â $new_rating = $team_rating - 0.346Â Â + 0.5; Â Â Â Â $new_rating_1Â Â = number_format($new_rating, 3, '.', '');Â ..................
View Replies !
View Related
Loop To Print Formatted Table From Sql Results
I'm trying to create a 3 column table now, and each cell will contain info from a single record. All the records will be pulled from a mysql database. What makes this a bit difficult is that I want the center column to be blank. Only the first and third columns will contain the results. I can't get the desired effect, and I'm not sure my loop logic is even correct. Does anyone know what's wrong with my code? Code:
View Replies !
View Related
Update Table While Insert Data To Another Table
it seem like mine coding din work. [php]<? include("checkin.html"); $conn=mysql_connect('localhost','root','') or die ('Could not connect to server'); $today = date("Y.m.d"); mysql_select_db('hms', $conn); $ok = mysql_query("INSERT INTO check_in(ID,room_no,datein)values ('$ID','$room','$today')", $conn); if( $ok ){ $up = mysql_query("UPDATE studtable SET checked = 'checkin' where [ID] = '%ID'); if(mysql_affected_rows( $up ) == 1) { echo'Checked IN!' }else { echo'No such student to check in' }} else { echo'Check In FAILED, please check again'}?>[php]
View Replies !
View Related
Loop Through Data
I'm developing an appliocation that pulls data from two databases: one is MySQL, the other is Sage Line 100 (via ODBC). I'm familiar with extracting data and displaying the resulting recordset, using either: PHP Code: while ($row_rsList = mysql_fetch_array($rsData)) //for MySQL data or PHP Code: while ($row_rsList = odbc_fetch_array($rsData)) //for ODBCL data Because the Sage ODBC driver is very flakey, I've created a couple of duplicate tables in MySQL, into which I import the ODBC data from time to time. The idea is that I can check to see if the ODBC link is available, and if not, use the backup data from MySQL. To do this, I simply check whether odbc_connect returns an error, and if so, use MySQL instead.
View Replies !
View Related
Display Data Without While Loop
Can data in the database be displayed without using a while loop. Obviously only one record will get displayed. mysql_select_db("db", $con); $result = mysql_query("SELECT * FROM details"); while($row = mysql_fetch_array($result)) { echo $row['FirstName'] . " " . $row['LastName']; echo "<br />";}
View Replies !
View Related
Loop Not Returning All Data
I print the resulting array (useRow[]), the first row of results is not printed. I think maybe it's the 'while loop' as $totalRows does indicate the correct number of rows in the table and all the returned data in $row is correct. It's just missing a record. (the table only has 5 rows and 4 columns) $query= "SELECT * FROM myTable ORDER BY someField DESC"; //Connect to and query the database $db=mysql_select_db($database_Con, $Con); $results=mysql_query($query, $Con) or die(mysql_error()); $row=mysql_fetch_assoc($results); $totalRows= mysql_num_rows($results); //Get the results as an associative array and put each row into the numerically indexed array $useRow=array(); while($row=mysql_fetch_assoc($results)){ $useRow[]=$row; } print_r($usedRow);
View Replies !
View Related
While Loop For Retrive Data From DB
Below is my php script for retrive data from database and allow user click on the 'Edit' button (each record have a button at the end of row)for editing the record data. $request=mysql_query("SELECT * FROM stock ORDER BY category, code",$db); echo"<form name="stock" action="stock/modules/" method="post">"; echo"<table border="1"><tr><td>Category</td><td>Code</td><td> </td></tr>"; while($row=mysql_fetch_array($request,$db)){ $id=$row["id"]; $category=$row["category"]; $code=$row["code"]; echo"<tr><td>$category</td><td>$code</td><td><INPUT TYPE="hidden" NAME="id" VALUE="$id"><INPUT TYPE="SUBMIT" NAME="op" VALUE="Edit"></td></tr>"; } echo"</form>"; I can retrive the data well, but the 'id' value attached with each button always cache with the id of my last record, hence I always edit the wrong record. I think that is some problem with my while loop, but I can't find it out. Anyone can help? Any mistake with my script? Any tutorial/ example?
View Replies !
View Related
Move Data From One Table To Another Table
I am learning PHP and MySQL so i want to create a simple submit form. Suppose there are 3 test boxes how do i insert the data entered in the text boxes in to the mysql table when the user hits the submit button. Also in PHP how can i "move" data from one table to another table.
View Replies !
View Related
While Loop To Extract Data From Mysql
I am using the following code to extract from mysql a users shopping basket. What i want to be able to do is to get all the information that is displayed by the while loop and be able to submit all that information in a hidden file: ie <input type="hidden" name="desc" value="$whatever"> $whatever being the information generated by the while loop. while ($row=mysql_fetch_array($sq1_result)){ $code=$row["CODE"]; $description1=$row["DESCRIPTION"]; $cost=$row["COST"]; $quantity=$row["QUANTITY"]; $price=$row["PRICE"]; $total=$row["TOTAL"];
View Replies !
View Related
Pulling Out Data From Mysql In A For Loop
I have to sql tables the first one (listings) has a field called towns, in the towns field their are numbers which relate to the actual town names on the other table. 01 = Lincoln 02 = London 03 = Manchester Etc etc My problem is this... I can get the town names (from towns) using the id (the numbers from listings) perfectly, and the for loop all works fine, but i need to arrange the towns in alphabetical order. Of course currently the for loop just echo's out in the order in which the data is in the table. PHP Code:
View Replies !
View Related
Continuous Loop For Mysql Data
while($Def_Start = mysqli_fetch_array($Def_Start_Query, MYSQLI_ASSOC)) { $Def_Options[] = $Def_Start['User_ID'];} this is looping endlessly, untill it reachs the index of $Def_Options[9999] whats wrong, there are only 21 records in the database?
View Replies !
View Related
|
TRACKER
