You have used mysql_connect() in the update clause of the code. If your PHP version is 7 and above it will not work (will work for 5.5 and 5.6 versions but with a warning) as it is deprecated. Warning This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the … Read more
Please use below code to fix your problem <?php if(empty($_POST[‘username’])){ $username_error = “Please Input Username”; }else{ if( 6 > mb_strlen($_POST[‘username’]) || 20 < mb_strlen($_POST[‘username’])){ $username_error = “username must be at least 6 characters.”; }else{ $username = $_POST[‘username’]; $sql = “SELECT members.username FROM members WHERE username=””. $username.”””; $res = mysql_query($sql); if($res && mysql_num_rows($res) > 0){ $username_exists … Read more
In the line $open = fopen(“http://quote.yahoo.com/d/quotes.csv?s=$symbol&f=sl1d1t1c1ohgv&e=.csv”, “r”); You need to substitute the actual symbol, not leave it as a string in the query. Maybe something like this: $open = fopen(“http://quote.yahoo.com/d/quotes.csv?s=”.$symbol.”&f=sl1d1t1c1ohgv&e=.csv”, “r”); to concatenate the symbol will help. If you have an invalid request, you are probably looking at garbage. Also – you need to make … Read more
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 5 solved You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near … Read more
NOTE : Since order is a reserved keyword you can use any other name for the column This can be achieved by taking order column in your table. For Eg: id taskname order 1 firsttask 1 2 firsttask 2 3 firsttask 4 4 firsttask 3 5 firsttask 5 Then while fetching get it order by … Read more
Try this: <?php $games_sql = “SELECT id,col1,col2,now FROM tblname ORDER BY now ASC LIMIT 9”; $sth = $conn->query($games_sql); $sth->setFetchMode(PDO::FETCH_ASSOC); $gn=0; while ($game_get = $sth->fetch()) { $id = $game_get[‘id’]; $col1 = $game_get[‘col1’]; $col2 = $game_get[‘col2’]; $now = $game_get[‘now’]; $gametimeanddate = jdate(“l d M y time G:i”,$now); $gamedate = jdate(“l d M y”,$now); $gametime = jdate(“G:i”,$now); //SAVE … Read more
You could use the RIGHT() part of the string filtering wher the firts is a number eg: SELECT right(my_column, LENGTH(my_column)-1) FROM my_table WHERE my_column REGEXP ‘^[0-9]’ for update (remove the number ) you could use Update my_table set my_column= right(my_column, LENGTH(my_column)-1) WHERE my_column REGEXP ‘^[0-9]’ 1 solved How to remove first letter if it is … Read more
Yes, condition is a reserved word as of MySQL 5.0. Your original Create Table works because you can use ` to quote reserved words for use in table/field names. Works: SELECT * FROM `condition`; DROP TABLE `condition`; # etc. Doesn’t: SELECT * FROM condition 0 solved Is condition considered a special word in mySQL?
I guess simple CASE and GROUP BY should work select market, sum(case when type=”sell” then -amount when type=”buy” then amount end) from data group by market 2 solved Can we achieve this if yes then what will the SQL query for same
use update $sql=”update TABLENAME set GAME1 = case when GAME1 = ” then $item3 else GAME1 end, GAME2 = case when GAME2 = ” and GAME1 <> ” then $item3 else GAME2 end, GAME3 = case when GAME3 = ” and GAME1 <> ”and GAME2 <> ” then $item3 else GAME3 end WHERE ID = … Read more
The short answer is that mysql_fetch_array is not a PDO method. It comes from the deprecated mysql_* API. solved Fatal error: Uncaught Error
Just change the condition to: if(isset($_REQUEST[‘userid’]) && $_REQUEST[‘userid’] > $user_hack) isset tells is a variable is set, while this statement may be true or false, on which you cannot call isset function. Until you check if(isset($_REQUEST[‘userid’])), you cannot assign it to $userid variable. 2 solved Fatal error in if stament [duplicate]
Used LIKE query. Please try this query:- SELECT * FROM Datauser WHERE Plans LIKE “109” OR Plans LIKE “109,%” OR Plans LIKE “%,109” OR Plans LIKE “%,109,%” Which simply means that there can be 4 conditions in the column: plans column has only ‘109’ in it, or ‘,109,’ in it or ‘109,’ in it, or … Read more
How can I optimize a query that returns a lot of records, then order by a date field and return only the latest one? [duplicate] solved How can I optimize a query that returns a lot of records, then order by a date field and return only the latest one? [duplicate]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ) solved You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near )