Jump to content

hno

Members
  • Posts

    255
  • Joined

  • Last visited

Everything posted by hno

  1. HI, I want to make a query that have tow part.The first part is a query that should run from table A and the second part should run from the table B.One of the rows that fetch from table A is 'user_id' which the second part should run by according to the 'user_id''s and it's a clause for the second query and the rows that should return from table B are just has the id's from table A. My english is not good and I apologize for that. Thanks
  2. I have a big form and I have to get many information . i get them by using this code for ($i=1;$i<=7;$i++){ for ($l=1;$l<=10;$l++){ $need_or=0; $ok=''; $k=''; $first_time=1; foreach($arr as $key=>$val){ if ($need_or)$k='or'; if ($_POST[$i .'_' . $l . '_' . $val]=='true'){ if ($first_time)$q.=' and ( '; $q.=" $k '". $i .'_' . $l . '\'' .' = ' .$key; $need_or=1; $first_time=0; } } if ($first_time==0)$q.=' ) '; } } $q{0}='';$q{1}='';$q{2}='';$q{3}=''; $q="SELECT * FROM `questions` WHERE $q "; And then I run the query by using those codes.
  3. $r=mysqli_query($conn,$q); if (mysqli_num_rows($r)>=1){ //some code } The error is from "mysqli_num_rows($r) " . Thanks
  4. HI, I have write a script and it's make a query like this:"SELECT * FROM `questions` WHERE ( '1_1' = 1 or '1_1' = 2 ) and ( '1_2' = 1 ) and ( '1_3' = 1 or '1_3' = 2 ) and ( '1_4' = 1 or '1_4' = 2 ) " but When I run it with php it gives me this error:"You have an error in SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1" but When I copy the query to the phpmyadmin and run it manually it shoes me the rows. What's the problem?Why phpmyadmin run the query successfully but php couldn't run it ? Thanks
  5. I can write it but I don't need all of them , I just want some of them , If i want to like some thing like this , Where I can find some more details about them I don't think anyone has written a script for free use that just has a bunch of scripts to display... That you would have to do urself... I can pay for it , just introduce me some of them , it's better to have demo then I will choose one of them and I'll pay thanks
  6. I can write it but I don't need all of them , I just want some of them , If i want to like some thing like this , Where I can find some more details about them
  7. I want to have a web site like free-webmaster-tools.com/ that has losts of services like Meta Tag Generator , or page rank checker and some things like these ,
  8. HI I want to make a webmaster tools web . I want the script of it , how can I do so ? thanks
  9. Hi every one I have a php market web site and an asp.net web site . I want to retrieve the person's id from the market and store them in the sql server 2005 with some other things . how can I do so ? It's urgent pelase help me thanks
  10. for example this is one of them , http://www.scriptol.com/rss/rss-reader.php It couldn't retrieve images , what should I do ? thanks
  11. can you explain it more ? I didn't understand
  12. HI every one I need a feed reader that I give the feed address(rss2 , atom , .. ) to it and then it retrieve the feeds( both text and images ) from that address and display the data on my web page. How can I do so ? I have tried some script but all of them had some problems , for example , they didn't retrieve just a summery of it , another one just retrieve text without images , another one just showing the rss2 and it couldn't work with atom please help me thanks
  13. HI, I want to make a web site that every one can sign up and after that they would have a subdomain of my site name just like web log system .You know blogfa bogging system and when every one makes a new account they have a subdomain of that site. I want to make something like that ,and after every ones registered they would have a subdomain of my site with a script installed it it. How can make something like that? I apologize for my bad english. Thanks
  14. what about rpg or multiplay games ? where I can find them and does they need to load while playing ? thanks
  15. Hi every one I want to make a online game web site with all types of games , i mean flash games , Arcade games , rpg games , multiplay games . I have no problem with flash games . I'm working on Arcade games and I have downloaded some of them but I have a question each Arcade game is about 10 MB and I should upload it on my web site . The problem is this , If some one wants to play on of the Arcade games , He/she should be downloaded on his computer or not ? he could play the games without he's downloaded it . Another question is this, which types of games are more popular now and where I can find them ? thanks very much
  16. No , I want to write it my self , I want to enter the feed url and it show me the feeds how can I do so
  17. I'm still waiting , please help me thanks
  18. Hi I need a script that it uses ftp for transferring a folder from host1 to host 2 . I have searched a lot and i have tried lots of scripts but they weren't work please give me a script that has been used by you , and you sure that it work good best regards
  19. i changed the ftp_path to "$ftp_path = '"/public_html/sssss.htm';" but it didn't make different please help me , have you written a ftp function to making back ups from your files ? plz , give me some examples thanks
  20. sorry, it is not say "success" and its not make anything . there is not error message thanks for your reply please help me , it's very important . have you ran a back up script ? please give me some examples thanks
  21. i changed the ftp_path to "$ftp_path = '"/public_html/sssss.htm';" but it didn't make different
  22. sorry, it is not say "success" and its not make anything . there is not error message thanks for your reply
  23. thanks for your reply ,but it runs on command line . I want to make a script that runs by cron job every day and make a backup from database automatically
  24. I changed the path but it wasn't work how can I do so ?
  25. HI I have written this script to geting back up from data base and save it in a file : ob_start(); $db=mysqli_connect("localhost","root","","php"); $tableName = 'user'; $backupFile = 'b/user.sql'; $query= "SELECT * INTO OUTFILE '$backupFile' FROM $tableName"; $result = mysql_query($query); echo mysqli_connect_error() ; if ($result) echo "success"; it is not working what is the problem ? thanks
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.