[How to make this query]

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

[Problem with executing a query]

Relevant!! We need to see where you assign a value to $q

 

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.

 

[Problem with executing a query]

Can you post some relevant & actual code?

 

$r=mysqli_query($conn,$q);

if (mysqli_num_rows($r)>=1){

  //some code

}

 

The error is from "mysqli_num_rows($r) " .

Thanks

[Problem with executing a query]

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

[need webmaster tools script]

That's a big task. If you don't want to write it yourself, hire someone to do it. Post in the Freelance section.

 

Ken

 

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

[need webmaster tools script]

That's a big task. If you don't want to write it yourself, hire someone to do it. Post in the Freelance section.

 

Ken

 

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

[need webmaster tools script]

Through a painstaking boring process.

 

What exactly do you want again?

 

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 ,

 

 

[need webmaster tools script]

HI

 

I want to make a webmaster tools web . I want the script of it , how can I do so ?

 

thanks

[how to connect mysql to sql server 2005 via php, urgent]

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

[need rss reader]

Try this

EDIT*

We prefer to help people who have code. Try the 3rd party or freelancing section for more help.

 

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

[How to make subdomain by php]

use mod_rewrite, anyway this is Apache issue

 

can you explain it more ? I didn't understand

[need rss reader]

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 

[How to make subdomain by php]

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

[qustion about making an online game web site]

I run gamejoker.net, which I assume is something similar to what you want to do ...

 

The way it works is you use <embed> and embed the swf file for each game... the user then clicks on the game and it is displayed on his screen. He's not downloading the game, it's kind of like watching a video on youtube, you don't save the video, but you get to watch it anyhow.

 

Also, if you want to find good games for your site, check out mochiads.com, they have tons and tons (and tons) of games you can add. Best if you download the files and upload them on your system, if you simply use their embed code, you don't get credit each time someone plays.  Check it out.

 

what about rpg or multiplay games ? where I can find them and does they need to load while playing ?

 

thanks

[qustion about making an online game web site]

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

[need a rss reader]

http://reader.google.com

 

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

[need a php script for transfering files use ftp]

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

 

I'm still waiting , please help me

thanks

[need a php script for transfering files use ftp]

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 

[problem using ftp]

What did you change the path to, would be pretty useful to know?  When you FTP something you have to give the explicit.. absolute path to where it's going.. not just  "install.htm"

 

There could be 300 install.htm's on that FTP server.

 

an example path would be

$ftp_path = "/public_html/MyAwesomeInstaller";

 

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

[prblem with geting back up from db]

Well the main problem I can see is you've not provided us with enough details to help. In what way does it not work, what appears on screen? Does it say success but the file isn't there? Is the file there but empty? Does the screen not say success but has an error message? If so what? Is the screen blank and there's no file?

 

Help us, help you.

 

 

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

[problem using ftp]

What did you change the path to, would be pretty useful to know?  When you FTP something you have to give the explicit.. absolute path to where it's going.. not just  "install.htm"

 

There could be 300 install.htm's on that FTP server.

 

an example path would be

$ftp_path = "/public_html/MyAwesomeInstaller";

 

i changed the ftp_path to  "$ftp_path = '"/public_html/sssss.htm';" but it didn't make different

 

[prblem with geting back up from db]

Well the main problem I can see is you've not provided us with enough details to help. In what way does it not work, what appears on screen? Does it say success but the file isn't there? Is the file there but empty? Does the screen not say success but has an error message? If so what? Is the screen blank and there's no file?

 

Help us, help you.

 

sorry, it is not say "success" and its not make anything . there is not error message

 

thanks for your reply

[prblem with geting back up from db]

db backups are a lot easier from the command line ( using mysqldump )

 

mysqldump -h host -u user -p passwd db > backup.sql

 

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

 

 

[problem using ftp]

you probably don't have access to write to the directory you start in.. try changing directories.

 

I changed the path but it wasn't work

how can I do so ?

[prblem with geting back up from db]

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