-
Replied To a Post in Query/Array to table display
How about this $query = "Select coach_career.coach_career_id, coach_career.pid, coach_career.league_id, coach_career.club_id, coach_career.season, coach_career.pos, coach_career.games, coach_career.wins, coach_career.losses, coach_career.draws, coach_career.fingames, coach_career.finwins, coach_career.finlosses, coach_career.findraws, coach_career.gfgames, coach_career.gfwins, coach_career.gflosses, coach_career.gfdraws, coach_career.totgames, coach_career.totwins, coach_career.totlosses, coach_career.totdraws, coach_career.win_ratio, club.club, … -
Replied To a Post in Query/Array to table display
forget it please check following works or not I have put your new summation code before closing table tag $query = "Select coach_career.coach_career_id, coach_career.pid, coach_career.league_id, coach_career.club_id, coach_career.season, coach_career.pos, coach_career.games, coach_career.wins, … -
Began Watching Query/Array to table display
Not sure exactly how to ask the question of what Im trying to do but will try explain it and insert the code. But the basics of the question is … -
Stopped Watching Query/Array to table display
Not sure exactly how to ask the question of what Im trying to do but will try explain it and insert the code. But the basics of the question is … -
Replied To a Post in datagrid-php
Dear Diafol, I learned from you. I always read your answers. Though I am still learning -
Replied To a Post in Query/Array to table display
To avoid complexity, You may also try with another approach 1) query list distinct leagus of partiular pid 2) loop through leagues found above 2.1) find deatils of coaching for … -
Replied To a Post in export mysql query to excel in php
Change export.php as following Problem is in your clean function, it expects database connection. so I have put connection first then function then rest of code. <?php $host="localhost"; $uname="root"; $pass="Unknown"; … -
Began Watching datagrid-php
how to pass selected datagrid text value to other php page message box ?? -
Replied To a Post in datagrid-php
Pass values in hidden form elements Post form to next page make use of $_POST array to read values on next page -
Replied To a Post in Query/Array to table display
Kindly check following works or not I have added league in order by and bring table heading rows inside loop with conditions $query = "Select coach_career.coach_career_id, coach_career.pid, coach_career.league_id, coach_career.club_id, coach_career.season, … -
Replied To a Post in Query/Array to table display
so on the top of table, you want to show league name, and details will follow right? -
Began Watching Query/Array to table display
Not sure exactly how to ask the question of what Im trying to do but will try explain it and insert the code. But the basics of the question is … -
Replied To a Post in Query/Array to table display
I dont think when you add records then you need to create separate code for new records. > League_id is from another table wich is likely to be added to … -
Replied To a Post in export mysql query to excel in php
One way is to keep 2 separate files one part line number 1-16 1) export.html <html> <head><title>Exports</title> <link rel="stylesheet" href="css/css.css" /> <h2>EXPORT DATE/YEAR</h2></head> <form action="export.php" method="post" target='_blank'> <table> <tr> <td><input … -
Began Watching export mysql query to excel in php
I have this code below for export mysql database to excel..however, if i run this it will only export the html code of the page not the sql query..please help..thank … -
Replied To a Post in need help getting this login form to work right
your method is post (see line no. 3) so changed line number 49,50 $myusername=mysqli_real_escape_string($con,$_POST['name']); $mypassword=mysqli_real_escape_string($con,$_POST['password']); change line 62 (if $row[0] has some value of id, means not blank) if($row[0]!="") -
Began Watching need help getting this login form to work right
I cant seem to get this login form to work right I have the login form come up and i can use it to get to the form.php page that … -
Began Watching How to create multiple pages using single Code in PHP ?
Anybody can explain about my question i have search over the web but never find right answer ? -
Replied To a Post in How to create multiple pages using single Code in PHP ?
I assume you mean code reusability. If so, you need to learn to develop class and use them as and when required in muliple pages -
Began Watching Problem in Updating PHP MYSQL data through a textarea field
i had some trouble when updating a mysql field, i had 2 text fields and 1 textarea fields, both the text fields updated ok through this query: but textarea field … -
Replied To a Post in Problem in Updating PHP MYSQL data through a textarea field
Try this way <textarea name="newscontent" cols="30" rows="10" id="newscontent"> <?php echo $row['newscontent']; ?> </textarea> -
Replied To a Post in MySql Query - Number of orders per customer
I am writing sample query select a.id_customer, b.firstname,b.lastname, count(*) total_orders from orders a inner join customer b on a.id_customer=b.id_customer group by a.id_customer b.firstname,b.lastname -
Replied To a Post in Cannot modify header information
put all require php in the begning of page together, with out any line or space also include phpgraphlib.php in the begninng too -
Replied To a Post in Cannot modify header information
You need to put whole code here so that we can find problem -
Began Watching Cannot modify header information
I'm new at this language and I can´t understand this warning: Warning: Cannot modify header information - headers already sent by (output started at /Applications/AMPPS/www/.../users.php:316) in /Applications/AMPPS/www/.../phpgraphlib.php on line 213 … -
Replied To a Post in get free number between x and x
I suggest to create one master table say, total slots slot_master slot_id 1 2 3 4 5 6 7 8 9 another table is the one you are using allocated_slot … -
Began Watching get free number between x and x
Hello, I need for my game inventory function a mysql query which checks the next available free slot id. example: I have item on slot 1, 2, 3 and 5. … -
Began Watching how to access javascript function remotly from another project
me have two projects now me want to call the function 0f one project an another project for example me have project A and B in A there are a … -
Replied To a Post in how to access javascript function remotly from another project
write your common function in one .js file say you have written your javascript code in project a like /webroot/projecta/js/myfuction.js Now you want to access that same file in another … -
Replied To a Post in how to check to see if value is already in database before inserting new
I changed your if condition at line 22 , if row count == 0 then means record does not exists with number, so show insert when $row[0]==0 , otherwise show … -
Began Watching how to check to see if value is already in database before inserting new
hey i have this code that always evaluates to true but it should only in the case of there being a value in the database i have selected, maybe im … -
Replied To a Post in how to check to see if value is already in database before inserting new
Use following clause update when duplicate http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html -
Replied To a Post in convert varchar to datetime
I assume your database is mysql select str_to_date(string_date_col, '%M %d, %Y') from tblTransaction Str_to_date function will change string to date type http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_str-to-date -
Began Watching convert varchar to datetime
hi. how can i convert string format to datetime: the string is formatted like : December 01, 2010 (which is another table) tblTransactions and the datetime column format is : … -
Began Watching Incorrect DATE values
I have this code, where I want to get inclusive dates between two dates. Date1 is the date to day and Date2 is the date after 7 days. I am … -
Replied To a Post in Incorrect DATE values
You can also try directly using pure mysql query without php $result = mysqli_query($connection, "SELECT os_no, total, balance, discount, date_order, date_pickup, time_pickup FROM order_customer WHERE DATE( date_pickup ) BETWEEN DATE_SUB( … -
Replied To a Post in PHP user profile
https://phpacademy.org/ -
Began Watching Open a new tab and preview document to print
Hello. I just thought of adding the js print function to a page im building. from what i read i know it is pretty straight forward, use window.print. i was … -
Replied To a Post in Open a new tab and preview document to print
I hope this may help you. You can do that using css http://www.w3schools.com/css/css_mediatypes.asp -
Began Watching PHP List script with details page?
Hi all, I hope this is the right place to ask I've been searching high and low for a script that I cannot seem to find. I'm looking for a … -
Replied To a Post in PHP List script with details page?
I guess, You have to do on your own. If you are not developer then you may post this question in business exchange forum. You will find so many who … -
Replied To a Post in Undefined index warning in php+mysql
remove line 26 to 28 in your html code, your html elements and submit button must be under same form element. You have ended form early </form> <br> <form action="insert.php" … -
Replied To a Post in Undefined index warning in php+mysql
if you see line 22, 23, 24 all input names are in small letters firstname lastname age and in your php handler code in your first post its in title … -
Replied To a Post in Undefined index warning in php+mysql
Post your html code also -
Replied To a Post in Log In Student With Unique Id
I am changing 4 lines of your student_login_handler.php Line 7 $query = "select student_id,last_login_date from student_information where learner_id='$learner_id' and student_password='$student_password'"; Line 16 $_SESSION['user_id'] = $date['student_id']; Line 19 mysql_query("UPDATE student_information SET … -
Began Watching Undefined index warning in php+mysql
This code is to create a simple database to insert records into a table ... but the table appears to be empty with the following errors after entry>> errors: Notice: … -
Replied To a Post in Undefined index warning in php+mysql
Reasons: 1) Your html part is not having LastName , Age elements properlly spelled 2) Your input method may be GET instead of POST -
Replied To a Post in WHERE !=
SELECT * FROM `users` WHERE ( uid not in (select friend_two from friends where friend_one='$uid' ) and uid not in (select friend_one from friends where friend_two='$uid' ) ) -
Replied To a Post in WHERE !=
post your structure and sample data here -
Replied To a Post in WHERE !=
I guess problem is in your join LEFT JOIN friends F ON U.uid=F.friend_one You already joing uid with freind one , with that query you willl never receive result. can …
The End.