I’m assuming your grids are all exactly the same size, and are arranged in a perfect rectangle, as indicated by your image. How about storing all grids in a simple 2D array? You can then find the index of any grid by doing grid_size = 30; index_x = math.floor(user.x/grid_size); index_y = math.floor(user.y/grid_size); 4 solved What … Read more
Your query should look like this: $insertData = “INSERT INTO facebook (fdId, fullName, email, dob, location, gender, postId) VALUES (‘”.$fbId.”‘,'”.$fullName.”‘,'”.$email.”‘,'”.$new_date.”‘,'”.$location.”‘,'”.$gender.”‘,'”.$postId.”‘)”; mysql_select_db(‘noskunk1_facebook’,$vdb); $result = mysql_query($insertData); if ($result)) { echo “New record created successfully”; } else { echo “Error: ” . $insertData . “<br>” . mysql_error($vdb); } but consider using pdo 3 solved error mysql_query() expects parameter … Read more
No there isn’t. start looking for somthing called Web Crawler to get specific info from a specific site. solved Search specific info on internet and save it in a database [closed]
You can’t make HTML directly interacting with database. You should create server-side application, which answer queries generated by HTML forms, JS queries, etc. I am PHP developer, I like this language, so I recommend you using it in your solution. You can read about connecting PHP to MySQL database here: http://www.w3schools.com/php/php_mysql_connect.asp There you have basic … Read more
Without seeing the data, lets make some assumptions: A pass is awarded for a subject if the marks obtained for that subject are equal to or more than 50% of the total marks available for that subject. The name of the table is called Enrollment To return a list of students who have passed at … Read more
I don’t understand the need of your “reports” table,… If I was you I’ll use only ShowData() with the query, like this public void ShowData() { con = new SqlConnection(@”Data Source=LAPTOP-KA7UGSG3;Initial Catalog=JAPoultry;Integrated Security=True”); con.Open(); da = new SqlDataAdapter(“SELECT Variety, SUM(Quantity) FROM Inventory GROUP BY Variety”, con); dt = new DataTable(); da.Fill(dt); dgv_Reports.DataSource = dt; } … Read more
If you really want to do this, you need to invent some sort of joining column. Variables can be used for that: select q1.name as car, q2.name as colour from (select @row := @row + 1 as r, name from car, (select @row := 0) q) q1 inner join (select @row2 := @row2 + 1 … Read more
With the help of STR_TO_DATE and DATE_FORMAT function you can achieve this: SELECT DATE_FORMAT(STR_TO_DATE(dateUs,’%Y%m%d’) + INTERVAL HourMins+0 >= 1200 DAY ,’%Y%m%d’) AS dateLoc FROM your_table Demonstration: SET @str := ‘20160919’; SET @HOUR := ‘1215’; SELECT ( STR_TO_DATE(@str, ‘%Y%m%d’) + INTERVAL (@HOUR + 0) >= 1200 DAY ) AS date, DATE_FORMAT( STR_TO_DATE(@str, ‘%Y%m%d’) + INTERVAL (@HOUR … Read more
Store now() in a variable and then compare using where clause. Also see this and this Update :<?php $timeZone=”Asia/Kolkata”; //variable for indian timezone date_default_timezone_set( $timeZone); //default timezone set to indian time $now = date(“m/d/y G.i:s”); echo $now; ?> Check for date functions in PHP 2 solved Select database where datetime>now()? [closed]
<?php $conn = mysql_connect(‘localhost’, ‘mysql_user’, ‘mysql_password’); if (!$conn) { die(‘Could not connect: ‘ . mysql_error()); } mysql_select_db(‘database’); $result = mysql_query(‘select URL from table’); if (!$result) { die(‘Query failed: ‘ . mysql_error()); } echo mysql_result($result, 0); // outputs mysql_close($conn); ?> 0 solved How to get a particular cell from MySQL table using PHP? [closed]
when you run a DELETE command, I believe nothing is returned, thus you can’t mysql_fetch_array(). You would normally use that if you’re doing a SELECT. in this case, you’re deleting something, so just remove that loop, and echo(). solved php mysql_fetch_array() error [duplicate]
You can try like following using GROUP BY and UNION ALL. select count(*) CT,Mark from TableName group by Mark union all select Count(*), ‘A+B’ as mark from TableName where mark in(‘A’,’B’) UNION ALL select Count(*), ‘A+C’ as mark from TableName where mark in(‘A’,’C’) union all select Count(*), ‘B+C’ as mark from TableName where mark in(‘B’,’C’) … Read more
your code mysql_query(“UPDATE prestataire SET (login=’$a’, passe=”$b” , email=”$c”,nom=’$d’, prenom=’$e’, adresse=”$f”, ville=”$g”, tel=”$h” )WHERE login = ‘$a’ )”); try like this $sql = “UPDATE prestataire SET (login=’$a’, passe=”$b” , email=”$c”,nom=’$d’, prenom=’$e’, adresse=”$f”, ville=”$g”, tel=”$h” )”; $request = mysql_query($sql); better way $sql = “UPDATE prestataire SET passe=”$b” , email=”$c”,nom=’$d’, prenom=’$e’, adresse=”$f”, ville=”$g”, tel=”$h” WHERE login=’$a'”; You … Read more
Have you tried listing everything you think relates to the database, then removing the ones you don’t like, then grouping them in a way that makes sense to you or users of the database? Certification types, access to bodybuilding books, bodybuilding trainers, ease of super sets, free weight ratios, ratings from heavy lifters, etc. Try … Read more
This question does not really belong here, but I’ll answer it for the sake of closing the question without bothering moderators. // mysql query is executed $images = mysql_query(“Select URL from images where Category = ‘Management’ “); // empty array initialized $imagerow = Array(); // while there are results of the executed mysql query while … Read more