Variable inside mysql_query

Codewalkers Forums Sponsor:

October 8th, 2002, 05:02 PM

alsaffar

Join Date: Apr 2007

Posts: 58

Time spent in forums: < 1 sec
Reputation Power: 2

Variable inside mysql_query

Hi there,

How I can use a varibale inside mysql_query?

I'm passing a varibale $TableName to a function, and inside the function I make my query depend on the passed variable.

$TableName = 'Users';
TestFunction($TableName);

Function TestFunction($TableName)
{
$Query = " SELECT ID FROM $TableName ";
$Result = mysql_query($Query) or die("Query Failed");
}

How I can get this function works fine?

October 8th, 2002, 05:23 PM

Anonymous

Registered User

Codewalkers God 35th Plane (22000 - 22499 posts)

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

RE: Variable inside mysql_query

remove the spaces from the front and end:

$Query = "SELECT ID FROM $TableName";

October 10th, 2002, 12:02 AM

zombie

Codewalkers Intermediate (1500 - 1999 posts)

Join Date: Apr 2007

Location: serbia

Posts: 1,876

Time spent in forums: < 1 sec
Reputation Power: 3

RE: Variable inside mysql_query

i am sure that spaces dont matter!

but i think that that code should work. what error do u get? do you even get an error? did u connect with mysql_connect()? did it success?

do you know that mysql_query() doesn't return the value of the 'ID' field, (or any other field) but just a resource id, and u have to use that RID to get value of any field?

(example from php man

php Code:

Original - php Code
<?php mysql_connect("localhost", "mysql_user", "mysql_password"); mysql_select_db("mydb"); $query = "select * from table"; $result = mysql_query($query); while ($row = mysql_fetch_assoc($result)) { echo $row["user_id"]; echo $row["fullname"]; } mysql_free_result($result); ?>

 
<?php
   mysql_connect("localhost", "mysql_user", "mysql_password");
   mysql_select_db("mydb");
   $query = "select * from table";
   $result = mysql_query($query);
   while ($row = mysql_fetch_assoc($result)) {
       echo $row["user_id"];
       echo $row["fullname"];
   }
   mysql_free_result($result);
?>

this is how u get field values from php!

October 11th, 2002, 10:27 AM

crickettdt

Join Date: Apr 2007

Location: Chippenham

Posts: 4

Time spent in forums: < 1 sec
Reputation Power: 0

RE: Variable inside mysql_query

To add:

If you want to fetch a row from the database, use the php function:

mysql_fetch_row

The way to do this is to assign a variable

$row = mysql_fetch_row($query)

then;

echo $row[0];

It then treats the row as an array.

To make it simpler, you can use mysql_fetch_array

then use

echo $row["name of field"];

Allowing you to call the fields by the same names they have in your db.

October 18th, 2002, 04:47 PM

Anonymous

Registered User

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

RE: Variable inside mysql_query

I am using the code from "Creating Dynamic Content with PHP and MySql" tutorial (see below):

And I get this error from the browser:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in...this line: while($myrow = mysql_fetch_array($result))

Code:

php Code:

Original - php Code

 
<HTML> 
<?php 
$db = mysql_connect("localhost", "moontots_tester", "tester"); 
mysql_select_db("moontots_",$db); 
$result = mysql_query("SELECT * FROM testdb",$db); 
echo "<TABLE>"; 
echo"<TR><TD><B>Full Name</B><TD><B>Nick Name</B><TD><B>Salary</B></TR>";
while($myrow = mysql_fetch_array($result)) 
{ 
echo "<TR><TD>"; 
echo $myrow["firstname"]; 
echo " "; 
echo $myrow["lastname"]; 
echo "<TD>"; 
echo $myrow["nick"];  
echo "<TD>"; 
echo $myrow["salary"]; 
} 
echo "</TABLE>"; 
?> 
</HTML>

October 19th, 2002, 12:24 AM

postalcow

Codewalkers Beginner (1000 - 1499 posts)

Join Date: Apr 2007

Location: Ford CIty, PA USA

Posts: 1,267

Time spent in forums: < 1 sec
Reputation Power: 3

RE: Variable inside mysql_query

Anonymous try to post different questions in its own thread. Here try this

php Code:

Original - php Code

 
<html>
 
<?
$db_name = "moontots_";
$tablename = "testdb";
$connection = mysql_connect ("localhost", "moontots_tester", "tester") or die ("Unable to connect");
$db = mysql_selectdb($db_name, $connection) or die ("Unable to Connect to the database");
 
$sql = "SELECT * FROM $tablename";
 
$result = @mysql_query($sql,$connection)
        or die (mysql_error());
 
echo "<TABLE>"; 
echo"<TR><TD><B>Full Name</B><TD><B>Nick Name</B><TD><B>Salary</B></TR>";
 
while ($myrow = mysql_fetch_array($result)) {
 
$firstname =$row['firstname'];
$lastname =$row['lastname'];
$nick =$row['nick'];
$salary =$row['salary'];
 
}
 
echo "<TR><TD>"; 
echo "$firstname" ;
echo " "; 
echo "$lastname" ; 
echo "<TD>"; 
echo "$nick";  
echo "<TD>"; 
echo "$salary";  
echo "</TABLE>"; 
?> 
</html>

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: